Thread: Use java interface "setArray" to insert the array of user-defined type to table
Use java interface "setArray" to insert the array of user-defined type to table
From
Charles Kong
Date:
Hi all,
I use a user-defined type in “schema.sql”
CREATE TYPE infoEntity AS (
"entity_id" bigint,
"seq" integer,
"message" varchar(255)
)
"entity_id" bigint,
"seq" integer,
"message" varchar(255)
)
in java code:
java_infoEntity[] infoEntityArray; //java_infoEntity is the class with the same member variables.
infoEntityArray = new java_infoEntity[3];
infoEntityArray[0] = new java_infoEntity();
....
//info_Entity's type is user-defined type "infoEntity".
sql = "insert into \"T_abc\" (info_Entity) values(?);";
statement = conn.prepareStatement( sql );
statement = conn.prepareStatement( sql );
Array array = conn.createArrayOf("infoEntity", infoEntityArray);
statement.setArray(1,array);
statement.addBatch();
statement.executeBatch();
statement.setArray(1,array);
statement.addBatch();
statement.executeBatch();
....
....
Sql throw exception:
sqlException: SQLState: 22P02 Error Code: 0 Error Message: Batch entry 0 insert into "T_abc" (info_Entity) values('{"com.xxx.java_infoEntity@597d57aa"}') was aborted: ERROR: malformed record literal: "com.xxx.java_infoEntity@597d57aa"
How to cope with it?
Re: Use java interface "setArray" to insert the array of user-defined type to table
From
Dave Cramer
Date:
On Wed, 23 Feb 2022 at 09:58, Charles Kong <kdy77k@gmail.com> wrote:
Hi all,I use a user-defined type in “schema.sql”CREATE TYPE infoEntity AS (
"entity_id" bigint,
"seq" integer,
"message" varchar(255)
)in java code:java_infoEntity[] infoEntityArray; //java_infoEntity is the class with the same member variables.infoEntityArray = new java_infoEntity[3];infoEntityArray[0] = new java_infoEntity();....//info_Entity's type is user-defined type "infoEntity".sql = "insert into \"T_abc\" (info_Entity) values(?);";
statement = conn.prepareStatement( sql );Array array = conn.createArrayOf("infoEntity", infoEntityArray);
statement.setArray(1,array);
statement.addBatch();
statement.executeBatch();........Sql throw exception:sqlException: SQLState: 22P02 Error Code: 0 Error Message: Batch entry 0 insert into "T_abc" (info_Entity) values('{"com.xxx.java_infoEntity@597d57aa"}') was aborted: ERROR: malformed record literal: "com.xxx.java_infoEntity@597d57aa"How to cope with it?
The JDBC driver does not know how to deal with user defined types. You will have to write code to serialize the type yourself.
Regards,
Dave
Hi, all
We use 32bit postgres V11 in our product, Now we want to add new process witch is 64bit
to access the 32bit progres using 64bit libpq.
I tried to access the PostgresDB 32bit v11, with 64 bit libpq V11, and it worked very nice.
So my question is, can we use 64bit lippq to access 32 bit postgres?
Thank you,
BoChen
Hi, all
We use 32bit postgres V11 in our product, Now we want to add new process witch is 64bit
to access the 32bit progres using 64bit libpq.
I tried to access the PostgresDB 32bit v11, with 64 bit libpq V11, and it worked very nice.
So my question is, can we use 64bit lippq to access 32 bit postgres?
Thank you,
BoChen