How to log error in sql to log file

[tedy2808]

Hi guys, I quite new to java and not really good in it..
I need you guys to guide me on this...I need to upgrade a system that using java in linux. My question is,let say there are errors occur in database, i need the error message to be logged/recorded in a log file and send email to people in recipient list.Thus, below are the example when there are error in my db..

Exception in thread "main" java.sql.SQLException: ORA-00001: unique constraint (PIN.I_RESELL_ORG_CODE) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 742)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:212)
at oracle.jdbc.driver.T4CPreparedStatement.executeFor Rows(T4CPreparedStatement.java:951)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1159)
at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3284)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:3367)
at Popular.<init>(Popular.java:94)
at Popular.main(Popular.java:117)


do i have to install any logging packages? or only create simple java script for it?

Seriously, i have no idea as i never encountered this situation..Really need someone to guide me on this.:confused:Thanks in advanced.

[Tolls]

Look up log4j as a start point.
You'll need to read up on how to set it up properly.