Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-02289: sequence does not exist

 
Y Jadhav
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is error in stdout.log of tomcat...

It seams sequence does not exist ,I don't by what name that 'sequence' to be create ...How can we decide name of sequence to be create...


67682204 [http-8080-1] WARN : util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
67682204 [http-8080-1] ERROR: util.JDBCExceptionReporter - ORA-02289: sequence does not exist

67682204 [http-8080-1] ERROR: Connect - Exception In InsertViaHibernate Servlet: could not get next sequence value
67682204 [http-8080-1] ERROR: [/strutshibernate].[InsertViaHibernate] - Servlet.service() for servlet InsertViaHibernate threw exception
javax.servlet.ServletException
at tomcatJNDI.InsertViaHibernate.doGet(InsertViaHibernate.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:835)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
at java.lang.Thread.run(Unknown Source)


Please Help me!!!
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It sounds like you are using Hibernate and a key generation startegy that requires a sequence. If you are, I'd start by reading the documentation about key generation. If you are still struggling, post your mapping file.
 
Y Jadhav
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Driver.hbm.xml
]

car.hbm.xml


These are my table mapping files..Do I have to make any changes to these files???
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Perhaps, depending on your design. Why have you picked a native key generation strategy? Is that the one you want to use? (see the documentation if you don't understand the differences).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic