2 Replies Latest reply on May 23, 2003 3:20 PM by junkmail

    mysql creating table

      i try to configure jboss to work with mySQL database.
      i put mysql-services.xml and change standardjaws.xml to put mySQL type mapping.
      i think its ok because when jboss startup shows:

      13:46:31,514 INFO [LocalTxConnectionManager] Creating
      13:46:31,514 INFO [LocalTxConnectionManager] Created
      13:46:31,545 INFO [LocalTxConnectionManager] Starting
      13:46:31,592 INFO [DefaultDS] Bound connection factory for resource adapter 'JB
      oss LocalTransaction JDBC Wrapper' to JNDI name 'java:/DefaultDS'
      13:46:31,608 INFO [LocalTxConnectionManager] Started
      13:46:31,608 INFO [LocalTxConnectionManager] Starting
      13:46:31,608 INFO [MySqlDS] Bound connection factory for resource adapter 'JBos
      s LocalTransaction JDBC Wrapper' to JNDI name 'java:/MySqlDS'
      13:46:31,608 INFO [LocalTxConnectionManager] Started

      and next shows:

      13:46:34,264 INFO [test/TestEntity] Created table 'TESTENTITY' successfully.

      but i go to MySQL server and there is no table. i have to do anything else?
      what are DefaultDS and hipersonic SQL?

      thanks,

      Pedro Cardoso

        • 1. Re: mysql creating table
          junkmail

          The DefaultDS is default DataSource. Which is a Hypersonic DB. Jboss uses it for JMS persistence. But it's also the default db for CMP. You have to go to the /conf directory and change the standardjbosscmp-jdbc.xml file to use your newly configure MySqlDS instead of the DefaultDS to get jboss looking at the DS you want. Don't forget to change the type-mapping too.

          • 2. Re: mysql creating table
            junkmail

            The DefaultDS is default DataSource. Which is a Hypersonic DB. Jboss uses it for JMS persistence. But it's also the default db for CMP. You have to go to the /conf directory and change the standardjbosscmp-jdbc.xml file to use your newly configure MySqlDS instead of the DefaultDS to get jboss looking at the DS you want. Don't forget to change the type-mapping too.