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>