JOOQ fails with PostgreSQL Custom Type as an Array: ERROR: malformed record literal -


i have following custom type on postgres:

create type my_custom_type (  field_a varchar,  field_b numeric(10,3)  );

and following table:

create table my_table (  col1 varchar(120) not null,  custom_column  my_custom_type,  custom_column_array my_custom_type[] );

everything works fine when use custom type jooq:

@test public void testwithoutarray(){     mytablerecord record = dsl.newrecord(mytable.my_table);      record.setcol1("my col1");     mycustomtype customtype = new mycustomtype();     customtype.setfielda("field val");     customtype.setfieldb(bigdecimal.one);     record.setcustomcolumn(customtype);      record.store(); }

however, when try set value in field mapped custom type array, have following error:

@test public void testwitharray(){     mytablerecord record = dsl.newrecord(mytable.my_table);      record.setcol1("my col1");     mycustomtyperecord customtype = new mycustomtyperecord();     customtype.setfielda("field val 1");     customtype.setfieldb(bigdecimal.one);      mycustomtyperecord customtype2 = new mycustomtyperecord();     customtype2.setfielda("field val 2");     customtype2.setfieldb(bigdecimal.ten);      record.setcustomcolumnarray(new mycustomtyperecord[]{customtype, customtype2});     record.store(); }  org.jooq.exception.dataaccessexception: sql [insert "my_table" ("col1", "custom_column_array") values (?, ?::my_custom_type[]) returning "my_table"."col1"]; error: malformed record literal: "my_custom_type"(field val 1, 1)"  detail: missing left parenthesis.     @ org.jooq.impl.utils.translate(utils.java:1553)     @ org.jooq.impl.defaultexecutecontext.sqlexception(defaultexecutecontext.java:571)     @ org.jooq.impl.abstractquery.execute(abstractquery.java:347)     @ org.jooq.impl.tablerecordimpl.storeinsert0(tablerecordimpl.java:176)     @ org.jooq.impl.tablerecordimpl$1.operate(tablerecordimpl.java:142)     @ org.jooq.impl.recorddelegate.operate(recorddelegate.java:123)     @ org.jooq.impl.tablerecordimpl.storeinsert(tablerecordimpl.java:137)     @ org.jooq.impl.updatablerecordimpl.store0(updatablerecordimpl.java:185)     @ org.jooq.impl.updatablerecordimpl.access$000(updatablerecordimpl.java:85)     @ org.jooq.impl.updatablerecordimpl$1.operate(updatablerecordimpl.java:135)     @ org.jooq.impl.recorddelegate.operate(recorddelegate.java:123)     @ org.jooq.impl.updatablerecordimpl.store(updatablerecordimpl.java:130)     @ org.jooq.impl.updatablerecordimpl.store(updatablerecordimpl.java:123)

the query generated jooq debugg following:

debug [main] org.jooq.tools.loggerlistener#debug:255 - executing query          : insert "my_table" ("col1", "custom_column_array") values (?, ?::my_custom_type[]) returning "my_table"."col1" debug [main] org.jooq.tools.loggerlistener#debug:255 - -> bind values      : insert "my_table" ("col1", "custom_column_array") values ('my col1', array[[udt], [udt]]) returning "my_table"."col1"

am missing configuration or bug?

cheers

as stated in relevant issue (https://github.com/jooq/jooq/issues/4162), missing piece of support kind of postgresql functionality. answer given in issue far is:

unfortunately, area have work around couple of limitations of postgresql jdbc driver, doesn't implement sqldata , other api (see pgjdbc/pgjdbc#63).

currently, jooq binds arrays , udts strings. seems particular combination not yet supported. able work around limitation implementing own custom data type binding:

http://www.jooq.org/doc/latest/manual/code-generation/custom-data-type-bindings/


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more