Ok, it was that
now it works, now I have to figure out about those warnings
Thanks
sudo ./bin/controller.sh -f ./config/controller/controller-itecban-oracle.xml
13:54:10,710 INFO controller.core.Controller Sequoia controller (2.10.2)
13:54:10,848 INFO controller.core.Controller Loading configuration
file: ./config/controller/controller-itecban-oracle.xml
13:54:11,061 INFO controller.core.Controller JMX is enabled
13:54:11,144 INFO controller.core.Controller Starting JMX server on
host: 127.0.0.1
13:54:11,875 INFO amdelcura.indra.es Adding connection manager for
virtual user "itecban"
13:54:12,040 INFO controller.RequestManager.ITECBAN_DB Request
manager will parse requests with the following granularity: TABLE
13:54:12,078 WARN controller.virtualdatabase.ITECBAN_DB No recovery
log has been configured, enabling backend without checkpoint.
13:54:14,533 INFO amdelcura.indra.es Detected backend as: Oracle
13:54:14,656 WARN amdelcura.indra.es Statement.setCursorName not supported.
13:54:14,656 WARN amdelcura.indra.es Statement.getGeneratedKeys not supported.
On 11/3/06, Alfonso Olias Sanz <[EMAIL PROTECTED]> wrote:
I see
So then, I guess is the connection stament the one that araises that error?
[EMAIL PROTECTED]:/usr/sequoia-2.10.1$ sudo ./bin/controller.sh -f
./config/controller/controller-itecban-oracle.xml
13:49:47,144 INFO controller.core.Controller Sequoia controller (2.10.2)
13:49:47,291 INFO controller.core.Controller Loading configuration
file: ./config/controller/controller-itecban-oracle.xml
13:49:47,554 INFO controller.core.Controller JMX is enabled
13:49:47,638 INFO controller.core.Controller Starting JMX server on
host: 127.0.0.1
13:49:48,379 INFO amdelcura.indra.es Adding connection manager for
virtual user "itecban"
13:49:48,554 INFO controller.RequestManager.ITECBAN_DB Request
manager will parse requests with the following granularity: TABLE
13:49:48,586 WARN controller.virtualdatabase.ITECBAN_DB No recovery
log has been configured, enabling backend without checkpoint.
13:49:51,131 INFO amdelcura.indra.es Detected backend as: Oracle
13:49:51,166 ERROR amdelcura.indra.es Test statement select 1 is
invalid (select 1)
13:49:51,170 WARN controller.virtualdatabase.ITECBAN_DB Error while
initalizing database backend amdelcura.indra.es
(java.sql.SQLException: Driver oracle.jdbc.driver.OracleDriver is not
Sequoia compliant)
java.sql.SQLException: Driver oracle.jdbc.driver.OracleDriver is not
Sequoia compliant
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriverCompliance(DatabaseBackend.java:608)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.getAndCheckBackend(VirtualDatabase.java:2062)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableBackend(VirtualDatabase.java:1874)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackends(VirtualDatabase.java:1758)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackendsFromCheckpoint(VirtualDatabase.java:1778)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(Controller.java:296)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:699)
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:287)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:336)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:223)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:553)
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:128)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:178)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:207)
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:742)
13:49:51,186 WARN controller.core.Controller Failed to automatically
enable backends, manual resynchronization is probably needed
13:49:51,186 INFO controller.core.Controller Adding VirtualDatabase ITECBAN_DB
13:49:51,210 INFO controller.core.Controller Waiting for connections
on 0.0.0.0:25322
13:49:51,236 INFO controller.core.Controller Controller started on
2006.11.03 44 at 01:49:51 PM CET
13:49:51,237 INFO controller.core.Controller Controller
127.0.0.1:25322 ready, listening to requests ...
On 11/3/06, Emmanuel Cecchet <[EMAIL PROTECTED]> wrote:
> Alfonso,
> > What is the compliant driver??
> >
> > I hava tried with classes12.jar and ojdbc14.jar.
> > By the way I am using Sequoia 2.10.2 on linux
> > Oracle 10g
> A compliant driver is a driver that can give a connection to the
> database and provide basic features to execute requests. If you get this
> error message, it usually means that you misconfigured your datasource.
> Please provide the full error message on the controller side to see what
> particular call has failed.
>
> Regards,
> Emmanuel
>
> --
> Emmanuel Cecchet
> Chief Scientific Officer, Continuent
>
> Blog: http://emanux.blogspot.com/
> Open source: http://www.continuent.org
> Corporate: http://www.continuent.com
> Skype: emmanuel_cecchet
> Cell: +33 687 342 685
>
>
> _______________________________________________
> Sequoia mailing list
> [email protected]
> https://forge.continuent.org/mailman/listinfo/sequoia
>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
