EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

problem get a ref cursor from java  XML

Forum Index » Advanced Server
Author Message
Alejandro_S.

New member

Joined: 13 Mar 2010 14:15:32
Messages: 4
Offline

Hi, i have the next problem:

i have a function what return a ref cursor, from java i do:

String query = "{? = call F_OBTIENE_DATOS(?)}";
call = (CallableStatement) conn.prepareCall(query);
call.registerOutParameter(1, Types.OTHER);
call.setString(2, '4');
call.execute();
rest = (ResultSet)call.getObject(1);

and i have the next error:

java.sql.SQLException: ERROR: cursor "<unnamed portal 1>" does not exist
at com.edb.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2662)
at com.edb.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:227
at com.edb.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:71
at com.edb.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:503)
at com.edb.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at com.edb.jdbc2.AbstractJdbc2Connection.execSQLQuery(AbstractJdbc2Connection.java:274)
at com.edb.jdbc2.AbstractJdbc2ResultSet.internalGetObject(AbstractJdbc2ResultSet.java:195)
at com.edb.jdbc3.AbstractJdbc3ResultSet.internalGetObject(AbstractJdbc3ResultSet.java:3
at com.edb.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:252
at com.edb.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:451)
at com.edb.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:423)
...............................

Please help.

Thanks

Alex
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 444
Offline

call.registerOutParameter(1, Types.OTHER);


Please use following:

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
Alejandro_S.

New member

Joined: 13 Mar 2010 14:15:32
Messages: 4
Offline

I, tanks for the answer, now it works.

 
Forum Index » Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team