Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] SQLException
[CDO] SQLException [message #423822] Tue, 07 October 2008 14:57 Go to next message
Bryan Hunt is currently offline Bryan HuntFriend
Messages: 366
Registered: July 2009
Senior Member
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 #423829 is a reply to message #423822] Tue, 07 October 2008 16:34 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6464
Registered: July 2009
Senior Member
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.
>
>


Re: [CDO] SQLException [message #423832 is a reply to message #423829] Tue, 07 October 2008 16:48 Go to previous message
Bryan Hunt is currently offline Bryan HuntFriend
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.
Previous Topic:[CDO]: IHTTPConnector is present in 2 bundles!
Next Topic:Creating my on derived feature based on a "mixed" feature
Goto Forum:
  


Current Time: Sun Jan 19 08:06:11 GMT 2020

Powered by FUDForum. Page generated in 0.02122 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top