Re: [Sequoiadb-discuss] [Sequoia] [sequoia] Errors with create table & insert values

[Emmanuel C. <ma...@fr...>]

Hi,

The new Sequoia mailing list is at seq...@li...
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
> Se...@li...
> http://forge.continuent.org/mailman/listinfo/sequoia


-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: ma...@fr...
Skype: emmanuel_cecchet