Re: Re: Inputs Appreciated - Calling pgsql stored proc with user defined sql types from java using pgsql-jdbc

ok. Thanks for the quick response Dave.

This post provides a for achieving what my solution requires - passing user
defined data types to stored
procedures<https://groups.google.com/forum/#!topic/pgsql.interfaces.jdbc/Tj-LUrhFowQ>.
I followed this post ( of course, adapted it to suit for jdbc41 pgsql
driver). Per this to add the data type, the jdbc connection needs to be
cast to pgconnection and this casting is resulting in a run time exception
- (java.lang.ClassCastException) java.lang.ClassCastException:
org.postgresql.jdbc4.Jdbc4Connection cannot be cast to
org.postgresql.PGConnection.

This was not the case with pgsql8.3 with jdbc3/4 pgsql driver.

Any pointer/inputs to resolve this are highly appreciated.

V

On Fri, Mar 28, 2014 at 10:52 AM, David Johnston <polobo(at)yahoo(dot)com> wrote:

> Venkateswar Reddy Melachervu wrote
> > Hello All,
> > Any inputs/pointers for the below are highly appreciated.
> >
> > Problem
> > When trying to conn.registerOutParameter(2,
> > Types.STRUCT,"type_customer_details_for_subscription") for a pgsql stored
> > proc with user defined type from java1.7 using jdbc41 pgsql driver to
> > pgsql9.3 is resulting in error when type maps are used -
> > SQLFeatureNotSupportedException: Method
> >
> org.postgresql.jdbc4.Jdbc4CallableStatement.registerOutParameter(int,int,String)
> > is not yet implemented.
> >
> > Somehow I was under the impression that struct for sql is base type and
> > pgsql jdbc driver can support it. But going by above exception message,
> it
> > it not. am I doing something wrong (have to create some struct pointers
> > etc. before registering the type) or it is the way pgsql jdbc driver is
> > built. Is there any way out - any pointer?
> >
> > --
> > Regards,
> > Venkateswar Reddy Melachervu
> > "...dare to dream, care to win..."
> > www.linkedin.com/in/vmelachervu
>
> registerOutParameter(...) is not implemented - it doesn't matter what the
> actual argument values are.
>
> Sorry, no help on the solution.
>
> David J.
>
>
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Inputs-Appreciated-Calling-pgsql-stored-proc-with-user-defined-sql-types-from-java-using-pgsql-jdbc-tp5797743p5797744.html
> Sent from the PostgreSQL - jdbc mailing list archive at Nabble.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
>

--
Regards,
Venkateswar Reddy Melachervu
"...dare to dream, care to win..."
www.linkedin.com/in/vmelachervu