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.

Report message to a moderator

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

Report message to a moderator

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
>

Report message to a moderator

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
>>

Report message to a moderator

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
>>>

Report message to a moderator

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

Cheers
/Eike

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

Report message to a moderator

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
>

Report message to a moderator

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
>>

Report message to a moderator

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
>>>

Cheers
/Eike

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 22:38:39 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly