I have problem getting Toplink to generate a proper mysql schema when run in Glassfish and using a mysql connection pool + jdbc datasource versus standalone toplink essentials and hardcoded jdbc url + user + password in the persistence.xml.
It looks like it doesn't generate Mysql specific schemas but is reverting to some sort of general SQL schema. Toplink does recognize the database as a mysql database according to the log (by printing out platform=>MySQL4Platform).
in an @Entity i have a field of type String[], in the standalone version it is mapped to a BLOB, probably using serialization or something. However if I use the exact same @Entity class in glassfish, it is mapped to a VARCHAR(255).
I have a similar problem using a @Lob String, in the standalone version it is mapped to MEDIUMTEXT, but in the glassfish version it is mapped to TEXT
In the log during deploy the database is recognized as a MySQL4Platform
JDBC Driver version: mysql-connector-java-5.0.5
Mysql version: MySQL Version: 5.0.37-log
Glassfish is the bundled glassfish from Netbeans 5.5.1
Has anybody seen this before?
[Message sent by forum member 'xylifyx' (xylifyx)]
http://forums.java.net/jive/thread.jspa?messageID=222667