Return-Path: X-Original-To: apmail-isis-users-archive@www.apache.org Delivered-To: apmail-isis-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6B07B174E2 for ; Fri, 6 Mar 2015 14:10:40 +0000 (UTC) Received: (qmail 15663 invoked by uid 500); 6 Mar 2015 14:10:40 -0000 Delivered-To: apmail-isis-users-archive@isis.apache.org Received: (qmail 15634 invoked by uid 500); 6 Mar 2015 14:10:40 -0000 Mailing-List: contact users-help@isis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@isis.apache.org Delivered-To: mailing list users@isis.apache.org Received: (qmail 15619 invoked by uid 99); 6 Mar 2015 14:10:40 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Mar 2015 14:10:40 +0000 Received: from mail-ob0-f172.google.com (mail-ob0-f172.google.com [209.85.214.172]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id E516C1A026E for ; Fri, 6 Mar 2015 14:10:39 +0000 (UTC) Received: by obcwp18 with SMTP id wp18so9390862obc.6 for ; Fri, 06 Mar 2015 06:10:39 -0800 (PST) X-Received: by 10.182.247.42 with SMTP id yb10mr10845204obc.54.1425651039156; Fri, 06 Mar 2015 06:10:39 -0800 (PST) MIME-Version: 1.0 Received: by 10.182.134.226 with HTTP; Fri, 6 Mar 2015 06:09:58 -0800 (PST) In-Reply-To: References: From: Martin Grigorov Date: Fri, 6 Mar 2015 16:09:58 +0200 Message-ID: Subject: Re: Not able to add 1:m bidirectional relationship To: users Content-Type: multipart/alternative; boundary=089e015384e0c3402d05109f3f3c --089e015384e0c3402d05109f3f3c Content-Type: text/plain; charset=UTF-8 java.sql.SQLException: Field 'idx' doesn't have a default value Do you have an entity with field 'idx' in your model ? Or it could be something created by Isis/DN, I don't know. Martin Grigorov Wicket Training and Consulting https://twitter.com/mtgrigorov On Fri, Mar 6, 2015 at 4:06 PM, Marianne Hagaseth < Marianne.Hagaseth@marintek.sintef.no> wrote: > Yes, a lot. See below. > It seems like the values are not picked up, and then the insert into the > database tables fails because the columns are NOT NULL and no default > values exists. > > Some more from the STACK: > > Caused by: > org.datanucleus.store.rdbms.exceptions.MappedDatastoreException: INSERT > INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.doInternalAdd(JoinSetStore.java:754) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.internalAdd(JoinSetStore.java:502) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.add(JoinSetStore.java:333) > ... 71 more > Caused by: java.sql.SQLException: Field 'idx' doesn't have a default value > > <<<<<<<<<<<<<<<<<<<<<<<<<<< > And more: > <<<<<<<<<<<<<<<<<<<<<<<<<<< > > ... 73 more > Nested Throwables StackTrace: > org.datanucleus.store.rdbms.exceptions.MappedDatastoreException: INSERT > INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.doInternalAdd(JoinSetStore.java:754) > > at > org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) > at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) > Caused by: java.sql.SQLException: Field 'idx' doesn't have a default value > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) > > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.doInternalAdd(JoinSetStore.java:733) > ... 73 more > > <<<<<<<<<<<<<<<<<<<<<<<<<<< > And more: > <<<<<<<<<<<<<<<<<<<<<<<<<<< > > 14:45:38,105 [Persistence 1661257338@qtp-721005297-3 WARN ] > Execution of method "add" on field "clauses" caused an error : Add request > failed : INSERT INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > Add request failed : INSERT INTO regulation_clauses (id_oid,id_eid) VALUES > (?,?) > org.datanucleus.exceptions.NucleusDataStoreException: Add request failed : > INSERT INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.add(JoinSetStore.java:349) > at > org.datanucleus.store.types.backed.SortedSet.add(SortedSet.java:716) > > <<<<<<<<<<<<<<<<<<<<<<<<<<< > And more: > <<<<<<<<<<<<<<<<<<<<<<<<<<< > > at > org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) > at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) > Caused by: > org.datanucleus.store.rdbms.exceptions.MappedDatastoreException: INSERT > INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.doInternalAdd(JoinSetStore.java:754) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.internalAdd(JoinSetStore.java:502) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.add(JoinSetStore.java:333) > ... 71 more > Caused by: java.sql.SQLException: Field 'idx' doesn't have a default value > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) > > <<<<<<<<<<<<<<<<<<<<<<<<<<< > And more: > <<<<<<<<<<<<<<<<<<<<<<<<<<< > > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.doInternalAdd(JoinSetStore.java:733) > ... 73 more > Nested Throwables StackTrace: > org.datanucleus.store.rdbms.exceptions.MappedDatastoreException: INSERT > INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.doInternalAdd(JoinSetStore.java:754) > at > org.datanucleus.store.rdbms.scostore.JoinSetStore.internalAdd(JoinSetStore.java:502) > > <<<<<<<<<<<<<<<<<<<<<<<<<<< > And more: > <<<<<<<<<<<<<<<<<<<<<<<<<<< > > at > org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) > at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) > Caused by: java.sql.SQLException: Field 'idx' doesn't have a default value > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) > > <<<<<<<<<<<<<<<<<<<<<<<<<<< > And more: > <<<<<<<<<<<<<<<<<<<<<<<<<<< > > Best > -Marianne. > > -----Original Message----- > From: Martin Grigorov [mailto:mgrigorov@apache.org] > Sent: 6. mars 2015 14:53 > To: users > Subject: Re: Not able to add 1:m bidirectional relationship > > Hi, > > > On Fri, Mar 6, 2015 at 3:51 PM, Marianne Hagaseth < > Marianne.Hagaseth@marintek.sintef.no> wrote: > > > Hi, > > I am trying to add a 1:m bidirectional relationship, but it fails. > > I wonder if could be a mismatch between the versions used for some of > > the stuff needed. > > My set up looks like: > > > > > > * isis-core-webserver 1.7.0 > > > > * datanucleus-api-jdo-3.2.7 > > > > * Eclipse Java EE IDE 4.4.2 > > > > * mysql-connector-java-5.1.34 > > > > * mysql server 5.6.23 > > > > * Jdk 1.7.0_75 > > > > > > It fails here at backingStore.add(...): > > > > try > > > > { > > > > backingStore.add(ownerOP,element, (useCache ? > > delegate.size() : -1)); > > > > } > > > > catch (NucleusDataStoreException dse) > > > > { > > > > > > NucleusLogger.PERSISTENCE.warn(LOCALISER.msg("023013", > > "add", ownerMmd.getName(), dse)); > > > > backingSuccess = false; > > > > } > > With Error message: > > > > 12:20:54,055 [Datastore 1844639495@qtp-721005297-3 ERROR] > > org.datanucleus.store.rdbms.exceptions.MappedDatastoreException: > > INSERT INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > > > > 12:20:54,055 [Datastore 1844639495@qtp-721005297-3 ERROR] > > org.datanucleus.store.rdbms.exceptions.MappedDatastoreException: > > INSERT INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > > > > 12:20:54,055 [Datastore 1844639495@qtp-721005297-3 ERROR] > > Add request failed : INSERT INTO regulation_clauses (id_oid,id_eid) > > VALUES > > (?,?) > > > > 12:20:54,055 [Datastore 1844639495@qtp-721005297-3 ERROR] > > Add request failed : INSERT INTO regulation_clauses (id_oid,id_eid) > > VALUES > > (?,?) > > > > 12:20:54,056 [Persistence 1844639495@qtp-721005297-3 WARN ] > > Execution of method "add" on field "clauses" caused an error : Add > > request failed : INSERT INTO regulation_clauses (id_oid,id_eid) VALUES > > (?,?) > > > > Add request failed : INSERT INTO regulation_clauses (id_oid,id_eid) > > VALUES > > (?,?) > > > > org.datanucleus.exceptions.NucleusDataStoreException: Add request failed > : > > INSERT INTO regulation_clauses (id_oid,id_eid) VALUES (?,?) > > > > at > > org.datanucleus.store.rdbms.scostore.JoinSetStore.add(JoinSetStore.jav > > a:349) > > > > at > > org.datanucleus.store.types.backed.SortedSet.add(SortedSet.java:716) > > > > at dom.regulation.Regulation.addClause(Regulation.java:795) > > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j > > ava:57) > > > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess > > orImpl.java:43) > > > > > > etc.etc... > > > > Is there "Caused by: ..." down in the stack ? > > > > > > Best regards, > > Marianne Hagaseth > > > > > --089e015384e0c3402d05109f3f3c--