It appears I resolved it... driver classname and driver name were wrongly populated earlier.
On Fri, Mar 28, 2014 at 12:01 PM, Venkateswar Reddy Melachervu <vmelachervu@gmail.com> wrote:
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. 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@yahoo.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.