Asif,Backend vDBtest - BackendWorkerThread for backend 'testNode1' with RAIDb level:1 failed (ERROR: null value in column "person_id" violates not-null constraint)As the underlying database reports, you are trying to insert a null value in the column "person_id" but the column was created with a not-null constraint. st.executeUpdate("insert into test_person (person_name) values ('" + args[0] + "')");You should probably do something like: st.executeUpdate("insert into test_person (person_id, person_name) values (0, '" + args[0] + "')"); Note that it would be better to use a PreparedStatement and execute: PreparedStatement pstmt = dbcon.prepareStatement("insert into test_person (person_id, person_name) values (?,?)"); pstmt.setInt(1, 0); pstmt.setString(2, args[0]); pstmt.executeUpdate(); Hope this helps, Emmanuel -- Emmanuel Cecchet Chief Architect, 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
