Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to store Output variables of a Stored Procedure in java

 
Sankha Ray
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi , i am writting a java program which will call a Stored procedure.

The Stored Procedure will -1.populate a staging table
2. return 2 output variables(both are integers)

Any help on how to store these 2 variables in the java program?Because i am seeing that the prepareCall() method is returning a resultset ,which i clearly don't need.
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check this JDBC guide.
 
Sankha Ray
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi , i went through the document. But if i want to return a boolean value from the stored procedure , how the mapping will be done?I saw the bit datatype....but could not understand the concept.
Can you help me in understanding it ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic