0 Replies Latest reply on Dec 26, 2005 12:02 AM by fire-fly

    EJB3 Trailblazer with MySQL ( ERROR [org.hibernate.tool.hbm

    fire-fly Newbie

      Hi
      I tried changing the database to Mysql. I keeping the error,
      ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadata
      java.sql.SQLException: Table 'information_schema.system_sequences' doesn't exist at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
      at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)

      Please help.

      I am using mysql-connector-java-3.1.12-bin.jar, on Fedora4 machine. jvm version "1.5.0_06"

      My /mysql-ds.xml :-
      <?xml version="1.0" encoding="UTF-8"?>

      <!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf Exp $ --><!-- Datasource config for MySQL using 3.0.9 available from:
      http://www.mysql.com/downloads/api-jdbc-stable.html
      -->


      <local-tx-datasource>
      <jndi-name>MySqlDS</jndi-name>
      <connection-url>jdbc:mysql://antims.com:3306/cokadb</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>coka</user-name>
      123123
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>


      <type-mapping>mySQL</type-mapping>

      </local-tx-datasource>


      My persistance.xml:-
      <?xml version="1.0" encoding="UTF-8"?>

      <entity-manager>

      cal
      <!-- Below is define jboss.home/server/default/deploy/mysql-ds.xml -->
      <jta-data-source>java:/MySqlDS</jta-data-source>



      </entity-manager>