Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes database procedures 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 "database procedures" Watch "database procedures" New topic
Author

database procedures

Grace Russo
Ranch Hand

Joined: Nov 08, 2010
Posts: 64
Does anyone know why when I run a database procedure directly through the debugger, I hit no exceptions; however, when I run it through code, I reach exceptions.
The input parameters are the same.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30068
    
149

What exception do you get?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Grace Russo
Ranch Hand

Joined: Nov 08, 2010
Posts: 64
Jeanne Boyarsky wrote:What exception do you get?


TOO_MANY_ROWS.

What type of exception I get is not the problem. THe problem is that I do get the exception when I run the procedure through the code, but not when I run it through the SQL Developer debugger with the same input parameters of the code.
I wish I could get the exception when I run the procedure with the SQL Developer debugger ...
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I would guess this is because you are connecting as different users.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Grace Russo
Ranch Hand

Joined: Nov 08, 2010
Posts: 64
the privileges are the same, though
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Do your two users have access to the same schema? i.e. does your exact fetch query access the same table, or a table with the same name (though possible different data) in the schema the users connects to?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: database procedures
 
Similar Threads
Tomcat CGI & Database Connectivity
Quick question on the B&S interface
Exceptions
Small SQL databases for JUNIT tests
Fianlly passed, 376/400, sneering