Hi, Thanks for the quick answer. Despite the fact that RAIDb-0 isn't supported sequoia remains a great tool, but I was only interested in the RAIDb-0 config. Great work on sequoia !
Best regards, Nghi Huynh Emmanuel Cecchet a écrit : > Hi, > > The new Sequoia mailing list is at [email protected] > The RAIDb-0 code is not supported in 2.10.10. I have not worked on it > for Sequoia 4 either so it is unlikely to work properly. > > Sorry for the inconvenience, > Emmanuel > > >> I have a configuration with one sequoia 2.10.10 controller and a single >> DB - mysql. I set it in Raidb-0 configuration and am experiencing the >> same problem with 3 oracle db + 1 sql db. >> When i'm creating a new table, i'm having a strange error. I have to >> reboot the controller to make it aware of the new table. >> >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > show tables >> +---------------------+ >> | tables | >> +---------------------+ >> | ParticipantActivite | >> | AAA | >> | Utilisateur | >> | AAAB | >> | Activites | >> +---------------------+ >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > create table AAAC (id >> integer not null, name varchar(255)) >> An error occured while executing SQL query >> (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: >> Message of cause: Failed to execute request create table AAAC (id >> integer not null, ... because of (null)) >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > show >> tables >> +---------------------+ >> | tables | >> +---------------------+ >> | ParticipantActivite | >> | AAA | >> | Utilisateur | >> | AAAB | >> | Activites | >> +---------------------+ >> >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > select * from AAAC >> Query executed in 0 s 15 ms . >> >> >> According to my DB, the table has been created but I've got a strange >> error... >> Same thing when i attempt to insert values: >> (After controller's reboot) >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > show >> tables >> +---------------------+ >> | tables | >> +---------------------+ >> | AAAC | >> | ParticipantActivite | >> | AAA | >> | Utilisateur | >> | AAAB | >> | Activites | >> +---------------------+ >> >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > select * from >> AAA >> Query executed in 0 s 13 ms . >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > insert into AAA >> values (1,"one") >> An error occured while executing SQL query >> (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: >> Message of cause: Failed to execute request insert into AAA values >> (1,"one")/ because of (null)) >> jdbc:sequoia://127.0.0.2:2222/basetest (distant) > select * from >> AAA >> +----+------+ >> | id | name | >> +----+------+ >> | 1 | one | >> +----+------+ >> >> Query executed in 0 s 20 ms . >> >> here are my configuration files: >> controller.xml >> >> >> >> SEQUOIA-CONTROLLER 2.10.10//EN" >> "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.10.dtd";> >> >> >> >> >> >> generateOnFatal="true" enableFileLogging="true" /> >> >> >> >> >> virtualDatabaseName="basetest" /> >> >> >> >> basetest.xml >> >> >> >> "http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";> >> >> >> >> >> >> >> >> >> >> >> >> >> driverPath="/user/share/mysql-connector-java-5.1.7-bin.jar" >> url="jdbc:mysql://localhost/test" connectionTestStatement="select 1"> >> >> rPassword="root"> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Best regards, >> Nghi Huynh >> >> >> >> >> >> >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Sequoia mailing list >> [email protected] >> http://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] > http://forge.continuent.org/mailman/listinfo/sequoia > _______________________________________________ Sequoia mailing list [email protected] http://forge.continuent.org/mailman/listinfo/sequoia
