• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

tracking ORA errors.

 
T sandya
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 528
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic