Re: Fw: mapping java objects with postgresql types

Поиск
Список
Период
Сортировка
От Oussema Benjemaa
Тема Re: Fw: mapping java objects with postgresql types
Дата
Msg-id 957727519.268446.1422023812302.JavaMail.yahoo@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Fw: mapping java objects with postgresql types  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: Fw: mapping java objects with postgresql types  (Dave Cramer <pg@fastcrypt.com>)
Re: Fw: mapping java objects with postgresql types  (Andreas Joseph Krogh <andreas@visena.com>)
Re: Fw: mapping java objects with postgresql types  (Kevin Wooten <kdubb@me.com>)
Список pgsql-jdbc
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@yahoo.fr
Mobile : 0021622800497


On Thursday, 22 January 2015, 13:14, Andreas Joseph Krogh <andreas@visena.com> wrote:


På torsdag 22. januar 2015 kl. 17:00:25, skrev Oussema Benjemaa <ousema2003@yahoo.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
 


Вложения

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Fw: mapping java objects with postgresql types
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Fw: mapping java objects with postgresql types