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 |
Marc Moser 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 |
Martin Taal 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 |
Cedric Brun 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 |
Eclipse User |
|
|
|
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 |
Martin Taal 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 |
Cedric Brun 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 |
|
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
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Goto Forum:
Current Time: Thu Apr 25 11:18:05 GMT 2024
Powered by FUDForum. Page generated in 0.03397 seconds
|