Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Handling database exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Handling database exception" Watch "Handling database exception" New topic
Author

Handling database exception

Elly Kut
Greenhorn

Joined: Oct 06, 2007
Posts: 1
Hello Listers, I have a question about how to "design error handling" for a generic class that accesses a database.
I want to use try/catch/finally because if there is a problem during the flow, I would like to disconnect and destroy the connection (so that's why I don't want to declare a "throws")
But at the same time, after closing the connection in the finally clause, I also want my catch statement to throw an exception, so the calling application knows something bad happened. Should I create a custom exception class (extending SQLException) and throw it in my catch clause?
Thanks for your time.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60810
    
  65

"Elly K", please check your private messages for an important administrative matter.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38087
    
  22
What is more, you ought to have posted on the JDBC forum. Moving thread.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Handling database exception
 
Similar Threads
Finally abrupt return
Effects of pressing the Browser's Stop to the Servlet
throw/catch exception
Confusion on Exception handling
How to correctly close the Connection object?