aspose file tools*
The moose likes JDBC and the fly likes Exception handling for stored procedure from Java code Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exception handling for stored procedure from Java code" Watch "Exception handling for stored procedure from Java code" New topic
Author

Exception handling for stored procedure from Java code

lakshman kumaran
Greenhorn

Joined: Aug 16, 2011
Posts: 13
how do you handle exception while writing stored procedure or accessing stored procedure from java
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

Handling the exception inside a stored procedure is obviously database specific; you'll probably find the details on your database documentation.

If there is an exception that escapes the stored procedure, it causes an SQLException to be thrown. Again, the details of how this exception is initialized are database specific, but sometimes it is possible to extract useful information from that. For example, in Oracle the SQLException message contains a stack-trace from the PL/SQL code.
 
 
subject: Exception handling for stored procedure from Java code