From: <glassfish_at_javadesktop.org>
Date: Fri, 20 Mar 2009 00:29:11 PDT

Hi,

You need to add
                        <property name="toplink.target-database" value="MySQL4"/>
to your persistence.xml file

it goes something like this.. in SE environment.
<properties>
                        <property name="toplink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
                        <property name="toplink.jdbc.url" value="jdbc:mysql://localhost:3306/company"/>
                        <property name="toplink.jdbc.user" value="root"/>
                        <property name="toplink.jdbc.password" value="root"/>
                        <property name="toplink.jdbc.read-connections.max" value="3"/>
                        <property name="toplink.jdbc.read-connections.min" value="1"/>
                        <property name="toplink.jdbc.read-connections.shared" value="true"/>
                        <property name="toplink.jdbc.write-connections.max" value="5"/>
                        <property name="toplink.jdbc.write-connections.min" value="2"/>
                        <property name="toplink.cache.type.default" value="Full"/>
                        <property name="toplink.target-database" value="MySQL4"/>
                        <property name="toplink.ddl-generation" value="drop-and-create-tables"/>
        </properties>

hope this may solve yr problem

nitin
[Message sent by forum member 'nit_tin' (nit_tin)]

http://forums.java.net/jive/thread.jspa?messageID=338079