1 Reply Latest reply on Dec 15, 2001 10:22 AM by sundaram

    Use Jboss-2.4.3 with mySql - configuration problem

    dchang

      Dear All,

      I am learning to use Jboss-2.4.3 with mysql. I did
      following things:

      1. copied the section of mySql adaptor configuration
      in the manual chapter 3 into c:\jboss-2.4.3\conf\default\jboss.jcml corresponding section,
      and edited several fields ( see attached file).

      2. downloaded and copied mysql mm driver (version 2.0,4) into c:\jboss-2.4.3\lib\ext.

      3. tested mysql which is working.

      4. Read lots of posts on this Forum, and stil
      having a problem.

      HERE IS SECTION OF MY JCML FILE:

      <!-- $Id: resource.xml,v 3.4 2001/12/01 02:17:42 d_jencks Exp $ -->


      <!-- ==================================================================== -->
      <!-- JDBC - Initialize the databases -->
      <!-- to ConnectionFactoryLoader -->
      <!-- ==================================================================== -->


      ConnectionURL=jdbc:mysql://localhost/mysql
      DriverClass=org.gjt.mm.mysql.Driver
      UserName=root
      mysqlDS
      java:/TransactionManager
      <mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
      <mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
      #
      #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=root Password=Baiqing



      AND HERE IS THE ERROR MESG AFTER I STARTED THE JBOSS
      SERVER:

      [ConnectionFactoryLoader] Initializing
      [null] Initialization failed
      javax.management.MalformedObjectNameException: ObjectName: Name cannot be null
      at javax.management.ObjectName.(ObjectName.java:90)
      at org.jboss.resource.ConnectionFactoryLoader.initService(ConnectionFactoryLoader.java:407)
      at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
      at $Proxy0.init(Unknown Source)
      at org.jboss.util.ServiceControl.init(ServiceControl.java:55)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.Main.(Main.java:220)
      at org.jboss.Main$1.run(Main.java:127)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:123)
      [Configuration] javax.management.MalformedObjectNameException: ObjectName: Name cannot be null
      [Configuration] at javax.management.ObjectName.(ObjectName.java:90)
      [Configuration] at org.jboss.resource.ConnectionFactoryLoader.initService(ConnectionFactoryLoader.java:407)
      [Configuration] at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)
      [Configuration] at java.lang.reflect.Method.invoke(Native Method)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      [Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
      [Configuration] at $Proxy0.init(Unknown Source)
      [Configuration] at org.jboss.util.ServiceControl.init(ServiceControl.java:55)
      [Configuration] at java.lang.reflect.Method.invoke(Native Method)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      [Configuration] at org.jboss.Main.(Main.java:220)
      [Configuration] at org.jboss.Main$1.run(Main.java:127)
      [Configuration] at java.security.AccessController.doPrivileged(Native Method)
      [Configuration] at org.jboss.Main.main(Main.java:123)


      I AM ON A WIN2K PLATFORM WITH JAVA 1.3.1.

      Help is greatly appreciated. Thanks.

        • 1. Re: Use Jboss-2.4.3 with mySql - configuration problem
          sundaram

          Hi,

          Use the follwoing one and Change the dbname, username and password. It will work.


          org.gjt.mm.mysql.Driver



          DefaultDS
          org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

          jdbc:mysql://localhost:3306/dbname
          name="GCMinIdleTime">1200000
          username
          passwd
          10
          false
          false
          false
          true
          120000
          1800000
          false
          false
          1.0
          0



          -Cheers
          SR