Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [CDO] Exception when using ' in Strings
[CDO] Exception when using ' in Strings [message #124177] Fri, 30 May 2008 13:27 Go to next message
Marc Moser is currently offline Marc MoserFriend
Messages: 66
Registered: July 2009
Member
Hi,

I get an exception when trying to save a sesource that contains ' in a
string. I noticed this behavior because I tried to import an existing
resource into the CDO repository. The resource works fine in EMF, and
it correctly imports to CDO, but I get an SQL exception (see below)
when trying to save the resource in CDO.

Am I missing a configuration feature of CDO (or Derby) or is this a
bug? I'm currently using CDO with embedded-derby.

Best,
Marc

[ERROR] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
"s" at line 1, column 76.
org.eclipse.net4j.db.DBException: java.sql.SQLSyntaxErrorException:
Syntax error: Encountered "s" at line 1, column 76.
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:200)
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:51)
at
org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:179)
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(Unkno wn Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered
"s" at line 1, column 76.
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.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: java.sql.SQLException: Syntax error: Encountered "s" at
line 1, column 76.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
Source)
... 24 more
Caused by: ERROR 42X01: Syntax error: Encountered "s" at line 1,
column 76.
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)
... 18 more
Re: [CDO] Exception when using ' in Strings [message #124204 is a reply to message #124177] Fri, 30 May 2008 13:48 Go to previous messageGo to next message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Marc,
I can't help you with this one, as I don't know the cdo-db logic. Eike will be back in 2 days. So
then he will surely look at it.

gr. Martin

Marc Moser wrote:
> Hi,
>
> I get an exception when trying to save a sesource that contains ' in a
> string. I noticed this behavior because I tried to import an existing
> resource into the CDO repository. The resource works fine in EMF, and
> it correctly imports to CDO, but I get an SQL exception (see below)
> when trying to save the resource in CDO.
>
> Am I missing a configuration feature of CDO (or Derby) or is this a
> bug? I'm currently using CDO with embedded-derby.
>
> Best,
> Marc
>
> [ERROR] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> org.eclipse.net4j.db.DBException: java.sql.SQLSyntaxErrorException:
> Syntax error: Encountered "s" at line 1, column 76.
> 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:200)
> 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:51)
> at
> org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:179)
> 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(Unkno wn Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> 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.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: java.sql.SQLException: Syntax error: Encountered "s" at
> line 1, column 76.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 24 more
> Caused by: ERROR 42X01: Syntax error: Encountered "s" at line 1,
> column 76.
> 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)
> ... 18 more


--

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
Re: [CDO] Exception when using ' in Strings [message #124218 is a reply to message #124177] Fri, 30 May 2008 14:00 Go to previous messageGo to next message
Cedric Brun is currently offline Cedric BrunFriend
Messages: 431
Registered: July 2009
Senior Member
Hi Marc,

this is a known bug reported here :
https://bugs.eclipse.org/bugs/show_bug.cgi?id=225125

Cheers,

Cédric

Marc Moser wrote:

> Hi,
>
> I get an exception when trying to save a sesource that contains ' in a
> string. I noticed this behavior because I tried to import an existing
> resource into the CDO repository. The resource works fine in EMF, and
> it correctly imports to CDO, but I get an SQL exception (see below)
> when trying to save the resource in CDO.
>
> Am I missing a configuration feature of CDO (or Derby) or is this a
> bug? I'm currently using CDO with embedded-derby.
>
> Best,
> Marc
>
> [ERROR] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> org.eclipse.net4j.db.DBException: java.sql.SQLSyntaxErrorException:
> Syntax error: Encountered "s" at line 1, column 76.
> 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:200)
> 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:51)
> at
>
org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:179)
> 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(Unkno wn Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> 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.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: java.sql.SQLException: Syntax error: Encountered "s" at
> line 1, column 76.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
>
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 24 more
> Caused by: ERROR 42X01: Syntax error: Encountered "s" at line 1,
> column 76.
> 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)
> ... 18 more


http://cedric.brun.io news and articles on eclipse and eclipse modeling.
Re: [CDO] Exception when using ' in Strings [message #124368 is a reply to message #124177] Sat, 31 May 2008 16:46 Go to previous message
Eclipse UserFriend
Originally posted by: stepper.sympedia.de

Marc,

Cedric is right, the issue is known and will be solved by using more
prepared statements in the DBStoreWriter. Have you already switched to
the HibernateStore?

Cheers
/Eike


