This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills: The software developer's life manual and have John Sonmez on-line!
See this thread for details.
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access Violation

 
Mohammed Yousuff
Ranch Hand
Posts: 45
  • 0
  • 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: 42966
73
  • 0
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic