Hi,
Our sequoia works with Oracle, we use ojdbc14.jar and we did not ever have the
problem you report.
But first time it started, controller initialization take 45 minutes. It is
apparently a known problem with sequoia-Oracle : construct database schema is
very long.
The solution we use is to configure DatabaseBackend with a static shema : in
the vdb.xml
<DatabaseBackend ...>
<DatabaseSchema dynamicPrecision="static">
<DatabaseStaticSchema>
<DatabaseTable tableName="XXX" nbOfColumns="14">
<DatabaseColumn columnName="XXXX
isUnique="true"/>
.
.
.
</DatabaseTable>
..
</DatabaseStaticSchema>
</DatabaseSchema>
</DatabaseBackend>
Maybe it will avoid your problem too and prevent for slow initialization.
Hope it helps,
Pierre
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de Mick
Oyer
Envoyé : 20 September 2007 00:21
À : [email protected]
Objet : [Sequoia] (no subject)
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
This mail has originated outside your organization, either from an external
partner or the Global Internet.
Keep this in mind if you answer this message.
This e-mail is intended only for the above addressee. It may contain privileged
information.
If you are not the addressee you must not copy, distribute, disclose or use any
of the information in it.
If you have received it in error please delete it and immediately notify the
sender.
Security Notice: all e-mail, sent to or from this address, may be accessed by
someone other than the recipient, for system management and security reasons.
This access is controlled under Regulation of security reasons.
This access is controlled under Regulation of Investigatory Powers Act 2000,
Lawful Business Practises.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
