wood burning stoves 2.0*
The moose likes JDBC 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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 agree. Here's the link: http://aspose.com/file-tools
 
subject: Empty SQLException on attempt to run a stored procedure
 
Similar Threads
Webapp hang when calling stored procedure
help:java.sql.SQLException: ORA-06550
Calling Oracle stored procedures in JRun container
Servlets and PL\SQL
Problem with stored procedure table parameter