Marc Moser schrieb:
> Hi,
>
> I get an exception when trying to save a sesource that contains ' in a
> string. I noticed this behavior because I tried to import an existing
> resource into the CDO repository. The resource works fine in EMF, and
> it correctly imports to CDO, but I get an SQL exception (see below)
> when trying to save the resource in CDO.
>
> Am I missing a configuration feature of CDO (or Derby) or is this a
> bug? I'm currently using CDO with embedded-derby.
>
> Best,
> Marc
>
> [ERROR] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> org.eclipse.net4j.db.DBException: java.sql.SQLSyntaxErrorException:
> Syntax error: Encountered "s" at line 1, column 76.
> 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:200)
> 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:51)
> at
> org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:179)
> 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(Unkno wn Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> 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.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: java.sql.SQLException: Syntax error: Encountered "s" at
> line 1, column 76.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 24 more
> Caused by: ERROR 42X01: Syntax error: Encountered "s" at line 1,
> column 76.
> 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)
> ... 18 more
>
Re: [CDO] Exception when using ' in Strings [message #619107 is a reply to message #124177] Fri, 30 May 2008 13:48 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Marc,
I can't help you with this one, as I don't know the cdo-db logic. Eike will be back in 2 days. So
then he will surely look at it.

gr. Martin

Marc Moser wrote:
> Hi,
>
> I get an exception when trying to save a sesource that contains ' in a
> string. I noticed this behavior because I tried to import an existing
> resource into the CDO repository. The resource works fine in EMF, and
> it correctly imports to CDO, but I get an SQL exception (see below)
> when trying to save the resource in CDO.
>
> Am I missing a configuration feature of CDO (or Derby) or is this a
> bug? I'm currently using CDO with embedded-derby.
>
> Best,
> Marc
>
> [ERROR] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> org.eclipse.net4j.db.DBException: java.sql.SQLSyntaxErrorException:
> Syntax error: Encountered "s" at line 1, column 76.
> 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:200)
> 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:51)
> at
> org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:179)
> 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(Unkno wn Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> 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.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: java.sql.SQLException: Syntax error: Encountered "s" at
> line 1, column 76.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 24 more
> Caused by: ERROR 42X01: Syntax error: Encountered "s" at line 1,
> column 76.
> 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)
> ... 18 more


--

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
Re: [CDO] Exception when using ' in Strings [message #619108 is a reply to message #124177] Fri, 30 May 2008 14:00 Go to previous message
Cedric Brun is currently offline Cedric BrunFriend
Messages: 431
Registered: July 2009
Senior Member
Hi Marc,

this is a known bug reported here :
https://bugs.eclipse.org/bugs/show_bug.cgi?id=225125

Cheers,

Cédric

Marc Moser wrote:

> Hi,
>
> I get an exception when trying to save a sesource that contains ' in a
> string. I noticed this behavior because I tried to import an existing
> resource into the CDO repository. The resource works fine in EMF, and
> it correctly imports to CDO, but I get an SQL exception (see below)
> when trying to save the resource in CDO.
>
> Am I missing a configuration feature of CDO (or Derby) or is this a
> bug? I'm currently using CDO with embedded-derby.
>
> Best,
> Marc
>
> [ERROR] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> org.eclipse.net4j.db.DBException: java.sql.SQLSyntaxErrorException:
> Syntax error: Encountered "s" at line 1, column 76.
> 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:200)
> 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:51)
> at
>
org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:179)
> 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(Unkno wn Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> 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.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: java.sql.SQLException: Syntax error: Encountered "s" at
> line 1, column 76.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
>
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 24 more
> Caused by: ERROR 42X01: Syntax error: Encountered "s" at line 1,
> column 76.
> 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)
> ... 18 more


http://cedric.brun.io news and articles on eclipse and eclipse modeling.
Re: [CDO] Exception when using ' in Strings [message #619118 is a reply to message #124177] Sat, 31 May 2008 16:46 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
Marc,

Cedric is right, the issue is known and will be solved by using more
prepared statements in the DBStoreWriter. Have you already switched to
the HibernateStore?

Cheers
/Eike


Marc Moser schrieb:
> Hi,
>
> I get an exception when trying to save a sesource that contains ' in a
> string. I noticed this behavior because I tried to import an existing
> resource into the CDO repository. The resource works fine in EMF, and
> it correctly imports to CDO, but I get an SQL exception (see below)
> when trying to save the resource in CDO.
>
> Am I missing a configuration feature of CDO (or Derby) or is this a
> bug? I'm currently using CDO with embedded-derby.
>
> Best,
> Marc
>
> [ERROR] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> org.eclipse.net4j.db.DBException: java.sql.SQLSyntaxErrorException:
> Syntax error: Encountered "s" at line 1, column 76.
> 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:200)
> 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:51)
> at
> org.eclipse.emf.cdo.internal.server.Transaction.commit(Trans action.java:179)
> 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(Unkno wn Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered
> "s" at line 1, column 76.
> 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.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: java.sql.SQLException: Syntax error: Encountered "s" at
> line 1, column 76.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 24 more
> Caused by: ERROR 42X01: Syntax error: Encountered "s" at line 1,
> column 76.
> 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)
> ... 18 more
>


Previous Topic:Are CDO Transactions transparent?
Next Topic:[CDO] Export to an EMF resource?
Goto Forum:
  


Current Time: Thu Apr 25 11:18:05 GMT 2024

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

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

Back to the top