Two Laptop Bag*
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "tracking ORA errors." Watch "tracking ORA errors." New topic
Author

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.

regards,
sandya.
Marcelo Ortega
Ranch Hand

Joined: May 31, 2005
Posts: 519

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.

Regards.


SCJP 1.4, SCWCD 1.4, SCBCD 1.3, SCJD, SCEA/OCMJEA

Live life to an interface, not an implementation!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: tracking ORA errors.
 
Similar Threads
getting error while droping the user in oracle.
Not able to drop user Oracle10.2.0.3 Ent Ed.
how to get the connection pool object
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12640:
Passing an array of integers to stored procedure