1 Reply Latest reply on Oct 8, 2003 7:31 PM by dumber168

    MySQL / Eclipse / Jboss - Help??

    sian_baldwin Newbie

      Hi Everyone...

      I am new to developing beans. I am building an application for a client that will be eventually deployed on a unix box running mySQL, Tomcat and JBoss.

      To go about developing the app, I am setting up a dev env on my windows PC. I have downloaded eclipse (as i am told it is a good time saving way of bean development) & jboss-3.2.1_tomcat-4.1.24. I also have a mySQL database on a remote unix server.

      Basically, I have devloped some beans which connect to the Hypersonic database and now I am trying to get this test code to connect to my remote mySQL database.

      I have done the following so far:

      1. updated the mysql-ds.xml file and put it into the deploy directory of jboss.

      2. updated all the xdoclet tags in my eclipse/bean code to use the new datasource.

      3. Updated the tag in the ejbGenerate.xml eclipse config file to point to the new datasource.

      However...i think i need a mySQL driver from somewhere to put in the .jar library path?? Any idea where i get this from? I am specifiying the driver as org.gjt.mm.mysql.Driver in the config files??

      I am getting lots of errors when i start the jboss server. I am hoping that the ones that dont seem to be directly related to the new mySQL datasource actually are, and will go away when the datasource problem is fixed (they wern't there before!).

      Main error seems to be with the driver:

      13:46:07,208 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=ItemBean,service=EJB
      org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Failed to register driver for: org.gjt.mm.mysql.Driver; - nested throwable: (java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver); - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: org.gjt.mm.mysql.Driver; - nested throwable: (java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver)))
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:68)
      ...
      ...
      Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

      Please help if you can...I have spent days on this and i am now almost bald!!!

      Thanks
      Sian