The moose likes JDBC and Relational Databases 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 OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
Rancher

Joined: Mar 22, 2005
Posts: 42952
    
  73
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Access Violation