[CDO] SQLException [message #423822] |
Tue, 07 October 2008 10:57  |
Eclipse User |
|
|
|
I'm adding an element to a model and when I commit the transaction, I
get the following:
[ERROR] java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
[ERROR] java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
org.eclipse.net4j.db.DBException: java.sql.SQLException: Column 'PATH'
cannot accept a NULL value.
at
org.eclipse.emf.cdo.server.internal.db.ClassMapping.sqlUpdat e(ClassMapping.java:178)
at
org.eclipse.emf.cdo.server.internal.db.ClassMapping.writeAtt ributes(ClassMapping.java:494)
at
org.eclipse.emf.cdo.server.internal.db.ClassMapping.writeRev ision(ClassMapping.java:450)
at
org.eclipse.emf.cdo.server.internal.db.HorizontalClassMappin g.writeRevision(HorizontalClassMapping.java:37)
at
org.eclipse.emf.cdo.server.internal.db.DBStoreWriter.writeRe vision(DBStoreWriter.java:201)
at
org.eclipse.emf.cdo.internal.server.StoreAccessor.writeRevis ions(StoreAccessor.java:197)
at
org.eclipse.emf.cdo.internal.server.StoreAccessor.commit(Sto reAccessor.java:116)
at
org.eclipse.emf.cdo.server.internal.db.DBStoreWriter.commit( DBStoreWriter.java:52)
at
org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:181)
at
org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:109 )
at
org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:46)
at
org.eclipse.net4j.signal.Signal.runSync(Signal.java:143)
at org.eclipse.net4j.signal.Signal.run(Signal.java:124)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Threa dPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo lExecutor.java:675)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQL Exception(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleExc eption(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(U nknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(U nknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(U nknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unkn own Source)
at
org.eclipse.emf.cdo.server.internal.db.ClassMapping.sqlUpdat e(ClassMapping.java:174)
...
15 more
Caused by: ERROR 23502: Column 'PATH' cannot accept a NULL value.
at org.apache.derby.iapi.error.StandardException.newException(U nknown Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.normali zeRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNext RowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextR owCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unkno wn Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(U nknown Source)
... 19 more
[ERROR] java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
|
|
|
|
Re: [CDO] SQLException [message #423832 is a reply to message #423829] |
Tue, 07 October 2008 12:48  |
Eclipse User |
|
|
|
Eike,
Stephen and I are working on the same project, and based on your reply
to his problem with an SQLException when loading a cross-model
reference, it sounds like we need to try the latest build.
I think we will try the latest build and see if that works. We are
quickly running out of time, and must decide wether CDO will work for
us, or if we must develop our own solution. We greatly appreciate your
quick responses to our problems.
Bryan
On 2008-10-07 11:34:09 -0500, Eike Stepper <stepper@esc-net.de> said:
> Hi Bryan,
>
> The exception reminds me to a recent Bugzilla but I can't find it at
> the moment.
> Can you please file a new Bugzilla so that I can investigate that tomorrow?
>
> Important: Please indicate which version of CDO you used exactly.
> Probably I'll also need some more details about the context, i.e. what
> exactly you did in which order.
> A test case to reproduce the problem as subclass of AbstractCDOTest is
> always the best way to help us find and fix a bug (it's really easy and
> lots of examples exist).
> Also a zipped console log (which, for example, contains the exact SQL
> statement that caused an exception) might be helpful.
>
> Cheers
> /Eike
>
>
> Bryan Hunt schrieb:
>> I'm adding an element to a model and when I commit the transaction, I
>> get the following:
>>
>> [ERROR] java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
>> [ERROR] java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
>> org.eclipse.net4j.db.DBException: java.sql.SQLException: Column 'PATH'
>> cannot accept a NULL value.
>> at
>> org.eclipse.emf.cdo.server.internal.db.ClassMapping.sqlUpdat e(ClassMapping.java:178)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.db.ClassMapping.writeAtt ributes(ClassMapping.java:494)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.db.ClassMapping.writeRev ision(ClassMapping.java:450)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.db.HorizontalClassMappin g.writeRevision(HorizontalClassMapping.java:37)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.db.DBStoreWriter.writeRe vision(DBStoreWriter.java:201)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.StoreAccessor.writeRevis ions(StoreAccessor.java:197)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.StoreAccessor.commit(Sto reAccessor.java:116)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.db.DBStoreWriter.commit( DBStoreWriter.java:52)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:181)
>> at
>> org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:109 )
>>
>> at
>> org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:46)
>>
>> at
>> org.eclipse.net4j.signal.Signal.runSync(Signal.java:143)
>> at org.eclipse.net4j.signal.Signal.run(Signal.java:124)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Threa dPoolExecutor.java:650)
>>
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo lExecutor.java:675)
>> at java.lang.Thread.run(Thread.java:613)
>> Caused by: java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn Source)
>> at
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQL Exception(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleExc eption(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedConnection.handleException(U nknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.ConnectionChild.handleException(U nknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(U nknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>> at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unkn own Source)
>> at
>> org.eclipse.emf.cdo.server.internal.db.ClassMapping.sqlUpdat e(ClassMapping.java:174)
>>
>> ...
>> 15 more
>> Caused by: ERROR 23502: Column 'PATH' cannot accept a NULL value.
>> at
>> org.apache.derby.iapi.error.StandardException.newException(U nknown
>> Source)
>> at
>> org.apache.derby.impl.sql.execute.NormalizeResultSet.normali zeRow(Unknown
>> Source)
>> at
>> org.apache.derby.impl.sql.execute.NormalizeResultSet.getNext RowCore(Unknown
>> Source)
>> at
>> org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextR owCore(Unknown
>> Source)
>> at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unkno wn Source)
>> at
>> org.apache.derby.impl.sql.GenericPreparedStatement.execute(U nknown
>> Source)
>> ... 19 more
>> [ERROR] java.sql.SQLException: Column 'PATH' cannot accept a NULL value.
|
|
|
Powered by
FUDForum. Page generated in 0.03852 seconds