Eclipse Community Forums: Modeling (top-level project) » Problem with CDO/Teneo/Hibernate on Derby

Help

Home

Home » Modeling » Modeling (top-level project) » Problem with CDO/Teneo/Hibernate on Derby

Show: Today's Messages :: Show Polls :: Message Navigator

Problem with CDO/Teneo/Hibernate on Derby [message #383233]

Fri, 19 September 2008 08:22

Roger Stocker

Messages: 16
Registered: July 2009

Junior Member

Hi

I ran into a problem when I use the TeneoHibernateMapping for CDO on
Apache Derby Embedded:
org.hibernate.exception.GenericJDBCException: could not insert:
[org.eclipse.emf.cdo.internal.common.model.CDOPackageImpl]
Caused by: org.apache.derby.iapi.services.io.DerbyIOException: A
truncation error was encountered trying to shrink CLOB 'XXXX' to length
255.
(below is a Stacktrace)

It happens when I commit the CDOTransaction after adding one eClass:

CDOSession session = configuration.openSession();
session.getPackageRegistry().putEPackage(PeoplePackage.eINST ANCE);

// Open transaction
CDOTransaction transaction = session.openTransaction();

transaction.setChangeSubscriptionPolicy(CDOChangeSubscriptio nPolicy.ALL);

CDOResource resource = transaction.createResource("/Test");

Person person = PeopleFactory.eINSTANCE.createPerson();
person.setFirstName("Hallo");
person.setLastName("Velo");
resource.getContents().add(person);

transaction.commit();

This is only happening with Derby Embedded, but not with Postgres. Also
using the storeType="db" is working with Derby.

My model is just a simple test model with 3 features (no relations).

Used Versions:
--------------
Eclipse SDK 3.4.1RC3
CDO 2.0.0-I200809110653
Net4j 2.0.0-I200809110620
Teneo 1.0.1-M200809150739
Derby 10.4.2

cdo-server.xml:
---------------
<?xml version="1.0" encoding="UTF-8"?>
<cdoServer>

<acceptor type="tcp" listenAddr="0.0.0.0" port="2036">

</acceptor>

<repository name="HPROTO">
<property name="overrideUUID"
value="1ff5d226-b1f3-45fb-afa2-0c30b38c764f" />
<property name="supportingAudits" value="false" />
<property name="verifyingRevisions" value="false" />
<property name="currentLRUCapacity" value="10000" />
<property name="revisedLRUCapacity" value="100" />

<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.connection.pool_size" value="10" />

<property name="hibernate.dialect"
value="org.hibernate.dialect.DerbyDialect" />
<property name="hibernate.connection.driver_class"
value="org.apache.derby.jdbc.EmbeddedDriver" />
<property name="hibernate.connection.url"
value="jdbc:derby:ProtoDB;create=true" />

<property name="hibernate.connection.autocommit" value="true" />
<property name="hibernate.cache.provider_class"
value="org.hibernate.cache.HashtableCacheProvider" />

<property name="teneo.mapping.inheritance" value="TABLE_PER_CLASS" />
<property name="teneo.naming.id_feature_as_primary_key" value="id" />

<store type="hibernate">
<mappingProvider type="teneo" />
</store>

</repository>
</cdoServer>

And the stacktrace:
--------------------
2008-09-19 10:03:56 DEBUG org.hibernate.util.JDBCExceptionReporter could
not insert: [org.eclipse.emf.cdo.internal.common.model.CDOPackageImpl]
[insert into cdo_packages (uri, ecore, dynamic, parentUri, metaIDStart,
metaIDSize, CDOPackageImpl) values (?, ?, ?, ?, ?, ?, ?)]
java.sql.SQLException: An unexpected exception was thrown
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown 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.EmbedPreparedStatement.executeSta tement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpd ate(Unknown
Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2278)
at
org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2688)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsert Action.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 9)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:167)
at
org.hibernate.event.def.AbstractFlushingEventListener.perfor mExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(De faultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java :365)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransac tion.java:137)
at
org.eclipse.emf.cdo.server.internal.hibernate.HibernatePacka geHandler.writePackages(HibernatePackageHandler.java:145)
at
org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.writePackages(HibernateStoreWriter.java:197)
at
org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.write(HibernateStoreWriter.java:60)
at
org.eclipse.emf.cdo.internal.server.TransactionCommitContext Impl.write(TransactionCommitContextImpl.java:227)
at
org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicatingCommit(CommitTransactionIndication.ja va:167)
at
org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:68)
at
org.eclipse.emf.cdo.internal.server.protocol.CDOServerIndica tion.indicating(CDOServerIndication.java:116)
at org.eclipse.net4j.signal.Indication.execute(Indication.java: 48)
at
org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:38)
at org.eclipse.net4j.signal.Signal.runSync(Signal.java:186)
at org.eclipse.net4j.signal.Signal.run(Signal.java:167)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: An unexpected exception was thrown
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
Source)
... 35 more
Caused by: java.sql.SQLException: Java exception: 'A truncation error was
encountered trying to shrink CLOB 'XXXX' to length 255.:
org.apache.derby.iapi.services.io.DerbyIOException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQL Exception(Unknown
Source)
... 32 more
Caused by: org.apache.derby.iapi.services.io.DerbyIOException: A
truncation error was encountered trying to shrink CLOB 'XXXX' to length
255.
at org.apache.derby.iapi.types.ReaderToUTF8Stream.truncate(Unkn own Source)
at
org.apache.derby.iapi.types.ReaderToUTF8Stream.checkSufficie ntData(Unknown
Source)
at org.apache.derby.iapi.types.ReaderToUTF8Stream.fillBuffer(Un known
Source)
at org.apache.derby.iapi.types.ReaderToUTF8Stream.read(Unknown Source)
at org.apache.derby.impl.store.raw.data.MemByteHolder.write(Unk nown
Source)
at
org.apache.derby.impl.store.raw.data.RememberBytesInputStrea m.fillBuf(Unknown
Source)
at org.apache.derby.impl.store.raw.data.StoredPage.logColumn(Un known
Source)
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unkno wn Source)
at
org.apache.derby.impl.store.raw.data.InsertOperation.writeOp tionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.InsertOperation.<init>(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionI nsert(Unknown
Source)
at org.apache.derby.impl.store.raw.data.BasePage.insertNoOverfl ow(Unknown
Source)
at org.apache.derby.impl.store.raw.data.BasePage.insertAtSlot(U nknown
Source)
at org.apache.derby.impl.store.raw.data.StoredPage.insertAtSlot (Unknown
Source)
at org.apache.derby.impl.store.raw.data.BasePage.insert(Unknown Source)
at
org.apache.derby.impl.store.access.heap.HeapController.doIns ert(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapController.inser tAndFetchLocation(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(U nknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInse rtCore(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)
... 28 more

Any clue what could be wrong?

Regards
Roger

Report message to a moderator

Re: Problem with CDO/Teneo/Hibernate on Derby [message #383234 is a reply to message #383233]

Fri, 19 September 2008 10:18

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Hi Roger,

I added the EMF newsgroup to the list of recipients because CDO is
supported there.
From a first look I don't think that your code is obviously wrong
somewhere.
Can you please open a Bugzilla so that we can discuss and keep track?

Cheers
/Eike

Roger schrieb:
> Hi
>
> I ran into a problem when I use the TeneoHibernateMapping for CDO on
> Apache Derby Embedded:
> org.hibernate.exception.GenericJDBCException: could not insert:
> [org.eclipse.emf.cdo.internal.common.model.CDOPackageImpl]
> Caused by: org.apache.derby.iapi.services.io.DerbyIOException: A
> truncation error was encountered trying to shrink CLOB 'XXXX' to
> length 255.
> (below is a Stacktrace)
>
> It happens when I commit the CDOTransaction after adding one eClass:
>
> CDOSession session = configuration.openSession();
>
> session.getPackageRegistry().putEPackage(PeoplePackage.eINST ANCE);
> // Open transaction
> CDOTransaction transaction = session.openTransaction();
>
> transaction.setChangeSubscriptionPolicy(CDOChangeSubscriptio nPolicy.ALL);
> CDOResource resource =
> transaction.createResource("/Test");
> Person person = PeopleFactory.eINSTANCE.createPerson();
> person.setFirstName("Hallo");
> person.setLastName("Velo");
> resource.getContents().add(person);
> transaction.commit();
>
>
> This is only happening with Derby Embedded, but not with Postgres.
> Also using the storeType="db" is working with Derby.
>
> My model is just a simple test model with 3 features (no relations).
>
> Used Versions:
> --------------
> Eclipse SDK 3.4.1RC3
> CDO 2.0.0-I200809110653
> Net4j 2.0.0-I200809110620
> Teneo 1.0.1-M200809150739
> Derby 10.4.2
>
>
> cdo-server.xml:
> ---------------
> <?xml version="1.0" encoding="UTF-8"?>
> <cdoServer>
>
> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
> 
> </acceptor>
>
> <repository name="HPROTO">
> <property name="overrideUUID"
> value="1ff5d226-b1f3-45fb-afa2-0c30b38c764f" />
> <property name="supportingAudits" value="false" />
> <property name="verifyingRevisions" value="false" />
> <property name="currentLRUCapacity" value="10000" />
> <property name="revisedLRUCapacity" value="100" />
>
> <property name="hibernate.hbm2ddl.auto" value="update" />
> <property name="hibernate.show_sql" value="true" />
> <property name="hibernate.connection.pool_size" value="10" />
>
> <property name="hibernate.dialect"
> value="org.hibernate.dialect.DerbyDialect" />
> <property name="hibernate.connection.driver_class"
> value="org.apache.derby.jdbc.EmbeddedDriver" />
> <property name="hibernate.connection.url"
> value="jdbc:derby:ProtoDB;create=true" />
> <property name="hibernate.connection.autocommit"
> value="true" />
> <property name="hibernate.cache.provider_class"
> value="org.hibernate.cache.HashtableCacheProvider" />
>
> <property name="teneo.mapping.inheritance"
> value="TABLE_PER_CLASS" />
> <property name="teneo.naming.id_feature_as_primary_key"
> value="id" />
>
> <store type="hibernate">
> <mappingProvider type="teneo" />
> </store>
>
> </repository>
> </cdoServer>
>
>
> And the stacktrace:
> --------------------
> 2008-09-19 10:03:56 DEBUG org.hibernate.util.JDBCExceptionReporter
> could not insert:
> [org.eclipse.emf.cdo.internal.common.model.CDOPackageImpl] [insert
> into cdo_packages (uri, ecore, dynamic, parentUri, metaIDStart,
> metaIDSize, CDOPackageImpl) values (?, ?, ?, ?, ?, ?, ?)]
> java.sql.SQLException: An unexpected exception was thrown
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown 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.EmbedPreparedStatement.executeSta tement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpd ate(Unknown
> Source)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2278)
>
> at
> org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2688)
>
> at
> org.hibernate.action.EntityInsertAction.execute(EntityInsert Action.java:79)
>
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 9)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:263)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:167)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.perfor mExecutions(AbstractFlushingEventListener.java:321)
>
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(De faultFlushEventListener.java:50)
>
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java :365)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransac tion.java:137)
>
> at
> org.eclipse.emf.cdo.server.internal.hibernate.HibernatePacka geHandler.writePackages(HibernatePackageHandler.java:145)
>
> at
> org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.writePackages(HibernateStoreWriter.java:197)
>
> at
> org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.write(HibernateStoreWriter.java:60)
>
> at
> org.eclipse.emf.cdo.internal.server.TransactionCommitContext Impl.write(TransactionCommitContextImpl.java:227)
>
> at
> org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicatingCommit(CommitTransactionIndication.ja va:167)
>
> at
> org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:68)
>
> at
> org.eclipse.emf.cdo.internal.server.protocol.CDOServerIndica tion.indicating(CDOServerIndication.java:116)
>
> at org.eclipse.net4j.signal.Indication.execute(Indication.java: 48)
> at
> org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:38)
>
> at org.eclipse.net4j.signal.Signal.runSync(Signal.java:186)
> at org.eclipse.net4j.signal.Signal.run(Signal.java:167)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn
> Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLException: An unexpected exception was thrown
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 35 more
> Caused by: java.sql.SQLException: Java exception: 'A truncation error
> was encountered trying to shrink CLOB 'XXXX' to length 255.:
> org.apache.derby.iapi.services.io.DerbyIOException'.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQL Exception(Unknown
> Source)
> ... 32 more
> Caused by: org.apache.derby.iapi.services.io.DerbyIOException: A
> truncation error was encountered trying to shrink CLOB 'XXXX' to
> length 255.
> at org.apache.derby.iapi.types.ReaderToUTF8Stream.truncate(Unkn own
> Source)
> at
> org.apache.derby.iapi.types.ReaderToUTF8Stream.checkSufficie ntData(Unknown
> Source)
> at
> org.apache.derby.iapi.types.ReaderToUTF8Stream.fillBuffer(Un known Source)
> at org.apache.derby.iapi.types.ReaderToUTF8Stream.read(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.MemByteHolder.write(Unk nown Source)
> at
> org.apache.derby.impl.store.raw.data.RememberBytesInputStrea m.fillBuf(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.logColumn(Un known Source)
> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unkno wn
> Source)
> at
> org.apache.derby.impl.store.raw.data.InsertOperation.writeOp tionalDataToBuffer(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.InsertOperation.<init>(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LoggableActions.actionI nsert(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BasePage.insertNoOverfl ow(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BasePage.insertAtSlot(U nknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.insertAtSlot (Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.BasePage.insert(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapController.doIns ert(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapController.inser tAndFetchLocation(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(U nknown
> Source)
> at
> org.apache.derby.impl.sql.execute.InsertResultSet.normalInse rtCore(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)
> ... 28 more
>
>
> Any clue what could be wrong?
>
> Regards
> Roger
>
>

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: Problem with CDO/Teneo/Hibernate on Derby [message #383235 is a reply to message #383234]

Fri, 19 September 2008 10:26

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Roger, Eike,
My guess is that the default length is 255 for a text/varchar/clob and that derby throws an
exception when a longer string is inserted. While other database just truncate without exception.

You can try to solve this by adding the following annotation to the efeature which has the clob:
@Column(length=1000) (replace 1000 with the length you want to support.

Here is more information on how to set annotations in your model:
http://www.elver.org/hibernate/ejb3_format.html

gr. Martin

Eike Stepper wrote:
> Hi Roger,
>
> I added the EMF newsgroup to the list of recipients because CDO is
> supported there.
> From a first look I don't think that your code is obviously wrong
> somewhere.
> Can you please open a Bugzilla so that we can discuss and keep track?
>
> Cheers
> /Eike
>
>
> Roger schrieb:
>> Hi
>>
>> I ran into a problem when I use the TeneoHibernateMapping for CDO on
>> Apache Derby Embedded:
>> org.hibernate.exception.GenericJDBCException: could not insert:
>> [org.eclipse.emf.cdo.internal.common.model.CDOPackageImpl]
>> Caused by: org.apache.derby.iapi.services.io.DerbyIOException: A
>> truncation error was encountered trying to shrink CLOB 'XXXX' to
>> length 255.
>> (below is a Stacktrace)
>>
>> It happens when I commit the CDOTransaction after adding one eClass:
>>
>> CDOSession session = configuration.openSession();
>>
>> session.getPackageRegistry().putEPackage(PeoplePackage.eINST ANCE);
>> // Open transaction
>> CDOTransaction transaction = session.openTransaction();
>>
>> transaction.setChangeSubscriptionPolicy(CDOChangeSubscriptio nPolicy.ALL);
>> CDOResource resource =
>> transaction.createResource("/Test");
>> Person person = PeopleFactory.eINSTANCE.createPerson();
>> person.setFirstName("Hallo");
>> person.setLastName("Velo");
>> resource.getContents().add(person);
>> transaction.commit();
>>
>>
>> This is only happening with Derby Embedded, but not with Postgres.
>> Also using the storeType="db" is working with Derby.
>>
>> My model is just a simple test model with 3 features (no relations).
>>
>> Used Versions:
>> --------------
>> Eclipse SDK 3.4.1RC3
>> CDO 2.0.0-I200809110653
>> Net4j 2.0.0-I200809110620
>> Teneo 1.0.1-M200809150739
>> Derby 10.4.2
>>
>>
>> cdo-server.xml:
>> ---------------
>> <?xml version="1.0" encoding="UTF-8"?>
>> <cdoServer>
>> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
>> 
>> </acceptor>
>> <repository name="HPROTO">
>> <property name="overrideUUID"
>> value="1ff5d226-b1f3-45fb-afa2-0c30b38c764f" />
>> <property name="supportingAudits" value="false" />
>> <property name="verifyingRevisions" value="false" />
>> <property name="currentLRUCapacity" value="10000" />
>> <property name="revisedLRUCapacity" value="100" />
>> <property name="hibernate.hbm2ddl.auto" value="update" />
>> <property name="hibernate.show_sql" value="true" />
>> <property name="hibernate.connection.pool_size" value="10" />
>> <property name="hibernate.dialect"
>> value="org.hibernate.dialect.DerbyDialect" />
>> <property name="hibernate.connection.driver_class"
>> value="org.apache.derby.jdbc.EmbeddedDriver" />
>> <property name="hibernate.connection.url"
>> value="jdbc:derby:ProtoDB;create=true" />
>> <property name="hibernate.connection.autocommit"
>> value="true" />
>> <property name="hibernate.cache.provider_class"
>> value="org.hibernate.cache.HashtableCacheProvider" />
>> <property name="teneo.mapping.inheritance"
>> value="TABLE_PER_CLASS" />
>> <property name="teneo.naming.id_feature_as_primary_key"
>> value="id" />
>> <store type="hibernate">
>> <mappingProvider type="teneo" />
>> </store>
>> </repository>
>> </cdoServer>
>>
>>
>> And the stacktrace:
>> --------------------
>> 2008-09-19 10:03:56 DEBUG org.hibernate.util.JDBCExceptionReporter
>> could not insert:
>> [org.eclipse.emf.cdo.internal.common.model.CDOPackageImpl] [insert
>> into cdo_packages (uri, ecore, dynamic, parentUri, metaIDStart,
>> metaIDSize, CDOPackageImpl) values (?, ?, ?, ?, ?, ?, ?)]
>> java.sql.SQLException: An unexpected exception was thrown
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown 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.EmbedPreparedStatement.executeSta tement(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpd ate(Unknown
>> Source)
>> at
>> org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2278)
>>
>> at
>> org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2688)
>>
>> at
>> org.hibernate.action.EntityInsertAction.execute(EntityInsert Action.java:79)
>>
>> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 9)
>> at
>> org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:263)
>> at
>> org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:167)
>> at
>> org.hibernate.event.def.AbstractFlushingEventListener.perfor mExecutions(AbstractFlushingEventListener.java:321)
>>
>> at
>> org.hibernate.event.def.DefaultFlushEventListener.onFlush(De faultFlushEventListener.java:50)
>>
>> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
>> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java :365)
>> at
>> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransac tion.java:137)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.hibernate.HibernatePacka geHandler.writePackages(HibernatePackageHandler.java:145)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.writePackages(HibernateStoreWriter.java:197)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.write(HibernateStoreWriter.java:60)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.TransactionCommitContext Impl.write(TransactionCommitContextImpl.java:227)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicatingCommit(CommitTransactionIndication.ja va:167)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:68)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.protocol.CDOServerIndica tion.indicating(CDOServerIndication.java:116)
>>
>> at org.eclipse.net4j.signal.Indication.execute(Indication.java: 48)
>> at
>> org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:38)
>>
>> at org.eclipse.net4j.signal.Signal.runSync(Signal.java:186)
>> at org.eclipse.net4j.signal.Signal.run(Signal.java:167)
>> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn
>> Source)
>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>> at java.lang.Thread.run(Unknown Source)
>> Caused by: java.sql.SQLException: An unexpected exception was thrown
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
>> Source)
>> ... 35 more
>> Caused by: java.sql.SQLException: Java exception: 'A truncation error
>> was encountered trying to shrink CLOB 'XXXX' to length 255.:
>> org.apache.derby.iapi.services.io.DerbyIOException'.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
>> at
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQL Exception(Unknown
>> Source)
>> ... 32 more
>> Caused by: org.apache.derby.iapi.services.io.DerbyIOException: A
>> truncation error was encountered trying to shrink CLOB 'XXXX' to
>> length 255.
>> at org.apache.derby.iapi.types.ReaderToUTF8Stream.truncate(Unkn own
>> Source)
>> at
>> org.apache.derby.iapi.types.ReaderToUTF8Stream.checkSufficie ntData(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.types.ReaderToUTF8Stream.fillBuffer(Un known Source)
>> at org.apache.derby.iapi.types.ReaderToUTF8Stream.read(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.MemByteHolder.write(Unk nown Source)
>> at
>> org.apache.derby.impl.store.raw.data.RememberBytesInputStrea m.fillBuf(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.StoredPage.logColumn(Un known Source)
>> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unkno wn
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.InsertOperation.writeOp tionalDataToBuffer(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.InsertOperation.<init>(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.LoggableActions.actionI nsert(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.BasePage.insertNoOverfl ow(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.BasePage.insertAtSlot(U nknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.StoredPage.insertAtSlot (Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.data.BasePage.insert(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.access.heap.HeapController.doIns ert(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.access.heap.HeapController.inser tAndFetchLocation(Unknown
>> Source)
>> at
>> org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(U nknown
>> Source)
>> at
>> org.apache.derby.impl.sql.execute.InsertResultSet.normalInse rtCore(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)
>> ... 28 more
>>
>>
>> Any clue what could be wrong?
>>
>> Regards
>> Roger
>>
>>

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator

Re: Problem with CDO/Teneo/Hibernate on Derby [message #383236 is a reply to message #383235]

Fri, 19 September 2008 12:24

Roger Stocker

Messages: 16
Registered: July 2009

Junior Member

Hi

I am sorry, but I don't see where to put an annotation.

Since it happens at the insert of the CDOPackageImpl, I assume this must
be inside org.eclipse.emf.cdo.server.hibernate/mappings/meta.hbm.xml.

I can see this here (in meta.hbm.xml):
<joined-subclass name="CDOPackageImpl" table="cdo_packages" lazy="false"
extends="CDOModelElementImpl">
<key />
<property name="ecore" type="text" not-null="false" />
...

I guess, it must be the ecore property, which is of type text and
obviously gets mapped to a CLOB with size 255 in Derby.

After putting a length="32767" there, I get a different exception:

Thread-6 [debug] Persisted new Object Person id: HBM-Person-32'768
2008-09-19 14:20:06 DEBUG
org.hibernate.event.def.AbstractFlushingEventListener processing
flush-time cascades
2008-09-19 14:20:06 DEBUG
org.hibernate.event.def.AbstractFlushingEventListener dirty checking
collections
2008-09-19 14:20:06 DEBUG org.hibernate.engine.Collections
Collection found: [CDOResource.contents#1], was: [<unreferenced>]
(initialized)
2008-09-19 14:20:06 DEBUG
org.hibernate.event.def.AbstractFlushingEventListener Flushed: 2
insertions, 0 updates, 0 deletions to 2 objects
2008-09-19 14:20:06 DEBUG
org.hibernate.event.def.AbstractFlushingEventListener Flushed: 1
(re)creations, 0 updates, 0 removals to 1 collections
2008-09-19 14:20:06 DEBUG org.hibernate.pretty.Printer
listing entities:
2008-09-19 14:20:06 DEBUG org.hibernate.pretty.Printer
org.eclipse.emf.cdo.internal.common.revision.CDORevisionImpl
2008-09-19 14:20:06 DEBUG org.hibernate.pretty.Printer
org.eclipse.emf.cdo.internal.common.revision.CDORevisionImpl
2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.AbstractBatcher about
to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.util.SQLStatementLogger
insert into "cdo_resources" (e_version, path, "dtype", e_id) values (?, ?,
'cdoresource', ?)
Hibernate: insert into "cdo_resources" (e_version, path, "dtype", e_id)
values (?, ?, 'cdoresource', ?)
2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.AbstractBatcher about
to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.AbstractBatcher about
to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.util.SQLStatementLogger
insert into "person" (e_version, _resID_Entity, _resID_ID, _resID_class,
_contID_Entity, _contID_ID, _contID_class, _contFeatureID, "firstname",
"lastname", e_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into "person" (e_version, _resID_Entity, _resID_ID,
_resID_class, _contID_Entity, _contID_ID, _contID_class, _contFeatureID,
"firstname", "lastname", e_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-09-19 14:20:06 DEBUG org.hibernate.util.JDBCExceptionReporter could
not insert: [Person] [insert into "person" (e_version, _resID_Entity,
_resID_ID, _resID_class, _contID_Entity, _contID_ID, _contID_class,
_contFeatureID, "firstname", "lastname", e_id) values (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?)]
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1,
column 34.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(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.EmbedPreparedStatement.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unk nown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement( Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement( Unknown
Source)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(Abst ractBatcher.java:534)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(Abstract Batcher.java:116)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(Abstract Batcher.java:109)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(Abs tractBatcher.java:244)
at
org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2252)
at
org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2688)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsert Action.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 9)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:167)
at
org.hibernate.event.def.AbstractFlushingEventListener.perfor mExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(De faultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at
org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.write(HibernateStoreWriter.java:110)
at
org.eclipse.emf.cdo.internal.server.TransactionCommitContext Impl.write(TransactionCommitContextImpl.java:227)
at
org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicatingCommit(CommitTransactionIndication.ja va:167)
at
org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:68)
at
org.eclipse.emf.cdo.internal.server.protocol.CDOServerIndica tion.indicating(CDOServerIndication.java:116)
at org.eclipse.net4j.signal.Indication.execute(Indication.java: 48)
at
org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:38)
at org.eclipse.net4j.signal.Signal.runSync(Signal.java:186)
at org.eclipse.net4j.signal.Signal.run(Signal.java:167)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Syntax error: Encountered "_" at line 1,
column 34.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
Source)
... 38 more
Caused by: ERROR 42X01: Syntax error: Encountered "_" at line 1, column 34.
at org.apache.derby.iapi.error.StandardException.newException(U nknown
Source)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement( Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknow n Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionCont ext.prepareInternalStatement(Unknown
Source)
... 32 more

I'll open a Bugzilla...

Thanks
Roger

Report message to a moderator

Re: Problem with CDO/Teneo/Hibernate on Derby [message #383237 is a reply to message #383236]

Fri, 19 September 2008 15:41

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Roger,
I will change the mapping for the epackage. The stack trace you mention below is related to the fact
that derby does not support _ as the first character of a column/table name. If you can enter a
bugzilla for that one to then I can change that to.

gr. Martin

Roger wrote:
> Hi
>
> I am sorry, but I don't see where to put an annotation.
> Since it happens at the insert of the CDOPackageImpl, I assume this must
> be inside org.eclipse.emf.cdo.server.hibernate/mappings/meta.hbm.xml.
>
> I can see this here (in meta.hbm.xml):
> <joined-subclass name="CDOPackageImpl" table="cdo_packages" lazy="false"
> extends="CDOModelElementImpl">
> <key />
> <property name="ecore" type="text" not-null="false" />
> ...
>
> I guess, it must be the ecore property, which is of type text and
> obviously gets mapped to a CLOB with size 255 in Derby.
>
> After putting a length="32767" there, I get a different exception:
>
> Thread-6 [debug] Persisted new Object Person id: HBM-Person-32'768
> 2008-09-19 14:20:06 DEBUG
> org.hibernate.event.def.AbstractFlushingEventListener processing
> flush-time cascades
> 2008-09-19 14:20:06 DEBUG
> org.hibernate.event.def.AbstractFlushingEventListener dirty checking
> collections
> 2008-09-19 14:20:06 DEBUG org.hibernate.engine.Collections
> Collection found: [CDOResource.contents#1], was: [<unreferenced>]
> (initialized)
> 2008-09-19 14:20:06 DEBUG
> org.hibernate.event.def.AbstractFlushingEventListener Flushed: 2
> insertions, 0 updates, 0 deletions to 2 objects
> 2008-09-19 14:20:06 DEBUG
> org.hibernate.event.def.AbstractFlushingEventListener Flushed: 1
> (re)creations, 0 updates, 0 removals to 1 collections
> 2008-09-19 14:20:06 DEBUG org.hibernate.pretty.Printer
> listing entities:
> 2008-09-19 14:20:06 DEBUG org.hibernate.pretty.Printer
> org.eclipse.emf.cdo.internal.common.revision.CDORevisionImpl
> 2008-09-19 14:20:06 DEBUG org.hibernate.pretty.Printer
> org.eclipse.emf.cdo.internal.common.revision.CDORevisionImpl
> 2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.AbstractBatcher
> about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
> 2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.util.SQLStatementLogger
> insert into "cdo_resources" (e_version, path, "dtype", e_id) values (?,
> ?, 'cdoresource', ?)
> Hibernate: insert into "cdo_resources" (e_version, path, "dtype", e_id)
> values (?, ?, 'cdoresource', ?)
> 2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.AbstractBatcher
> about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
> 2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.AbstractBatcher
> about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
> 2008-09-19 14:20:06 DEBUG org.hibernate.jdbc.util.SQLStatementLogger
> insert into "person" (e_version, _resID_Entity, _resID_ID, _resID_class,
> _contID_Entity, _contID_ID, _contID_class, _contFeatureID, "firstname",
> "lastname", e_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> Hibernate: insert into "person" (e_version, _resID_Entity, _resID_ID,
> _resID_class, _contID_Entity, _contID_ID, _contID_class, _contFeatureID,
> "firstname", "lastname", e_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> 2008-09-19 14:20:06 DEBUG org.hibernate.util.JDBCExceptionReporter
> could not insert: [Person] [insert into "person" (e_version,
> _resID_Entity, _resID_ID, _resID_class, _contID_Entity, _contID_ID,
> _contID_class, _contFeatureID, "firstname", "lastname", e_id) values (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
> java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line
> 1, column 34.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(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.EmbedPreparedStatement.<init>(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unk nown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement( Unknown Source)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement( Unknown Source)
> at
> org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(Abst ractBatcher.java:534)
>
> at
> org.hibernate.jdbc.AbstractBatcher.prepareStatement(Abstract Batcher.java:116)
>
> at
> org.hibernate.jdbc.AbstractBatcher.prepareStatement(Abstract Batcher.java:109)
>
> at
> org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(Abs tractBatcher.java:244)
>
> at
> org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2252)
>
> at
> org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2688)
>
> at
> org.hibernate.action.EntityInsertAction.execute(EntityInsert Action.java:79)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 9)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:263)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:167)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.perfor mExecutions(AbstractFlushingEventListener.java:321)
>
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(De faultFlushEventListener.java:50)
>
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
> at
> org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Writer.write(HibernateStoreWriter.java:110)
>
> at
> org.eclipse.emf.cdo.internal.server.TransactionCommitContext Impl.write(TransactionCommitContextImpl.java:227)
>
> at
> org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicatingCommit(CommitTransactionIndication.ja va:167)
>
> at
> org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:68)
>
> at
> org.eclipse.emf.cdo.internal.server.protocol.CDOServerIndica tion.indicating(CDOServerIndication.java:116)
>
> at org.eclipse.net4j.signal.Indication.execute(Indication.java: 48)
> at
> org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:38)
>
> at org.eclipse.net4j.signal.Signal.runSync(Signal.java:186)
> at org.eclipse.net4j.signal.Signal.run(Signal.java:167)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn
> Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLException: Syntax error: Encountered "_" at line
> 1, column 34.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 38 more
> Caused by: ERROR 42X01: Syntax error: Encountered "_" at line 1, column 34.
> at
> org.apache.derby.iapi.error.StandardException.newException(U nknown Source)
> at
> org.apache.derby.impl.sql.compile.ParserImpl.parseStatement( Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknow n
> Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionCont ext.prepareInternalStatement(Unknown
> Source)
> ... 32 more
>
>
> I'll open a Bugzilla...
>
> Thanks
> Roger
>

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator