java.sql.SQLSyntaxErrorException: SEQUENCE 'APP.PATIENT_ID_SEQ' does not exist 17:52:50,291 ERROR [stderr] (ajp-localhost/127.0.0.1:8009-1)

Stack Overflow | laput | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    embedded apache derby sequence

    Stack Overflow | 8 months ago | laput
    java.sql.SQLSyntaxErrorException: SEQUENCE 'APP.PATIENT_ID_SEQ' does not exist 17:52:50,291 ERROR [stderr] (ajp-localhost/127.0.0.1:8009-1)
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    error when updating rating

    GitHub | 2 years ago | jcoady9
    persist.PersistenceException: Transaction failed
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

    SEQUENCE 'APP.PATIENT_ID_SEQ' does not exist 17:52:50,291 ERROR [stderr] (ajp-localhost/127.0.0.1:8009-1)

    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException()
  2. Derby
    EmbedConnection.prepareStatement
    1. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    2. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    3. org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    4. org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    5. org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    6. org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    7. org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
    8. org.apache.derby.jdbc.InternalDriver.newEmbedPreparedStatement(Unknown Source)
    9. org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    10. org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    10 frames
  3. com.laput.dao
    PatientDAO.savePatientInfo
    1. com.laput.dao.PatientDAO.savePatientDetails(PatientDAO.java:30)
    2. com.laput.dao.PatientDAO.savePatientInfo(PatientDAO.java:21)
    2 frames
  4. com.laput.controller
    HospController.login
    1. com.laput.controller.HospController.login(HospController.java:66)
    1 frame
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  6. Spring
    InvocableHandlerMethod.invokeForRequest
    1. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
    2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
    2 frames
  7. Spring MVC
    FrameworkServlet.doPost
    1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:114)
    2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
    3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
    4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
    6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
    7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    8 frames
  8. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
    1 frame
  9. Spring MVC
    FrameworkServlet.service
    1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    1 frame
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    1 frame
  11. Glassfish Core
    StandardContextValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
    4 frames
  12. JBoss Web
    SecurityContextAssociationValve.invoke
    1. org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
    1 frame
  13. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
    3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
    4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336)
    4 frames
  14. org.apache.coyote
    AjpProtocol$AjpConnectionHandler.process
    1. org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:488)
    2. org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:420)
    2 frames
  15. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920)
    1 frame
  16. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:744)
    1 frame
  17. Derby
    DMLStatementNode.bindExpressions
    1. org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    2. org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    3. org.apache.derby.impl.sql.compile.NextSequenceNode.bindExpression(Unknown Source)
    4. org.apache.derby.impl.sql.compile.ValueNode.bindExpression(Unknown Source)
    5. org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
    6. org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
    7. org.apache.derby.impl.sql.compile.RowResultSetNode.bindExpressions(Unknown Source)
    8. org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
    8 frames