wood burning stoves 2.0*
The moose likes JDBC and the fly likes Access Violation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Access Violation" Watch "Access Violation" New topic
Author

Access Violation

Mohammed Yousuff
Ranch Hand

Joined: Apr 18, 2006
Posts: 45
Hi

Please let me know the reason for the follwoing error. This part of the application is based on the Quartz Component,which will run the Job which are scheduled. I am not sure why this error was thrown.


java.sql.SQLException: ORA-00001: unique constraint (SSP.SYS_C005540) violated

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Inlined Compiled Code))
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code))
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code))
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at com.honeywell.sspglobal.task.dao.HbTaskDao.insertData(HbTaskDao.java:541)
at com.honeywell.sspglobal.task.dao.HbTaskDao.saveGBRData(HbTaskDao.java:519)
at com.honeywell.sspglobal.task.MonthEndFreezeTask.GBRSynchronize(MonthEndFreezeTask.java:146)
at com.honeywell.sspglobal.task.MonthEndFreezeTask.execute(MonthEndFreezeTask.java:67)
at com.honeywell.reuse.spring.service.task.HoneywellSchedulerJob.execute(HoneywellSchedulerJob.java:33)
at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)



Thanks in Advance


Regards<br /> <br />Mohammed Yousuff M N <br /> <br />Try NOT to Become a man of SUCCESS, BUT Try to Become a man of VALUE..
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41063
    
  43
You need to find out what kind of constraint that is - does it originate from Quartz, or from your other application code, or is it an Oracle system thing? Your DB administrator can help you with this.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Access Violation
 
Similar Threads
init.ora parameter HELP
ORACLE JDBC ERROR ORA-00600
Need help with Jave Oracle Connection
invalid host/bind variable name
JDBC connection using eclipse ide