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 Empty SQLException on attempt to run a 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 "Empty SQLException on attempt to run a stored procedure" Watch "Empty SQLException on attempt to run a stored procedure" New topic
Author

Empty SQLException on attempt to run a stored procedure

N. Ounce
Greenhorn

Joined: Oct 17, 2006
Posts: 6
I am using Progress OpenEdge JDBC driver, and I have written a stored procedure in the database, that checkes if an entered user exists in the ApplicationAdministrators table. When I create a procedure, it shows that there are no errors in it, and the query that I use to get a correct password works fine when run individually.
I call my procedure from my Java Application as follows:


after this line it breaks with an empty SQLException. Why???
Thank you.
Josh Juneau
Ranch Hand

Joined: Jun 16, 2004
Posts: 86
Did you try to do a getNext() on the resultset?

Usually when working with resultsets you will need to get the next result by making a getNext() call.

Hope this helps...


Database Administrator/Application Developer
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Empty SQLException on attempt to run a stored procedure
 
It's not a secret anymore!