• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access Violation

 
Mohammed Yousuff
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic