javax.xml.registry.RegistryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'omar.slot' doesn't exist

kenai.com | 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

    Health Information Exchange Open Source: General Discussion: Problem installing HIEOS — Project Kenai

    kenai.com | 8 months ago
    javax.xml.registry.RegistryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'omar.slot' doesn't exist

    Root Cause Analysis

    1. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

      Table 'omar.slot' doesn't exist

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      PreparedStatementWrapper.executeQuery
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      3. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      4. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
      6. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
      7. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
      8. com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:811)
      8 frames
    3. org.freebxml.omar
      AuthenticationServiceImpl.getInstance
      1. org.freebxml.omar.server.persistence.rdb.SlotDAO.getSlotsByParent(SlotDAO.java:85)
      2. org.freebxml.omar.server.persistence.rdb.IdentifiableDAO.loadObject(IdentifiableDAO.java:283)
      3. org.freebxml.omar.server.persistence.rdb.RegistryObjectDAO.loadObject(RegistryObjectDAO.java:613)
      4. org.freebxml.omar.server.persistence.rdb.PersonDAO.loadObject(PersonDAO.java:151)
      5. org.freebxml.omar.server.persistence.rdb.AbstractDAO.getObjects(AbstractDAO.java:117)
      6. org.freebxml.omar.server.persistence.rdb.SQLPersistenceManagerImpl.getObjects(SQLPersistenceManagerImpl.java:1114)
      7. org.freebxml.omar.server.persistence.rdb.SQLPersistenceManagerImpl.executeSQLQuery(SQLPersistenceManagerImpl.java:1003)
      8. org.freebxml.omar.server.persistence.rdb.SQLPersistenceManagerImpl.getIdentifiablesMatchingQuery(SQLPersistenceManagerImpl.java:1159)
      9. org.freebxml.omar.server.persistence.rdb.SQLPersistenceManagerImpl.getIdentifiableMatchingQuery(SQLPersistenceManagerImpl.java:1190)
      10. org.freebxml.omar.server.persistence.rdb.SQLPersistenceManagerImpl.getIdentifiable(SQLPersistenceManagerImpl.java:1281)
      11. org.freebxml.omar.server.persistence.rdb.SQLPersistenceManagerImpl.getRegistryObject(SQLPersistenceManagerImpl.java:1260)
      12. org.freebxml.omar.server.security.authentication.AuthenticationServiceImpl.loadPredefinedUsers(AuthenticationServiceImpl.java:475)
      13. org.freebxml.omar.server.security.authentication.AuthenticationServiceImpl.<init>(AuthenticationServiceImpl.java:96)
      14. org.freebxml.omar.server.security.authentication.AuthenticationServiceImpl.getInstance(AuthenticationServiceImpl.java:252)
      14 frames
    4. com.vangent.hieos
      XDSbRegistry.AdhocQueryRequest
      1. com.vangent.hieos.xutil.registry.OmarRegistry.<init>(OmarRegistry.java:57)
      2. com.vangent.hieos.xutil.registry.BackendRegistry.submit_to_backend_registry(BackendRegistry.java:143)
      3. com.vangent.hieos.xutil.registry.BackendRegistry.basic_query(BackendRegistry.java:131)
      4. com.vangent.hieos.xutil.registry.BackendRegistry.query(BackendRegistry.java:83)
      5. com.vangent.hieos.xutil.query.StoredQuery.query(StoredQuery.java:194)
      6. com.vangent.hieos.services.xds.registry.storedquery.FindSubmissionSets.impl(FindSubmissionSets.java:117)
      7. com.vangent.hieos.services.xds.registry.storedquery.FindSubmissionSets.run_internal(FindSubmissionSets.java:53)
      8. com.vangent.hieos.xutil.query.StoredQuery.run(StoredQuery.java:72)
      9. com.vangent.hieos.services.xds.registry.storedquery.StoredQueryFactory.run(StoredQueryFactory.java:231)
      10. com.vangent.hieos.services.xds.registry.transactions.AdhocQueryRequest.stored_query(AdhocQueryRequest.java:297)
      11. com.vangent.hieos.services.xds.registry.transactions.AdhocQueryRequest.AdhocQueryRequestInternal(AdhocQueryRequest.java:204)
      12. com.vangent.hieos.services.xds.registry.transactions.AdhocQueryRequest.adhocQueryRequest(AdhocQueryRequest.java:102)
      13. com.vangent.hieos.services.xds.registry.serviceimpl.XDSbRegistry.AdhocQueryRequest(XDSbRegistry.java:101)
      13 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    6. com.vangent.hieos
      AbstractXDSRawXMLINoutMessageReceiver.invokeBusinessLogic
      1. com.vangent.hieos.xutil.services.framework.AbstractXDSRawXMLINoutMessageReceiver.invokeBusinessLogic(AbstractXDSRawXMLINoutMessageReceiver.java:102)
      1 frame
    7. org.apache.axis2
      AxisEngine.receive
      1. org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
      2. org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
      3. org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
      3 frames
    8. Apache Axis2 - Transport - HTTP
      AxisServlet.doPost
      1. org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
      2. org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:133)
      2 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
      2 frames
    10. Glassfish Core
      StandardPipeline.doInvoke
      1. org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:427)
      2. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:315)
      3. org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218)
      5. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
      6. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
      6 frames
    11. Glassfish
      PESessionLockingStandardPipeline.invoke
      1. com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
      2. com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
      2 frames
    12. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222)
      2. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
      3. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
      4. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
      5. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1093)
      6. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166)
      7. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
      8. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
      10. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1093)
      10 frames
    13. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:291)
      1 frame
    14. Glassfish Core
      DefaultReadTask.doTask
      1. com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:666)
      2. com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:597)
      3. com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:872)
      4. com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
      5. com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
      6. com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
      6 frames
    15. Grizzly HTTP
      PortUnificationPipeline$PUTask.doTask
      1. com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipeline.java:382)
      1 frame
    16. Glassfish Core
      TaskBase.run
      1. com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:264)
      1 frame
    17. Grizzly HTTP
      SSLWorkerThread.run
      1. com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
      1 frame