users@glassfish.java.net

Question regarding using MySql database

From: <glassfish_at_javadesktop.org>
Date: Mon, 21 May 2007 11:37:47 PDT

Hi.

I'm trying to do an example of EJB 3 persistence with NetBeans, Glassfish & MySql. The problem I'm facing is that no matter how i configure the persistence.xml, the container always use the embedded derby database (and it works well), but i want to make it work on MySql. What am i missing?.
I have already checked that the deployed persistence.xml points to the MySql connection.

persistence.xml

<persistence-unit name="titan">
    <provider>oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider</provider>
    <class>com.titan.clients.Client</class>
    <properties>
      <property name="toplink.jdbc.url" value="jdbc:mysql://localhost:3306/test"/>
      <property name="toplink.jdbc.user" value="user"/>
      <property name="toplink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
      <property name="toplink.jdbc.password" value="password"/>
      <property name="toplink.ddl-generation" value="create-tables"/>
    </properties>
  </persistence-unit>
</persistence>
[Message sent by forum member 'protoman2k' (protoman2k)]

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