From: | Oussema Benjemaa <ousema2003(at)yahoo(dot)fr> |
---|---|
To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | mapping java objects with postgresql types |
Date: | 2015-01-22 15:39:39 |
Message-ID: | 747805532.5625574.1421941179304.JavaMail.yahoo@jws11165.mail.ir2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
I want to pass array of complex type from java intoplpgsql function
I already tried using JDBC Array and Structtypes, but postgresql jdbc driver doesn't implement Struct yet so weweren't able to get thinks work
(in addition of the fact that. (Connection.createStruct is notimplemented in postgres JDBC)
and actually as solution , i'm using PGObject to push the data to the database with some diffuclts with the syntax and this is mainly for types composites having bytea datatype ..
but finally i succeded to push data to the database with the usage of the text representation of the array of the type composite .
But i'm strongly , looking for an alternative of the PGObject , to avoid passing complex structures (array of types) from jdbc with text representation.
ALso i didn't found documentation for passing such as complex structures including the the rules fortext representation of nested types .
Could you please advice ...
Oussema BenJemaaSenior DBA
From | Date | Subject | |
---|---|---|---|
Next Message | Oussema Benjemaa | 2015-01-22 16:00:25 | Fw: mapping java objects with postgresql types |
Previous Message | Dave Cramer | 2015-01-20 22:23:19 | Re: logLevelSet is not going from PGPoolingDataSource to PGPoolConnectionDataSource |