Eclipse Community Forums: EMF » cdo (derby db) and resource import containing single quotation mark(s) in string

Help

Home

Home » Modeling » EMF » cdo (derby db) and resource import containing single quotation mark(s) in string

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

cdo (derby db) and resource import containing single quotation mark(s) in string [message #423861]

Wed, 08 October 2008 10:10

Ralf Buschermoehle

Messages: 27
Registered: July 2009

Junior Member

Hello,

I have an ecore model with string containing single quotation marks
e.g., <effects effect="a = 'hello'"/> when I try to store this into the
(example, default) derby database it throws the error

SQL Exception: Lexical error at line ... Encountered "\\"(92), after: ""

Greetings,

Ralf

Report message to a moderator

Re: cdo (derby db) and resource import containing single quotation mark(s) in string [message #423862 is a reply to message #423861]

Wed, 08 October 2008 10:22

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Hi Ralf,

It looks a bit like:

225125: [DB] Quotes are not escaped (enough)
https://bugs.eclipse.org/bugs/show_bug.cgi?id=225125

Please reopen this Bugzilla if you find it appropriate.
And could you please try to commit data with the quote *not* at the
beginning or end of the string?
Just to give me a hint...

Cheers
/Eike

Ralf Buschermoehle schrieb:
> Hello,
>
> I have an ecore model with string containing single quotation marks
> e.g., <effects effect="a = 'hello'"/> when I try to store this into the
> (example, default) derby database it throws the error
>
> SQL Exception: Lexical error at line ... Encountered "\\"(92), after: ""
>
> Greetings,
>
> Ralf

Cheers
/Eike

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

Report message to a moderator

previously "Re: cdo (derby db) and resource import containing single quotation mark(s) in strin [message #423874 is a reply to message #423862]

Wed, 08 October 2008 13:25

Ralf Buschermoehle

Messages: 27
Registered: July 2009

Junior Member

Hi Eike,

done ...

BTW: I would like to change the db from derby to mysql.

Where do I get the required plugin(s)?

[INFO] CDO Server starting
[ERROR] java.lang.ClassNotFoundException:
com.mysql.jdbc.jdbc2.optional.MysqlDataSource

Greetings,

Ralf

Eike Stepper wrote:
> Hi Ralf,
>
> It looks a bit like:
>
> 225125: [DB] Quotes are not escaped (enough)
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=225125
>
> Please reopen this Bugzilla if you find it appropriate.
> And could you please try to commit data with the quote *not* at the
> beginning or end of the string?
> Just to give me a hint...
>
> Cheers
> /Eike
>
>
> Ralf Buschermoehle schrieb:
>> Hello,
>>
>> I have an ecore model with string containing single quotation marks
>> e.g., <effects effect="a = 'hello'"/> when I try to store this into the
>> (example, default) derby database it throws the error
>>
>> SQL Exception: Lexical error at line ... Encountered "\\"(92), after: ""
>>
>> Greetings,
>>
>> Ralf

Report message to a moderator

Re: previously "Re: cdo (derby db) and resource import containing single quotation mark(s) in s [message #423876 is a reply to message #423874]

Wed, 08 October 2008 14:01

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Ralf Buschermoehle schrieb:
> Hi Eike,
>
> done ...
>
> BTW: I would like to change the db from derby to mysql.
>
> Where do I get the required plugin(s)?
>
> [INFO] CDO Server starting
> [ERROR] java.lang.ClassNotFoundException:
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource
We're getting all our 3rd party bundles from either Orbit [1] or
SpringSource [2]. Please consider voting/commenting on [3] to make using
SpringSource bundles easier!

[1] http://download.eclipse.org/tools/orbit/downloads
[2] http://www.springsource.com/repository/app
[3] https://issuetracker.springsource.com/browse/BRITS-92

Cheers
/Eike

>
> Greetings,
>
> Ralf
>
> Eike Stepper wrote:
>> Hi Ralf,
>>
>> It looks a bit like:
>>
>> 225125: [DB] Quotes are not escaped (enough)
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=225125
>>
>> Please reopen this Bugzilla if you find it appropriate.
>> And could you please try to commit data with the quote *not* at the
>> beginning or end of the string?
>> Just to give me a hint...
>>
>> Cheers
>> /Eike
>>
>>
>> Ralf Buschermoehle schrieb:
>>> Hello,
>>>
>>> I have an ecore model with string containing single quotation marks
>>> e.g., <effects effect="a = 'hello'"/> when I try to store this into the
>>> (example, default) derby database it throws the error
>>>
>>> SQL Exception: Lexical error at line ... Encountered "\\"(92),
>>> after: ""
>>>
>>> Greetings,
>>>
>>> Ralf

Cheers
/Eike

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

Report message to a moderator

Previous Topic:	Adapting Model Objects
Next Topic:	Setting "Root Extends Interface" per class?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:44:30 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter