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>


View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3914295#3914295

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3914295


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to