3 Replies Latest reply on Apr 10, 2003 2:41 PM by amalp

    jmx, MySqlDS

    amalp Newbie

      Hello,

      I have jboss-3.0.0-tomcat-4.0.3

      I am having lot of problem to connect to Mysql database.

      I it always says MySqlDS not bound and then I looked at http://localhost:8082

      Here is what i see in the jmx.

      Under

      jboss:jca

      service=CachedConnectionManager
      service=LocalTxCM,name=MySqlDS
      service=LocalTxCM,name=hsqldbDS
      service=LocalTxDS,name=MySqlDS
      service=LocalTxDS,name=hsqldbDS
      service=LocalTxPool,name=MySqlDS
      service=LocalTxPool,name=hsqldbDS
      service=RARDeployer
      service=XaTxCM,name=jmsra
      service=XaTxDS,name=jmsra
      service=XaTxPool,name=jmsra


      When I click service=LocalTxCM,name=MySqlDS, it shows

      name --- Instance

      type ---org.jboss.resource.connectionmanager.BaseConnectionManager2

      access -- RO

      Value -- Type Not Supported: []

      Can someone explain to me what is this all about. So I have understadning what is missing

      Here is another one

      When I click service=LocalTxDS,name=MySqlDS

      I see this

      Name -- ManagedConnectionFactoryProperties

      Type -- org.w3c.dom.Element

      Access -- RW

      Value --

      Type Not Supported: [ <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> <!--set these only if you want only default logins, not through JAAS --> <config-property name="UserName" type="java.lang.String" /> <config-property name="Password" type="java.lang.String" /> ]


      Please tell me what is wrong with my connection to mysql.

      Under

      Jboss

      service=ClientUserTransaction
      service=Counter
      service=Hypersonic
      service=JNDIView
      service=Mail
      service=Naming
      service=TransactionManager
      service=Webserver
      service=invoker,type=jrmp
      service=invoker,type=local
      type=Service,name=PropertyEditorManager
      type=Service,name=SystemProperties


      Should I see MySqlDS under service=JNDIView (I do not see any referenc to MySqlDS there)

      Please help

      I been trying this about 2 weeks.

      thanks
      ap





        • 1. Re: jmx, MySqlDS
          David Jencks Master

          1. upgrade to a not-completely-obsolete jboss version such as 3.0.7 or 3.2 latest.

          2. Use the example config file that comes with the newer jboss version as a starting point. The *-ds.xml files for 3.2 are much simpler than the configs for 3.0.x

          3. If there are problems, look in jndiview: you should see something like java:/MySQLDS

          4. Look in server.log for the section where the datasource is getting deployed (search for the filename). Look carefully for any problems. If you can't figure out what the problem is, post this section of your log.

          • 2. Re: jmx, MySqlDS
            amalp Newbie

            Hello David,

            I installed jboss-3.0.7_jakarta-tomcat-4.1.24. After that I started the server but I got follwoing errors.

            1. 2003-04-10 10:36:10,673 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Failed to deploy: org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@e922bf39{ url=file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jboss-local-jdbc.rar, deployedLastModified=0 }

            2. 2003-04-10 10:36:10,873 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Failed to deploy: org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@8dce2723{ url=file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jboss-xa-jdbc.rar, deployedLastModified=0 }

            3. 2003-04-10 10:36:11,123 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Failed to deploy: org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@5cf4def2{ url=file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jms-ra.rar, deployedLastModified=0 }

            4. 2003-04-10 10:36:13,457 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
            Cause: Incomplete Deployment listing:
            Packages waiting for a deployer:

            Incompletely deployed packages:
            [org.jboss.deployment.DeploymentInfo@e922bf39 { url=file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jboss-local-jdbc.rar }
            deployer: org.jboss.resource.RARDeployer@86
            status: null
            state: FAILED
            watch: file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jboss-local-jdbc.rar
            lastDeployed: 1049996170663
            lastModified: 1049996170612
            mbeans:
            , org.jboss.deployment.DeploymentInfo@8dce2723 { url=file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jboss-xa-jdbc.rar }
            deployer: org.jboss.resource.RARDeployer@86
            status: null
            state: FAILED
            watch: file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jboss-xa-jdbc.rar
            lastDeployed: 1049996170873
            lastModified: 1049996170853
            mbeans:
            , org.jboss.deployment.DeploymentInfo@5cf4def2 { url=file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jms-ra.rar }
            deployer: org.jboss.resource.RARDeployer@86
            status: null
            state: FAILED
            watch: file:/C:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/jms-ra.rar
            lastDeployed: 1049996171123
            lastModified: 1049996171053
            mbeans:
            ]MBeans waiting for classes:

            MBeans waiting for other MBeans:
            [ObjectName: jboss.jca:service=LocalTxCM,name=hsqldbDS
            state: CONFIGURED
            I Depend On: jboss.jca:service=LocalTxDS,name=hsqldbDS
            jboss.jca:service=LocalTxPool,name=hsqldbDS
            jboss.jca:service=CachedConnectionManager
            jboss.security:service=JaasSecurityManager
            jboss.jca:service=RARDeployer

            Depends On Me: , ObjectName: jboss.jca:service=LocalTxDS,name=hsqldbDS
            state: CONFIGURED
            I Depend On: jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
            jboss:service=Hypersonic

            Depends On Me: jboss.jca:service=LocalTxCM,name=hsqldbDS
            , ObjectName: jboss.jca:service=XaTxCM,name=jmsra
            state: CONFIGURED
            I Depend On: jboss.jca:service=RARDeployer
            jboss.jca:service=XaTxDS,name=jmsra
            jboss.jca:service=XaTxPool,name=jmsra
            jboss.jca:service=CachedConnectionManager
            jboss.security:service=JaasSecurityManager

            Depends On Me: , ObjectName: jboss.jca:service=XaTxDS,name=jmsra
            state: CONFIGURED
            I Depend On: jboss.jca:service=RARDeployment,name=JMS Adapter

            Depends On Me: jboss.jca:service=XaTxCM,name=jmsra
            ]


            I am not sure what is happing. like always it says MySqlDs not bound.

            Ap

            • 3. Re: jmx, MySqlDS
              amalp Newbie

              David,

              I installed jboss-3.2.0RC1_tomcat-4.1.18 but I could not start the jboss. Here is the error


              2003-04-10 11:29:32,058 DEBUG [org.jboss.logging.Log4jService] Installed System.out adapter
              2003-04-10 11:29:32,068 DEBUG [org.jboss.logging.Log4jService] Installed System.err adapter
              2003-04-10 11:29:32,078 DEBUG [org.jboss.logging.Log4jService] Added ThrowableListener: org.jboss.logging.Log4jService$ThrowableListenerLoggingAdapter@53
              2003-04-10 11:29:32,078 INFO [org.jboss.logging.Log4jService] Created
              2003-04-10 11:29:32,078 DEBUG [org.jboss.system.ServiceController] Creating dependent components for: jboss.system:type=Log4jService,service=Logging dependents are: []
              2003-04-10 11:29:32,078 DEBUG [org.jboss.system.ServiceController] Creating service jboss.rmi:type=RMIClassLoader
              2003-04-10 11:29:32,088 DEBUG [org.jboss.util.property.jmx.SystemPropertyClassValue] Error loading class org.jboss.system.JBossRMIClassLoader property java.rmi.server.RMIClassLoaderSpi not set.
              java.lang.ClassNotFoundException: No ClassLoaders found for: org.jboss.system.JBossRMIClassLoader
              at org.jboss.mx.loading.LoadMgr.beginLoadTask(LoadMgr.java:155)
              at org.jboss.mx.loading.UnifiedClassLoader3.loadClass(UnifiedClassLoader3.java:161)
              at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
              at org.jboss.util.property.jmx.SystemPropertyClassValue.setSystemPropertyClassValue(SystemPropertyClassValue.java:118)
              at org.jboss.util.property.jmx.SystemPropertyClassValue.create(SystemPropertyClassValue.java:94)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:957)
              at $Proxy0.create(Unknown Source)


              Thanks
              AP