MySQL Data Types - Test Case / Tutorial

[mduffy_lists]

I've gone through the MySQL manual and I've created a test case / tutorial that covers all the data types in the manual except for ENUM and SET.

I am please to report that all the data types work. I have a table that has a column for each data type. I have a bean with fields that map to the columns. I can use EJB 3.0 methods to manage the data in the table.

As reported in this forum, the BLOB and CLOB data types are not fully implemented. The upper limit for all the BLOB/CLOB types in MySQL (BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT ) seems to be an array size of 32,694 (this is such an odd number; just for curiosity sake, if someone can explain why the limit is 32,694, I'd appreciate it).

Also, it seems that this 32,694 limit is for reads (the writes go beyond this value).

Can anyone give me some guidance as to who I should contact at JBOSS regarding this tutorial?

Thanks.

Mike

[bill.burke]

BLOB and CLOB is supported in CVS. Try it out if you want.

As for the tutorial for EJB 3 and MySql, feel free to expand the WIKI:

http://www.jboss.org/wiki/Wiki.jsp

I haven't added an EJB3 page yet, but feel free to do so and I'll link it to the main EJB3 page.

Thanks for putting this together!

FYI: Blob support has been added to CVS.

Bill

[binario]

Yes please do add this to the wiki!
It would be very useful.
Good work!

[mduffy_lists]

There doesn't seem to be an easy way to expand the WIKI to add a section for EJB 3.0.

If someone with CVS commit privileges would like to evaluate the source code, I think it would be best to commit this code to the jboss-EJB-3.0_Preview_2 dist under docs/tutorial. I've set up everything just like the other tutorials (Client.class, build.xml, guide.html, etc.).

In the interim, if anyone would like a zip file, please email me: [e-mail]

Mike

[janprill]

Hi, Mike,

I've just - at least for the most part - put the tutorial to the wiki. Somebody had already converted the html-files of the tutorial to .wiki-files. It would be great if you could share your testcase. All you need to do is log in as a member and edit the pages. Feel free to mail it to [e-mail] if you experience any problems.

best regards
Jan Prill