3 Replies Latest reply on Jun 23, 2006 5:40 PM by bluetrade

    MySQL Errors

    bluetrade

      Hi,
      I am currently running JBoss 4.0.4 GA (installed with EJB 3.0 Profile), and JBoss Seam 1.0.1 GA, with MySQL 4.1.20 (tried also 5.1). I wanted to exchange the default HQSQL database for a MySQL, and removed the hqsqldb-jdbc2-service file, put the mysql-jdbc-service file in place (like the article about jboss & mysql suggests) but am still getting errors when deploying the examples. The registration example doesn't let me save anything:

      javax.servlet.ServletException: Error calling action method of component with id _id0:_id6
      ...

      javax.faces.FacesException: Error calling action method of component with id _id2:_id14
      org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74)
      ...


      and neither does the booking and the blog doesn't work at all. I discovered in the deploy/jms folder another hqsql file (hsqldb-jdbc-state-service.xml) which may cause some troubles, since I removed the hsqldb-ds.xml...
      Is there a jdbc-state-service specifically for mysql? What else could cause the errors?

      Any ideas?

      Thanks a lot!!!!

      flo

        • 1. Re: MySQL Errors
          jboss098

          I changed the datasource from hsql to oracle .. please see the below config files i have to change and make sure you have the classes12.jar in the classpath.


          -----------jboss-beans.xml---------------------


          oracle.jdbc.driver.OracleDriver
          jdbc:oracle:thin:@localhost:1521:db0353
          scott
          tiger
          java:/issuesDatasource
          0
          10
          1000
          100000






          ------------issues-ds.xml-----------------

          <?xml version="1.0" encoding="UTF-8"?>


          <local-tx-datasource>
          <jndi-name>issuesDatasource</jndi-name>
          <connection-url>jdbc:oracle:thin:@localhost:1521:db0353</connection-url>
          <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
          <user-name>scott</user-name>
          tiger
          </local-tx-datasource>


          thanks,

          • 2. Re: MySQL Errors
            jboss098

            snippet of that jboss-beans.xml


            oracle.jdbc.driver.OracleDriver
            jdbc:oracle:thin:@localhost:1521:db0353
            scott
            tiger
            java:/issuesDatasource
            0
            10
            1000
            100000




            • 3. Re: MySQL Errors
              bluetrade

              Argh... somebody had the same errors. Sorry, I saw it too late. The answer is of course:

              http://www.jboss.com/index.html?module=bb&op=viewtopic&t=84871

              Adios,
              Flo