This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Problem with Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with Stored Procedure" Watch "Problem with Stored Procedure" New topic
Author

Problem with Stored Procedure

Josue Cedeno
Ranch Hand

Joined: Feb 06, 2001
Posts: 71
Currently I have a stored procedure which evaluates three scenarios and appends to a temporary table depending on the selection.
if 1
insert temp table
if 2
insert temp table
if 3
insert temp table
display temp table
On the command line this works fine, but when I call this stored procedure using the jdbc-odbc bridge I can only retrieve a resultset when the option is "3"
Any ideas?
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Josue
It could be any number of things, let us see the code and we can take a look at it.


Dave
Josue Cedeno
Ranch Hand

Joined: Feb 06, 2001
Posts: 71
I emailed the code. I really appreciate your help. I've tried isolating the problem and it still doesn't make sense.
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Josue
Sorry, I didn't realize that the actual problem was with a stored procedure, I thought it was with the java that called it. I am not a stored procedure expert so can't help you.
You might want to post the relevant sections here so someone else can check them out.
 
Have you checked out Aspose?
 
subject: Problem with Stored Procedure
 
jQuery in Action, 3rd edition