File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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 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!
It is sorta covered in the JavaRanch Style Guide.
subject: tracking ORA errors.
It's not a secret anymore!