Greetings ...
I'm trying to configure sequoia to work with oracle. I believe I have all
configuration files
set up correctly, but when I bring it up, I'm getting a NullPointerException
when trying
to call DatabaseSQLMetaData.getPrimaryKeys (below). I've tried calling
'getPrimaryKeys'
directly from Java using Database getMetaData, nothing is returned in that case
either.
I found a reference that I should update the Oracle JDBC driver (I'm now using
ojdbc14_g.jar),
but the problem remains.
Any help would be greatly appreciated.
-Mick
[EMAIL PROTECTED] bin]# ./controller.sh -f
../config/controller/controller-oracle.xml
15:12:02,895 INFO controller.core.Controller Sequoia controller (2.10.9)
15:12:03,327 INFO controller.core.Controller Loading configuration file:
../config/controller/controller-oracle.xml
15:12:03,583 INFO controller.core.Controller JMX is enabled
15:12:03,597 INFO controller.core.Controller Starting JMX server on host:
192.168.1.11
15:12:04,609 INFO DatabaseBackend.OracleDatabase.setter1 Adding connection
manager for virtual user "vuser"
15:12:07,160 INFO controller.RequestManager.OracleDatabase Request manager
will parse requests with the following granularity: TABLE
15:12:07,234 INFO controller.virtualdatabase.OracleDatabase Enabling backend
setter1 from checkpoint Initial_empty_recovery_log
15:12:08,326 INFO DatabaseBackend.OracleDatabase.setter1 Detected backend as:
Oracle
15:12:08,434 WARN DatabaseBackend.OracleDatabase.setter1
Statement.setCursorName not supported.
15:12:08,438 WARN DatabaseBackend.OracleDatabase.setter1
Statement.getGeneratedKeys not supported.
15:12:10,882 ERROR DatabaseBackend.OracleDatabase.setter1 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.enableBackendFromCheckpoint(VirtualDatabase.java:1727)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackendsFromCheckpoint(VirtualDatabase.java:1853)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(Controller.java:295)
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)
--
Mick Oyer
Software Development
Anakam, LLC
5665 Oberlin Drive, Suite 106, San Diego, CA 92121
office 858-622-9550 x 109 | mobile 858-774-4728
---------------------------------------------------------------
This e-mail, including attachments, is intended for the
exclusive use of the addressee and may contain proprietary,
confidential or privileged information. If you are not the
intended recipient, any dissemination, use, distribution or
copying is strictly prohibited. If you have received this e-mail
in error, please notify me via return e-mail and permanently
delete the original and destroy all copies.
---------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
