Hi,everyone!
I have a problem.I use sequoia to link two database:sql and
oracle9i.SQL runs on windows xp,and oracle9i runs on linux.But it always
occurs an error:
2007-11-12 09:47:32,250 WARN DatabaseBackend.myDB.wm
Statement.setCursorName not supported.
2007-11-12 09:47:32,250 WARN DatabaseBackend.myDB.wm
Statement.getGeneratedKeys not supported.
2007-11-12 09:47:42,593 ERROR DatabaseBackend.myDB.wm Runtime error while
fetching schema
java.lang.NullPointerException
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.getPrimaryKeys
(DatabaseSQLMetaData.java:842)
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.createDatabaseSchema
(DatabaseSQLMetaData.java:191)
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:1798)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.getAndCheckBackend
(VirtualDatabase.java:2109)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableBackend
(VirtualDatabase.java:1917)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackends
(VirtualDatabase.java:1801)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableAllBackendsFromCheckpoint
(VirtualDatabase.java:1959)
at org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(
Controller.java:302)
at org.continuent.sequoia.controller.xml.DatabasesParser.endElement(
DatabasesParser.java:717)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(
DatabasesParser.java:294)
at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(
DatabasesParser.java:343)
at org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(
Controller.java:222)
at org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(
Controller.java:555)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase
(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase
(ControllerParser.java:645)
at org.continuent.sequoia.controller.xml.ControllerParser.startElement(
ControllerParser.java:325)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at org.continuent.sequoia.controller.xml.ControllerParser.readXML(
ControllerParser.java:127)
at org.continuent.sequoia.controller.xml.ControllerParser.readXML(
ControllerParser.java:177)
at org.continuent.sequoia.controller.xml.ControllerParser.readXML(
ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(
ControllerConfiguration.java:277)
at org.continuent.sequoia.controller.core.ControllerConfiguration.setup(
ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController
(ControllerConfiguration.java:353)
at org.continuent.sequoia.controller.core.Controller.main(Controller.java
:745)
2007-11-12 09:47:42,609 WARN DatabaseBackend.myDB.wm Unable to gather
schema from database meta data: java.sql.SQLException: Failed to get
information about database schema: java.lang.NullPointerException
2007-11-12 09:47:48,031 ERROR DatabaseBackend.myDB.wm Runtime error
while fetching schema
java.lang.NullPointerException
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.getPrimaryKeys
(DatabaseSQLMetaData.java:842)
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.createDatabaseSchema
(DatabaseSQLMetaData.java:191)
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:1798)
at org.continuent.sequoia.controller.backend.DatabaseBackend.refreshSchema(
DatabaseBackend.java:2111)
at
org.continuent.sequoia.controller.backend.DatabaseBackend.getDatabaseSchema(
DatabaseBackend.java:1914)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.getAndCheckBackend
(VirtualDatabase.java:2111)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableBackend
(VirtualDatabase.java:1917)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackends
(VirtualDatabase.java:1801)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableAllBackendsFromCheckpoint
(VirtualDatabase.java:1959)
at org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(
Controller.java:302)
at org.continuent.sequoia.controller.xml.DatabasesParser.endElement(
DatabasesParser.java:717)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(
DatabasesParser.java:294)
at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(
DatabasesParser.java:343)
at org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(
Controller.java:222)
at org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(
Controller.java:555)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase
(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase
(ControllerParser.java:645)
at org.continuent.sequoia.controller.xml.ControllerParser.startElement(
ControllerParser.java:325)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at org.continuent.sequoia.controller.xml.ControllerParser.readXML(
ControllerParser.java:127)
at org.continuent.sequoia.controller.xml.ControllerParser.readXML(
ControllerParser.java:177)
at org.continuent.sequoia.controller.xml.ControllerParser.readXML(
ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(
ControllerConfiguration.java:277)
at org.continuent.sequoia.controller.core.ControllerConfiguration.setup(
ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController
(ControllerConfiguration.java:353)
at org.continuent.sequoia.controller.core.Controller.main(Controller.java
:745)
2007-11-12 09:47:48,046 WARN DatabaseBackend.myDB.wm Unable to gather
schema from database meta data: java.sql.SQLException: Failed to get
information about database schema: java.lang.NullPointerException
2007-11-12 09:47:48,046 WARN controller.virtualdatabase.myDB Backend
wm has no defined schema.
2007-11-12 09:47:54,609 ERROR DatabaseBackend.myDB.wm Runtime error
while fetching schema
java.lang.NullPointerException
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.getPrimaryKeys
(DatabaseSQLMetaData.java:842)
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.createDatabaseSchema
(DatabaseSQLMetaData.java:191)
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:1798)
at org.continuent.sequoia.controller.backend.DatabaseBackend.refreshSchema(
DatabaseBackend.java:2111)
at
org.continuent.sequoia.controller.backend.DatabaseBackend.getDatabaseSchema(
DatabaseBackend.java:1914)
at
org.continuent.sequoia.controller.loadbalancer.BackendTaskQueues.fetchNextQueryFromBackendTotalOrderQueue
(BackendTaskQueues.java:785)
at
org.continuent.sequoia.controller.loadbalancer.BackendTaskQueues.getNextCommitRollbackToExecute
(BackendTaskQueues.java:1783)
at org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(
BackendWorkerThread.java:182)
2007-11-12 09:47:54,609 WARN DatabaseBackend.myDB.wm Unable to gather
schema from database meta data: java.sql.SQLException: Failed to get
information about database schema: java.lang.NullPointerException
2007-11-12 09:48:00,890 ERROR DatabaseBackend.myDB.wm Runtime error
while fetching schema
java.lang.NullPointerException
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.getPrimaryKeys
(DatabaseSQLMetaData.java:842)
at
org.continuent.sequoia.controller.backend.DatabaseSQLMetaData.createDatabaseSchema
(DatabaseSQLMetaData.java:191)
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:1798)
at org.continuent.sequoia.controller.backend.DatabaseBackend.refreshSchema(
DatabaseBackend.java:2111)
at
org.continuent.sequoia.controller.backend.DatabaseBackend.getDatabaseSchema(
DatabaseBackend.java:1914)
at
org.continuent.sequoia.controller.loadbalancer.BackendTaskQueues.fetchNextQueryFromBackendTotalOrderQueue
(BackendTaskQueues.java:785)
at
org.continuent.sequoia.controller.loadbalancer.BackendTaskQueues.getNextEntryToExecute
(BackendTaskQueues.java:1693)
at org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(
BackendWorkerThread.java:185)
2007-11-12 09:48:00,890 WARN DatabaseBackend.myDB.wm Unable to gather
schema from database meta data: java.sql.SQLException: Failed to get
information about database schema: java.lang.NullPointerException
.......
And my configurement files is :
<DatabaseBackend name="hq" driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://10.129.213.4:1433"
connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="hq" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="wm" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:system/[EMAIL PROTECTED]:1521:demo"
connectionTestStatement="select * from dual ">
<ConnectionManager vLogin="user" rLogin="system" rPassword="demo">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
What is my problem?Who can help me?
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
