Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [CDO] mysql support
[CDO] mysql support [message #102035] Thu, 08 November 2007 19:12 Go to next message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
Eike,

Is the mysql support in CDO ready for testing...?

Mark.
Re: [CDO] mysql support [message #102055 is a reply to message #102035] Thu, 08 November 2007 19:37 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: stepper.sympedia.de

Mark Geib schrieb:
> Eike,
>
> Is the mysql support in CDO ready for testing...?
Yes, it's there since
http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
Testing is good since I'm not a special MySql expert and I had to fight
with, for instance, ugly key size limitations and non-standard string
data types ;-(
But all my tests with the tests.model1 have been successful.

Regards,
Eike Stepper
----
http://wiki.eclipse.org/?title=CDO
http://wiki.eclipse.org/?title=Net4j
Re: [CDO] mysql support [message #102059 is a reply to message #102055] Thu, 08 November 2007 21:23 Go to previous messageGo to next message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
Eike,

Just tried mysql and got the following...not that you are surprised..

main [debug.signal] ================ Confirming CommitTransactionRequest
TCPSelector [debug] Reading java.nio.channels.SocketChannel[connected
local=/127.0.0.1:42023 remote=localhost/127.0.0.1:2036]
TCPSelector [debug.buffer] Obtained Buffer@10
TCPSelector [debug.buffer] Read 104 bytes (EOS)
00 00 00 03 00 01 00 5f 63 6f 6d 2e 6d 79 73 71 6c 2e 6a 64 62 63 2e 4d
79 73 71 6c 44 61 74 61 54 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61
20 74 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61 20 74 72 75 6e 63 61
74 65 64 20 66 6f 72 20 63 6f 6c 75 6d 6e 20 27 65 63 6f 72 65 27 20 61
74 20 72 6f 77 20 31 00
TCPSelector [debug.channel] Handling buffer from multiplexer: Buffer@10
--> Channel[0]
Thread-5 [debug.signal] Received buffer for correlation -4
main [debug.buffer] Retaining Buffer@10
[ERROR] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
truncated for column 'ecore' at row 1
Application Started: 13378


Mark.


Eike Stepper wrote:
> Mark Geib schrieb:
>> Eike,
>>
>> Is the mysql support in CDO ready for testing...?
> Yes, it's there since
> http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
>
> Testing is good since I'm not a special MySql expert and I had to fight
> with, for instance, ugly key size limitations and non-standard string
> data types ;-(
> But all my tests with the tests.model1 have been successful.
>
> Regards,
> Eike Stepper
> ----
> http://wiki.eclipse.org/?title=CDO
> http://wiki.eclipse.org/?title=Net4j
>
Re: [CDO] mysql support [message #102066 is a reply to message #102059] Thu, 08 November 2007 21:49 Go to previous messageGo to next message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
Eike,

I changed the type of TEXT to LONGTEXT for the mysql adapeter and got
past this error.

Mark.



Mark Geib wrote:
> Eike,
>
> Just tried mysql and got the following...not that you are surprised..
>
> main [debug.signal] ================ Confirming CommitTransactionRequest
> TCPSelector [debug] Reading java.nio.channels.SocketChannel[connected
> local=/127.0.0.1:42023 remote=localhost/127.0.0.1:2036]
> TCPSelector [debug.buffer] Obtained Buffer@10
> TCPSelector [debug.buffer] Read 104 bytes (EOS)
> 00 00 00 03 00 01 00 5f 63 6f 6d 2e 6d 79 73 71 6c 2e 6a 64 62 63 2e 4d
> 79 73 71 6c 44 61 74 61 54 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61
> 20 74 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61 20 74 72 75 6e 63 61
> 74 65 64 20 66 6f 72 20 63 6f 6c 75 6d 6e 20 27 65 63 6f 72 65 27 20 61
> 74 20 72 6f 77 20 31 00
> TCPSelector [debug.channel] Handling buffer from multiplexer: Buffer@10
> --> Channel[0]
> Thread-5 [debug.signal] Received buffer for correlation -4
> main [debug.buffer] Retaining Buffer@10
> [ERROR] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
> truncated for column 'ecore' at row 1
> Application Started: 13378
>
>
> Mark.
>
>
> Eike Stepper wrote:
>> Mark Geib schrieb:
>>> Eike,
>>>
>>> Is the mysql support in CDO ready for testing...?
>> Yes, it's there since
>> http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
>>
>> Testing is good since I'm not a special MySql expert and I had to
>> fight with, for instance, ugly key size limitations and non-standard
>> string data types ;-(
>> But all my tests with the tests.model1 have been successful.
>>
>> Regards,
>> Eike Stepper
>> ----
>> http://wiki.eclipse.org/?title=CDO
>> http://wiki.eclipse.org/?title=Net4j
>>
Re: [CDO] mysql support [message #102101 is a reply to message #102066] Thu, 08 November 2007 22:45 Go to previous message
Eclipse UserFriend
Originally posted by: stepper.sympedia.de

Mark Geib schrieb:
> Eike,
>
> I changed the type of TEXT to LONGTEXT for the mysql adapeter and got
> past this error.
Ah, that's what I mean with "I'm not a Mysql expert" ;-)
I never understodd why Mysql needs to invent these crazy data types!
I'll adjust the adapter accordingly.

Regards,
Eike Stepper
----
http://wiki.eclipse.org/?title=CDO
http://wiki.eclipse.org/?title=Net4j



>
> Mark.
>
>
>
> Mark Geib wrote:
>> Eike,
>>
>> Just tried mysql and got the following...not that you are surprised..
>>
>> main [debug.signal] ================ Confirming CommitTransactionRequest
>> TCPSelector [debug] Reading java.nio.channels.SocketChannel[connected
>> local=/127.0.0.1:42023 remote=localhost/127.0.0.1:2036]
>> TCPSelector [debug.buffer] Obtained Buffer@10
>> TCPSelector [debug.buffer] Read 104 bytes (EOS)
>> 00 00 00 03 00 01 00 5f 63 6f 6d 2e 6d 79 73 71 6c 2e 6a 64 62 63 2e
>> 4d 79 73 71 6c 44 61 74 61 54 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61
>> 74 61 20 74 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61 20 74 72 75
>> 6e 63 61 74 65 64 20 66 6f 72 20 63 6f 6c 75 6d 6e 20 27 65 63 6f 72
>> 65 27 20 61 74 20 72 6f 77 20 31 00
>> TCPSelector [debug.channel] Handling buffer from multiplexer:
>> Buffer@10 --> Channel[0]
>> Thread-5 [debug.signal] Received buffer for correlation -4
>> main [debug.buffer] Retaining Buffer@10
>> [ERROR] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
>> truncated for column 'ecore' at row 1
>> Application Started: 13378
>>
>>
>> Mark.
>>
>>
>> Eike Stepper wrote:
>>> Mark Geib schrieb:
>>>> Eike,
>>>>
>>>> Is the mysql support in CDO ready for testing...?
>>> Yes, it's there since
>>> http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
>>>
>>> Testing is good since I'm not a special MySql expert and I had to
>>> fight with, for instance, ugly key size limitations and non-standard
>>> string data types ;-(
>>> But all my tests with the tests.model1 have been successful.
>>>
>>> Regards,
>>> Eike Stepper
>>> ----
>>> http://wiki.eclipse.org/?title=CDO
>>> http://wiki.eclipse.org/?title=Net4j
>>>
Re: [CDO] mysql support [message #610481 is a reply to message #102035] Thu, 08 November 2007 19:37 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
Mark Geib schrieb:
> Eike,
>
> Is the mysql support in CDO ready for testing...?
Yes, it's there since
http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
Testing is good since I'm not a special MySql expert and I had to fight
with, for instance, ugly key size limitations and non-standard string
data types ;-(
But all my tests with the tests.model1 have been successful.

Regards,
Eike Stepper
----
http://wiki.eclipse.org/?title=CDO
http://wiki.eclipse.org/?title=Net4j


Re: [CDO] mysql support [message #610482 is a reply to message #102055] Thu, 08 November 2007 21:23 Go to previous message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
Eike,

Just tried mysql and got the following...not that you are surprised..

main [debug.signal] ================ Confirming CommitTransactionRequest
TCPSelector [debug] Reading java.nio.channels.SocketChannel[connected
local=/127.0.0.1:42023 remote=localhost/127.0.0.1:2036]
TCPSelector [debug.buffer] Obtained Buffer@10
TCPSelector [debug.buffer] Read 104 bytes (EOS)
00 00 00 03 00 01 00 5f 63 6f 6d 2e 6d 79 73 71 6c 2e 6a 64 62 63 2e 4d
79 73 71 6c 44 61 74 61 54 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61
20 74 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61 20 74 72 75 6e 63 61
74 65 64 20 66 6f 72 20 63 6f 6c 75 6d 6e 20 27 65 63 6f 72 65 27 20 61
74 20 72 6f 77 20 31 00
TCPSelector [debug.channel] Handling buffer from multiplexer: Buffer@10
--> Channel[0]
Thread-5 [debug.signal] Received buffer for correlation -4
main [debug.buffer] Retaining Buffer@10
[ERROR] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
truncated for column 'ecore' at row 1
Application Started: 13378


Mark.


Eike Stepper wrote:
> Mark Geib schrieb:
>> Eike,
>>
>> Is the mysql support in CDO ready for testing...?
> Yes, it's there since
> http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
>
> Testing is good since I'm not a special MySql expert and I had to fight
> with, for instance, ugly key size limitations and non-standard string
> data types ;-(
> But all my tests with the tests.model1 have been successful.
>
> Regards,
> Eike Stepper
> ----
> http://wiki.eclipse.org/?title=CDO
> http://wiki.eclipse.org/?title=Net4j
>
Re: [CDO] mysql support [message #610483 is a reply to message #102059] Thu, 08 November 2007 21:49 Go to previous message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
Eike,

I changed the type of TEXT to LONGTEXT for the mysql adapeter and got
past this error.

Mark.



Mark Geib wrote:
> Eike,
>
> Just tried mysql and got the following...not that you are surprised..
>
> main [debug.signal] ================ Confirming CommitTransactionRequest
> TCPSelector [debug] Reading java.nio.channels.SocketChannel[connected
> local=/127.0.0.1:42023 remote=localhost/127.0.0.1:2036]
> TCPSelector [debug.buffer] Obtained Buffer@10
> TCPSelector [debug.buffer] Read 104 bytes (EOS)
> 00 00 00 03 00 01 00 5f 63 6f 6d 2e 6d 79 73 71 6c 2e 6a 64 62 63 2e 4d
> 79 73 71 6c 44 61 74 61 54 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61
> 20 74 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61 20 74 72 75 6e 63 61
> 74 65 64 20 66 6f 72 20 63 6f 6c 75 6d 6e 20 27 65 63 6f 72 65 27 20 61
> 74 20 72 6f 77 20 31 00
> TCPSelector [debug.channel] Handling buffer from multiplexer: Buffer@10
> --> Channel[0]
> Thread-5 [debug.signal] Received buffer for correlation -4
> main [debug.buffer] Retaining Buffer@10
> [ERROR] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
> truncated for column 'ecore' at row 1
> Application Started: 13378
>
>
> Mark.
>
>
> Eike Stepper wrote:
>> Mark Geib schrieb:
>>> Eike,
>>>
>>> Is the mysql support in CDO ready for testing...?
>> Yes, it's there since
>> http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
>>
>> Testing is good since I'm not a special MySql expert and I had to
>> fight with, for instance, ugly key size limitations and non-standard
>> string data types ;-(
>> But all my tests with the tests.model1 have been successful.
>>
>> Regards,
>> Eike Stepper
>> ----
>> http://wiki.eclipse.org/?title=CDO
>> http://wiki.eclipse.org/?title=Net4j
>>
Re: [CDO] mysql support [message #610486 is a reply to message #102066] Thu, 08 November 2007 22:45 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
Mark Geib schrieb:
> Eike,
>
> I changed the type of TEXT to LONGTEXT for the mysql adapeter and got
> past this error.
Ah, that's what I mean with "I'm not a Mysql expert" ;-)
I never understodd why Mysql needs to invent these crazy data types!
I'll adjust the adapter accordingly.

Regards,
Eike Stepper
----
http://wiki.eclipse.org/?title=CDO
http://wiki.eclipse.org/?title=Net4j



>
> Mark.
>
>
>
> Mark Geib wrote:
>> Eike,
>>
>> Just tried mysql and got the following...not that you are surprised..
>>
>> main [debug.signal] ================ Confirming CommitTransactionRequest
>> TCPSelector [debug] Reading java.nio.channels.SocketChannel[connected
>> local=/127.0.0.1:42023 remote=localhost/127.0.0.1:2036]
>> TCPSelector [debug.buffer] Obtained Buffer@10
>> TCPSelector [debug.buffer] Read 104 bytes (EOS)
>> 00 00 00 03 00 01 00 5f 63 6f 6d 2e 6d 79 73 71 6c 2e 6a 64 62 63 2e
>> 4d 79 73 71 6c 44 61 74 61 54 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61
>> 74 61 20 74 72 75 6e 63 61 74 69 6f 6e 3a 20 44 61 74 61 20 74 72 75
>> 6e 63 61 74 65 64 20 66 6f 72 20 63 6f 6c 75 6d 6e 20 27 65 63 6f 72
>> 65 27 20 61 74 20 72 6f 77 20 31 00
>> TCPSelector [debug.channel] Handling buffer from multiplexer:
>> Buffer@10 --> Channel[0]
>> Thread-5 [debug.signal] Received buffer for correlation -4
>> main [debug.buffer] Retaining Buffer@10
>> [ERROR] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
>> truncated for column 'ecore' at row 1
>> Application Started: 13378
>>
>>
>> Mark.
>>
>>
>> Eike Stepper wrote:
>>> Mark Geib schrieb:
>>>> Eike,
>>>>
>>>> Is the mysql support in CDO ready for testing...?
>>> Yes, it's there since
>>> http://www.eclipse.org/modeling/emft/news/relnotes.php?proje ct=net4j&version=I200711011326
>>>
>>> Testing is good since I'm not a special MySql expert and I had to
>>> fight with, for instance, ugly key size limitations and non-standard
>>> string data types ;-(
>>> But all my tests with the tests.model1 have been successful.
>>>
>>> Regards,
>>> Eike Stepper
>>> ----
>>> http://wiki.eclipse.org/?title=CDO
>>> http://wiki.eclipse.org/?title=Net4j
>>>


Previous Topic:[Copare] Diff model description
Next Topic:[Copare] Diff model description
Goto Forum:
  


Current Time: Sat Apr 13 18:47:31 GMT 2024

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

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

Back to the top