[Sequoia] Entering data in virtual DB's problematic with Sequoia 2.10

Mon, 09 Oct 2006 04:02:34 -0700 

Hi all,
I am trying to get a demo up and working using Sequoia 2.10. The demo tutorial is in German using Sequoia 2.4 but I managed to do the relevant changes in order to get Sequoia 2.10 running as per the demo. 


However, there are problems when I try and feed data into the test DB's 
created. The DB is a postgres DB.


Here are the error details and the Insert program writen in Java.

v-wright:/usr/local/sequoia-2.10/sequoia-2.10-bin/bin# java TestInsert Asif

org.continuent.sequoia.common.exceptions.driver.DriverSQLException: 
Message of cause: write request 6 failed:
Backend vDBtest - BackendWorkerThread for backend 'testNode1' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)
Backend vDBtest - BackendWorkerThread for backend 'testNode2' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)



        at 
org.continuent.sequoia.driver.Connection.statementExecuteUpdate(Connection.java:2935)
        at 
org.continuent.sequoia.driver.Statement.executeUpdateWithSkeleton(Statement.java:527)
        at 
org.continuent.sequoia.driver.Statement.executeUpdate(Statement.java:492)

        at TestInsert.main(TestInsert.java:21)

Caused by: 
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException: 
write request 6 failed:
Backend vDBtest - BackendWorkerThread for backend 'testNode1' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)
Backend vDBtest - BackendWorkerThread for backend 'testNode2' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)



Caused by: 
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
Backend vDBtest - BackendWorkerThread for backend 'testNode1' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)
Caused by: 
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
ERROR: null value in column "person_id" violates not-null constraint
Caused by: 
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
Backend vDBtest - BackendWorkerThread for backend 'testNode2' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)
Caused by: 
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
ERROR: null value in column "person_id" violates not-null constraint

SerializableStackTrace of each cause:

org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException: 
write request 6 failed:
Backend vDBtest - BackendWorkerThread for backend 'testNode1' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)
Backend vDBtest - BackendWorkerThread for backend 'testNode2' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)



        At: 
org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88)
        At: 
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:938)
        At: 
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.execWriteRequest(RAIDb1.java:343)
        At: 
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteUpdate(RAIDb1.java:249)
        At: 
org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecuteUpdate(RequestManager.java:913)
        At: 
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteUpdate(RequestManager.java:662)
        At: 
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteUpdate(VirtualDatabase.java:609)
        At: 
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteUpdate(VirtualDatabaseWorkerThread.java:2175)
        At: 
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:421)

Caused   by

org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
Backend vDBtest - BackendWorkerThread for backend 'testNode1' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)
        At: 
org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.notifyFailure(AbstractTask.java:224)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeInAutoCommit(StatementExecuteUpdateTask.java:217)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeTask(StatementExecuteUpdateTask.java:105)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
        At: 
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)

Caused   by

org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
ERROR: null value in column "person_id" violates not-null constraint
        At: 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        At: 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        At: 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        At: 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        At: 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
        At: 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)
        At: 
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateOnBackend(AbstractLoadBalancer.java:878)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeInAutoCommit(StatementExecuteUpdateTask.java:208)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeTask(StatementExecuteUpdateTask.java:105)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
        At: 
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)

Caused   by

org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
Backend vDBtest - BackendWorkerThread for backend 'testNode2' with RAIDb 
level:1 failed (ERROR: null value in column "person_id" violates 
not-null constraint)
        At: 
org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.notifyFailure(AbstractTask.java:224)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeInAutoCommit(StatementExecuteUpdateTask.java:217)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeTask(StatementExecuteUpdateTask.java:105)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
        At: 
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)

Caused   by

org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException: 
ERROR: null value in column "person_id" violates not-null constraint
        At: 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        At: 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        At: 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        At: 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        At: 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
        At: 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)
        At: 
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateOnBackend(AbstractLoadBalancer.java:878)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeInAutoCommit(StatementExecuteUpdateTask.java:208)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeTask(StatementExecuteUpdateTask.java:105)
        At: 
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
        At: 
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)


---------------

The TestInsert.java is as follows:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.io.*;
public class TestInsert {
        public static void main(String[] args) {

                String url = new 
String("jdbc:sequoia://v-wright.prz.tu-berlin.de:25322/vDBtest");

                String user = new String("apuser");
                String password = new String("secretcon");
                try {

Class.forName("org.continuent.sequoia.driver.DataSource");
                } catch ( ClassNotFoundException e ) {
                        e.printStackTrace();
                }
                try {

                        Connection dbcon = 
DriverManager.getConnection(url, user, password);

                        Statement st = dbcon.createStatement();

                        st.executeUpdate("insert into test_person 
(person_name) values ('" + args[0] + "')");

                        st.close();
                        dbcon.close();
                } catch ( SQLException e ) {
                        e.printStackTrace();
                }
        }
}

Can anyone please help out on this and tell me where I am going wrong?

Regards
Asif

--
---------------------
Cand. Dipl.-Inform. Asif Khan

PRZ - TU Berlin , MA 524, Sekr. MA 073
Strasse des 17. Juni 136
10623, Berlin, Germany
Tel: + 49 (0)30 314 79496 , Fax : + 49 30 314 21114
http://www.prz.tu-berlin.de/~asif

# He who has never learned to obey cannot be a good commander - Aristotle
---------------------

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia






















					Reply via email to