Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » cdo (derby db) and resource import containing single quotation mark(s) in string
cdo (derby db) and resource import containing single quotation mark(s) in string [message #423861] Wed, 08 October 2008 10:10 Go to next message
Ralf Buschermoehle is currently offline Ralf BuschermoehleFriend
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
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 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6469
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


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 Go to previous messageGo to next message
Ralf Buschermoehle is currently offline Ralf BuschermoehleFriend
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
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 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6469
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


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


Current Time: Wed Jan 29 18:48:19 GMT 2020

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

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

Back to the top