Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CallableStatement : Output parameter type CURSOR

 
Deepak Kumar Jena
Ranch Hand
Posts: 71
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to register the output parameter type CURSOR for a procedure call? Gone through the JDBC API, but didn't found any specific type for it. Tried Type.OTHER in both Oracle 9i & MySQL 5.0, but didn't work. In DB2, there is DB2.CURSOR. Thanks in advance.
 
Deepak Kumar Jena
Ranch Hand
Posts: 71
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please pay attention to the above problem and help me to overcome it.
 
Lino Larios
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,im not sure if you are looking something like that


Ciao.
 
Deepak Kumar Jena
Ranch Hand
Posts: 71
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If the same program I have to run on MySQL then.....?
 
Lino Larios
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Uhm , its just for oracle data bases, for mysql

"MySQL does not support SQL cursors, and the JDBC driver doesn't emulate them, so ..."

http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-implementation-notes.html

 
Deepak Kumar Jena
Ranch Hand
Posts: 71
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
But in the reference of MySQL 5.0 it has mentioned that "Cursors are supported inside stored procedures and functions and triggers."
MySQL 5.0 Reference
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic