2 Replies Latest reply on Jul 9, 2002 12:46 PM by kieran-damon

    Problems with MySQL Datasource

    sklimenko

      Hi all.

      I use JBoss 3.0.0RC3 and dont install any Data Source pool for this version JBoss. Using any version of mysql-service.xml from cvs repository I get next message:
      [ServiceController] jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any Service methods
      [org.jboss.system.ServiceController] jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any Service method
      s
      [JBossManagedConnectionPool] Creating
      [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Creating
      [JBossManagedConnectionPool] Created
      [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Created
      [JBossManagedConnectionPool] Starting
      [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Starting
      [JBossManagedConnectionPool] Started
      [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started
      [MainDeployer] Successfully completed deployment of package: file:/C:/Software/JBoss-3.0.0/server/default/deploy/my
      sql-service.xml
      [org.jboss.deployment.MainDeployer] Successfully completed deployment of package: file:/C:/Software/JBoss-3.0.0/ser
      ver/default/deploy/mysql-service.xml

      Content of mysql-service.xml the following:
      <?xml version="1.0" encoding="UTF-8"?>

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



      <!-- ==================================================================== -->
      <!-- New ConnectionManager setup for mysql using 2.0.11 driver -->
      <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
      <!-- ==================================================================== -->


      <!--comment out this line if you want component managed security or want
      to use the default values in the ManagedConnectionFactoryProperties -->
      MySqlDbRealm

      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->


      MySqlDS



      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://dell:3306/jbossdb</config-property>
      <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
      <config-property name="UserName" type="java.lang.String"></config-property>
      <config-property name="Password" type="java.lang.String"></config-property>




      <!--Below here are advanced properties -->
      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper




      <depends optional-attribute-name="ManagedConnectionPool">
      <!--embedded mbean-->


      0
      50
      5000
      15
      ByContainer



      <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

      <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager

      java:/TransactionManager
      <!--make the rar deploy! hack till better deployment-->
      jboss.jca:service=RARDeployer






      File login-config.xml content next lines:
      <application-policy name = "MySqlDbRealm">

      <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
      <module-option name = "principal">harduc</module-option>
      <module-option name = "userName">harduc</module-option>
      <module-option name = "password">1</module-option>
      <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
      </login-module>

      </application-policy>

      To talk, please, where errors?
      Also, I see all other resources this forum, and not fixed this error.