|
| Re: [CDO] SQLException [message #423829 is a reply to message #423822] |
Tue, 07 October 2008 16:34   |
|
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.
>
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: [CDO] SQLException [message #423832 is a reply to message #423829] |
Tue, 07 October 2008 16:48 |
 Bryan Hunt
Messages: 366
Registered: July 2009 |
Senior Member |
|
|
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.01870 seconds
Search
Help
Register
Login
Home
