jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes tracking ORA errors. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "tracking ORA errors." Watch "tracking ORA errors." New topic

tracking ORA errors.

T sandya
Ranch Hand

Joined: Aug 03, 2006
Posts: 64
hi friends,
In any enterprise applications we will get ORA errors like below on browser,

ORA-01008: not all variables bound

some users know what is the problem it is and why it is coming,but some users don't know.To know all i want to track that error and i want to give user friendly message for console users,what's the problem exactly it is.how can i achive that.

thanks in advance.

Marcelo Ortega
Ranch Hand

Joined: May 31, 2005
Posts: 528

Hi T Sandya,
These are standard Oracle database errors, which you receive through your JDBC connection (as the message in the exception thrown). What we do at Contactel ltd is create a properties file with the error code as the key and a user-friendly explanation as the value. Then all you need to do is, when
you receive an exception from a data base operation, parse the msgException received and use it as the key into the properties file, where you will find the user-friendly explanation.



Live life to an interface, not an implementation!
I agree. Here's the link: http://aspose.com/file-tools
subject: tracking ORA errors.
It's not a secret anymore!