2 Replies Latest reply on May 9, 2003 2:06 PM by shelly

    unable to deploy mysql datasource in jboss

    shelly Newbie

      hi,

      I'm trying to configure mysql4.0.12 in jboss-3.2.1_tomcat-4.1.24.

      I created a mysql-service.xml and put it in jboss-dist/server/default/deploy and put mysql-connector-java-3.0.7-stable-bin.jar in jboss-dist/lib.

      mysql-service.xml looks like this:

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




      ConnectionURL=jdbc:mysql://localhost:3306/test DriverClass=org.gjt.mm.mysql.Driver UserName=shelly Password=nebula
      mySqlDS
      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
      BlockingTimeoutMillis=500000 IdleTimeoutMinutes=30 MaxSize=10 CleanupIntervalMinutes=10 MinSize=0 MaxIdleTimeoutPercent=1.0
      org.jboss.resource.security.ManyToOnePrincipalMapping
      UserName=




      i get the following errors while deployment:

      org.jboss.deployment.DeploymentException: create operation failed for package file:/C:/jboss-3.2.1_tomcat-4.1.24/server/default/deploy/mysql-service.xml; - nested throwable: (javax.management.InstanceNotFoundException: jboss.jca:service=ConnectionFactoryLoader,name=mySqlDS is not registered.)


      Does somebody know what else needs to be done.


        • 1. Re: unable to deploy mysql datasource in jboss
          Jon Barnett Master

          This doesn't look right. From 3.2.0 the connection pool configurations are much simpler. Have a look in docs/examples/jca and grab the *-ds.xml template of your choice and put it in your deploy directory. Modify the parameters to suit your needs and then start JBoss. Note that they are no longer service configuration files but ds configuration files. ;)

          The raw template, unless they've back-tracked, should look like this:
          <?xml version="1.0" encoding="UTF-8"?>

          <!-- ===================================================================== -->
          <!-- -->
          <!-- JBoss Server Configuration -->
          <!-- -->
          <!-- ===================================================================== -->

          <!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
          <!-- ==================================================================== -->
          <!-- Datasource config for MySQL using 2.0.11 driver -->
          <!-- ==================================================================== -->



          <local-tx-datasource>
          <jndi-name>MySqlDS</jndi-name>
          <connection-url>jdbc:mysql://dell:3306/jbossdb</connection-url>
          <driver-class>org.gjt.mm.mysql.Driver</driver-class>
          <user-name>x</user-name>
          y
          </local-tx-datasource>