3 Replies Latest reply on Apr 8, 2002 3:33 PM by Axel Muench

    mysql-service.xml deploy error

    Axel Muench Newbie

      Hi,
      I'm trying to deploy on JBoss3-b3 the mysql-service.xml file including the .
      I sort of remember that this extra line might not be necessary anymore in the current beta versions. The reason for experimenting with this extra line is that I'm trying to test my mySQL database setup by executing a test class (command line ->main) which is deployed and jared up with some other beans, which throws a class not found exception when loading the my sql driver class:

      ClassNotFoundException: org.gjt.mm.mysql.Driver
      Message: No suitable driver
      SQLState: 08001
      ErrorCode: 0

      Anyone has an idea?
      Thanks.

      mysql-service.xml deploy error:

      2002-04-08 11:15:51,263 INFO [org.jboss.deployment.MainDeployer] Deploying: file:/usr/local/jboss-3.0.0beta/deploy/mysql-service.xml
      2002-04-08 11:15:51,274 ERROR [org.jboss.deployment.SARDeployer] operation failed
      org.jboss.deployment.DeploymentException: url file:/usr/local/jboss-3.0.0beta/deploy/mm.mysql-2.0.11-bin.jar could not be opened, does it exist?
      at org.jboss.deployment.DeploymentInfo.(DeploymentInfo.java:148)
      at org.jboss.deployment.SARDeployer.parseXMLClasspath(SARDeployer.java:475)
      at org.jboss.deployment.SARDeployer.init(SARDeployer.java:174)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:449)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:413)
      at org.jboss.deployment.MainDeployer.scan(MainDeployer.java:272)
      at org.jboss.deployment.MainDeployer.run(MainDeployer.java:259)
      at java.lang.Thread.run(Thread.java:484)


      ### mysql-service.xml ###
      <?xml version="1.0" encoding="UTF-8"?>






      ConnectionURL=jdbc:mysql://localhost:3306/myDatabase
      DriverClass=org.gjt.mm.mysql.Driver
      UserName=myUsername

      testmyDatabase
      java:/TransactionManager
      <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
      <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
      #
      #Wed Aug 15 16:17:29 EDT 2001
      BlockingTimeoutMillis=500000
      IdleTimeoutMinutes=30
      MaxSize=10
      CleanupIntervalMinutes=10
      MinSize=0
      MaxIdleTimeoutPercent=1.0


      org.jboss.resource.security.ManyToOnePrincipalMapping

      UserName=myUsername Password=myPassword