Re: Fw: mapping java objects with postgresql types

Hi Oussema,

Please refer any questions regarding pgjdbc-ng to them

Thanks,

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 23 January 2015 at 09:36, Oussema Benjemaa <ousema2003(at)yahoo(dot)fr> wrote:

> i downloaded this JAR pgjdbc-ng-0.3-complete.jar ...
> i'm asking if there is exemple for mapping java objects to postgresql ...
> with this api
>
>
>
> Oussema Benjemaa
> Sr Oracle DBA / Trading Software Development
> SunGard Financial Systems, Tunis
> E-mail : ousema2003(at)yahoo(dot)fr
> Mobile : 0021622800497
>
>
> On Thursday, 22 January 2015, 13:14, Andreas Joseph Krogh <
> andreas(at)visena(dot)com> wrote:
>
>
> På torsdag 22. januar 2015 kl. 17:00:25, skrev Oussema Benjemaa <
> ousema2003(at)yahoo(dot)fr>:
>
>
> Hi,
>
> I want to pass array of complex type from java into plpgsql function
>
> I already tried using JDBC Array and Struct types, but postgresql jdbc
> driver doesn't implement Struct yet so we weren't able to get thinks work
>
> (in addition of the fact that. (Connection.createStruct is not implemented
> 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 for text representation of nested types .
>
> Could you please advice ...
>
> Oussema BenJemaa
> Senior DBA
>
>
> Try https://github.com/impossibl/pgjdbc-ng
>
> --
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas(at)visena(dot)com
> www.visena.com
> <https://www.visena.com/>
>
>
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>