Hi Adam,

Don't worry about that, this was a prototype implementation of semantic information that was hardcoded to find information in a table called sequoiasabase. This is just a debug message that tells that this table couldn't be found. Semantic information is not operational in 2.10 anyway, it was only supported in the now obsolete 3.x and will be fully supported in 4.x (under development based on the 3.x code line).

Hope this clarifies things,
Emmanuel

I have stumbled across this error message while enabling a mysql db I want to access through sequoia. I was wondering if it meant anything to anyone as I have no idea what it means and why it would be looking for a sequoiasabase table inside my db. Everything else seems to be ok, and I can query the db, but I suspect whatever failed will at somepoint be needed and at that point it will die. I am using 2.10.10 with the db, controller and jboss all on the same machine while I do a proof of concept. 15:08:16,777 DEBUG DatabaseBackend.XXX.DB1 Failed to get stored procedure semantics from database backend (Table XXX.sequoiasabase' doesn't
 exist)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table XXX.sequoiasabase' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467) at org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.getProcedureSemantics(DatabaseSQLMetaData.java:259) at org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.getProcedures(DatabaseSQLMetaData.java:223) at org.continuent.sequoia.controller.backend.SequoiaSchemaFactory.createDatabaseSchema(SequoiaSchemaFactory.java:166) at org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.createDatabaseSchema(DatabaseSQLMetaData.java:96) at org.continuent.sequoia.controller.backend.DatabaseBackendMetaData.createDatabaseSchemaDynamically(DatabaseBackendMetaData.java:918) at org.continuent.sequoia.controller.backend.DatabaseBackendMetaData.getDatabaseSchema(DatabaseBackendMetaData.java:954) at org.continuent.sequoia.controller.backend.DatabaseBackend.checkDatabaseSchema(DatabaseBackend.java:1827) at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.getAndCheckBackend(VirtualDatabase.java:2191) at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableBackendFromCheckpoint(VirtualDatabase.java:1791) at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableBackendFromCheckpoint(VirtualDatabase.java:1861) at org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.enableBackendFromCheckpoint(VirtualDatabase.java:143)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(Unknown Source) at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(Unknown Source) at com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(Unknown Source)
        at com.sun.jmx.mbeanserver.PerInterface.invoke(Unknown Source)
        at com.sun.jmx.mbeanserver.MBeanSupport.invoke(Unknown Source)
        at javax.management.StandardMBean.invoke(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source)
        at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source)
at org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318) at org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:127) at javax.management.remote.rmi.RMIConnectionImpl.doOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.access$200(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.invoke(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
        at sun.rmi.transport.Transport$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

------------------------------------------------------------------------
------------------------------------------------------------------------

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia


--
Emmanuel Cecchet
FTO @ Frog Thinker Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to