1 Reply Latest reply on Feb 21, 2004 12:04 AM by vineet bhatia

    mysql connection problem

    vineet bhatia Newbie

      I am getting this error -

      12:48:55,896 INFO [MainDeployer] Undeploying file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:55,898 DEBUG [SARDeployer] undeploying document file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:55,900 DEBUG [SARDeployer] stopping mbean jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:55,901 DEBUG [ServiceController] stopping service: jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:55,904 DEBUG [ServiceController] stopping dependent services for: jboss.jca:service=LocalTxDS,name=MySqlDS dependent services are: [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
      state: FAILED
      I Depend On: jboss.jca:service=LocalTxDS,name=MySqlDS

      Depends On Me: org.jboss.deployment.DeploymentException: Exception setting attribute javax.management.Attribute: name=ManagedConnectionFactoryName value=jboss.jca:service=LocalTxDS,name=MySqlDS on mbean jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable: (javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found)]
      12:48:55,905 DEBUG [ServiceController] stopping service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:55,907 INFO [RARDeployment] Stopping
      12:48:55,909 INFO [RARDeployment] Stopped
      12:48:55,910 DEBUG [SARDeployer] stopping mbean jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:55,912 DEBUG [ServiceController] stopping service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:55,914 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceDeployer,type=org.jboss.deployment.SubDeployer.stop,sequenceNumber=147,timeStamp=1077299335913,message=null,userData=org.jboss.deployment.DeploymentInfo@bb4ec28d { url=file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml }
      deployer: org.jboss.deployment.SARDeployer@2929b2
      status: Deployed
      state: START_DEPLOYER
      watch: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      lastDeployed: 1077299310106
      lastModified: 1077299310000
      mbeans:
      jboss.jca:service=LocalTxCM,name=MySqlDS state: Registered
      jboss.jca:service=LocalTxDS,name=MySqlDS state: Stopped
      ]
      12:48:55,917 DEBUG [SARDeployer] destroying mbean jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:55,918 DEBUG [ServiceController] destroying service: jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:55,920 DEBUG [ServiceController] destroying dependent services for: jboss.jca:service=LocalTxDS,name=MySqlDS depenent services are: [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
      state: FAILED
      I Depend On: jboss.jca:service=LocalTxDS,name=MySqlDS

      Depends On Me: org.jboss.deployment.DeploymentException: Exception setting attribute javax.management.Attribute: name=ManagedConnectionFactoryName value=jboss.jca:service=LocalTxDS,name=MySqlDS on mbean jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable: (javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found)]
      12:48:55,922 DEBUG [ServiceController] destroying service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,072 DEBUG [ServiceController] destroying dependent services for: jboss.jca:service=LocalTxCM,name=MySqlDS depenent services are: []
      12:48:56,074 INFO [LocalTxConnectionManager] Destroying
      12:48:56,076 INFO [LocalTxConnectionManager] Destroyed
      12:48:56,078 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceController,type= org.jboss.system.ServiceMBean.destroy,sequenceNumber=139,timeStamp=1077299336078,message=null,userData=jboss.jca:service=LocalTxCM,name=MySqlDS]
      12:48:56,080 DEBUG [DefaultManagedObjectFactoryMap] Failed to find factory for event: javax.management.Notification[source=jboss.system:service=ServiceController,type= org.jboss.system.ServiceMBean.destroy,sequenceNumber=139,timeStamp=1077299336078,message=null,userData=jboss.jca:service=LocalTxCM,name=MySqlDS]
      12:48:56,081 INFO [RARDeployment] Destroying
      12:48:56,083 INFO [RARDeployment] Destroyed
      12:48:56,084 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceController,type= org.jboss.system.ServiceMBean.destroy,sequenceNumber=140,timeStamp=1077299336084,message=null,userData=jboss.jca:service=LocalTxDS,name=MySqlDS]
      12:48:56,086 DEBUG [DefaultManagedObjectFactoryMap] Failed to find factory for event: javax.management.Notification[source=jboss.system:service=ServiceController,type= org.jboss.system.ServiceMBean.destroy,sequenceNumber=140,timeStamp=1077299336084,message=null,userData=jboss.jca:service=LocalTxDS,name=MySqlDS]
      12:48:56,088 DEBUG [SARDeployer] destroying mbean jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,089 DEBUG [ServiceController] destroying service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,090 DEBUG [SARDeployer] removing mbean jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,092 DEBUG [ServiceController] removing service: jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,093 DEBUG [ServiceController] removing jboss.jca:service=LocalTxDS,name=MySqlDS from server
      12:48:56,094 DEBUG [ServiceController] Context not removed, it is recording dependencies: ObjectName: jboss.jca:service=LocalTxDS,name=MySqlDS
      state: DESTROYED
      I Depend On:
      Depends On Me: jboss.jca:service=LocalTxCM,name=MySqlDS

      12:48:56,097 DEBUG [SARDeployer] removing mbean jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,098 DEBUG [ServiceController] removing service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,099 DEBUG [ServiceController] Removing context for nonexistent service it is no longer recording dependencies: ObjectName: jboss.jca:service=LocalTxDS,name=MySqlDS
      state: NOTYETINSTALLED
      I Depend On:
      Depends On Me:
      12:48:56,101 DEBUG [ServiceController] removing jboss.jca:service=LocalTxCM,name=MySqlDS from server
      12:48:56,104 DEBUG [SARDeployer] Unregistering service UCL=jmx.loading:UCL=d9cd57
      12:48:56,108 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceDeployer,type=org.jboss.deployment.SubDeployer.destroy,sequenceNumber=148,timeStamp=1077299336106,message=null,userData=org.jboss.deployment.DeploymentInfo@bb4ec28d { url=file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml }
      deployer: org.jboss.deployment.SARDeployer@2929b2
      status: Deployed
      state: START_DEPLOYER
      watch: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      lastDeployed: 1077299310106
      lastModified: 1077299310000
      mbeans:
      jboss.jca:service=LocalTxCM,name=MySqlDS (state not available)
      jboss.jca:service=LocalTxDS,name=MySqlDS (state not available)
      ]
      12:48:56,111 DEBUG [J2EEManagedObject] removeObject(), name: jboss.jca:service=LocalTxDS,name=MySqlDS, encrypted name: jboss.jca%3aservice%3dLocalTxDS%2cname%3dMySqlDS, search criteria: jboss.management.local:j2eeType=MBean,*,name=jboss.jca%3aservice%3dLocalTxDS%2cname%3dMySqlDS
      12:48:56,121 DEBUG [MBean] preDeregister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=mysql-service.xml
      12:48:56,180 DEBUG [ServiceModuleFactory] Destroy MBean, name: jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,181 DEBUG [J2EEManagedObject] removeObject(), name: jboss.jca:service=LocalTxCM,name=MySqlDS, encrypted name: jboss.jca%3aservice%3dLocalTxCM%2cname%3dMySqlDS, search criteria: jboss.management.local:j2eeType=MBean,*,name=jboss.jca%3aservice%3dLocalTxCM%2cname%3dMySqlDS
      12:48:56,195 DEBUG [MBean] preDeregister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=mysql-service.xml
      12:48:56,196 DEBUG [ServiceModuleFactory] Destroy MBean, name: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,197 DEBUG [ServiceModule] destroy(), remove Service Module: mysql-service.xml
      12:48:56,198 DEBUG [J2EEManagedObject] removeObject(), name: mysql-service.xml, encrypted name: mysql-service.xml, search criteria: jboss.management.local:j2eeType=ServiceModule,*,name=mysql-service.xml
      12:48:56,200 DEBUG [ServiceModule] preDeregister(), parent: jboss.management.local:j2eeType=J2EEServer,name=Local
      12:48:56,201 DEBUG [ServiceModuleFactory] Removed JSR-77 SAR: mysql-service.xml
      12:48:56,201 DEBUG [UnifiedLoaderRepository3] UnifiedLoaderRepository removed(true) org.jboss.mx.loading.UnifiedClassLoader3@d9cd57{ url=file:/Library/JBoss/3.2/server/default/tmp/deploy/tmp32032mysql-service.xml ,addedOrder=50}
      12:48:56,203 INFO [DeploymentInfo] Cleaned Deployment: file:/Library/JBoss/3.2/server/default/tmp/deploy/tmp32032mysql-service.xml
      12:48:56,204 INFO [MainDeployer] Undeployed file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,206 INFO [MainDeployer] Starting deployment of package: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,206 DEBUG [MainDeployer] Starting deployment (init step) of package at: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,223 DEBUG [MainDeployer] using deployer org.jboss.deployment.SARDeployer@2929b2
      12:48:56,349 DEBUG [SARDeployer] about to copy 0 local directories
      12:48:56,351 DEBUG [SARDeployer] looking for nested deployments in : file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,351 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceDeployer,type=org.jboss.deployment.SubDeployer.init,sequenceNumber=149,timeStamp=1077299336351,message=null,userData=org.jboss.deployment.DeploymentInfo@bb4ec28d { url=file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml }
      deployer: org.jboss.deployment.SARDeployer@2929b2
      status: null
      state: INIT_DEPLOYER
      watch: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      lastDeployed: 0
      lastModified: 0
      mbeans:
      ]
      12:48:56,353 DEBUG [DeploymentInfo] createLoaderRepository from config: LoaderRepositoryConfig(repositoryName: JMImplementation:service=LoaderRepository,name=Default, repositoryClassName: null, configParserClassName: null, repositoryConfig: null)
      12:48:56,353 DEBUG [UnifiedClassLoader] New jmx UCL with url file:/Library/JBoss/3.2/server/default/tmp/deploy/tmp32033mysql-service.xml
      12:48:56,354 DEBUG [UnifiedLoaderRepository3] Adding org.jboss.mx.loading.UnifiedClassLoader3@d8041a{ url=file:/Library/JBoss/3.2/server/default/tmp/deploy/tmp32033mysql-service.xml ,addedOrder=0}
      12:48:56,357 DEBUG [MainDeployer] found 0 subpackages of file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,357 DEBUG [MainDeployer] Watching new file: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,358 DEBUG [MainDeployer] create step for deployment file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,359 DEBUG [SARDeployer] Deploying SAR, create step: url file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,359 DEBUG [SARDeployer] Registering service UCL=jmx.loading:UCL=d8041a
      12:48:56,364 DEBUG [ServiceCreator] About to create bean: jboss.jca:service=LocalTxCM,name=MySqlDS with code: org.jboss.resource.connectionmanager.LocalTxConnectionManager
      12:48:56,435 DEBUG [ServiceCreator] Created bean: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,438 DEBUG [ServiceCreator] About to create bean: jboss.jca:service=LocalTxDS,name=MySqlDS with code: org.jboss.resource.connectionmanager.RARDeployment
      12:48:56,487 DEBUG [ServiceCreator] Created bean: jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,493 DEBUG [ServiceConfigurator] ManagedConnectionFactoryProperties set to
      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/test</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property>
      <!--set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String">root</config-property>
      <config-property name="Password" type="java.lang.String">rikku</config-property>
      in jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,494 DEBUG [ServiceController] recording that jboss.jca:service=LocalTxDS,name=MySqlDS depends on jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
      12:48:56,495 DEBUG [ServiceConfigurator] considering OldRarDeployment with object name jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
      12:48:56,496 DEBUG [ServiceController] recording that jboss.jca:service=LocalTxCM,name=MySqlDS depends on jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,496 DEBUG [ServiceConfigurator] considering ManagedConnectionFactoryName with object name jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,498 INFO [ServiceConfigurator] Problem configuring service jboss.jca:service=LocalTxCM,name=MySqlDS
      org.jboss.deployment.DeploymentException: Exception setting attribute javax.management.Attribute: name=ManagedConnectionFactoryName value=jboss.jca:service=LocalTxDS,name=MySqlDS on mbean jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable: (javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found)
      at org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:478)
      at org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.java:363)
      at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:176)
      at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:118)
      at org.jboss.system.ServiceController.install(ServiceController.java:225)
      at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
      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:550)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy5.install(Unknown Source)
      at org.jboss.deployment.SARDeployer.create(SARDeployer.java:183)
      at org.jboss.deployment.MainDeployer.create(MainDeployer.java:776)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:631)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
      at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
      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:550)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy7.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:458)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:200)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:211)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:190)
      Caused by: javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.setAttribute(ReflectedMBeanDispatcher.java:190)
      at org.jboss.mx.server.MBeanServerImpl.setAttribute(MBeanServerImpl.java:504)
      at org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:474)
      ... 27 more
      12:48:56,504 DEBUG [ServiceController] Creating service jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,505 DEBUG [ServiceController] Ignoring create request for service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,506 DEBUG [ServiceController] Creating service jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,507 INFO [RARDeployment] Creating
      12:48:56,507 INFO [RARDeployment] Created
      12:48:56,508 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceController,type= org.jboss.system.ServiceMBean.create,sequenceNumber=141,timeStamp=1077299336508,message=null,userData=jboss.jca:service=LocalTxDS,name=MySqlDS]
      12:48:56,509 DEBUG [DefaultManagedObjectFactoryMap] Failed to find factory for event: javax.management.Notification[source=jboss.system:service=ServiceController,type= org.jboss.system.ServiceMBean.create,sequenceNumber=141,timeStamp=1077299336508,message=null,userData=jboss.jca:service=LocalTxDS,name=MySqlDS]
      12:48:56,509 DEBUG [ServiceController] Creating dependent components for: jboss.jca:service=LocalTxDS,name=MySqlDS dependents are: [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
      state: FAILED
      I Depend On: jboss.jca:service=LocalTxDS,name=MySqlDS

      Depends On Me: org.jboss.deployment.DeploymentException: Exception setting attribute javax.management.Attribute: name=ManagedConnectionFactoryName value=jboss.jca:service=LocalTxDS,name=MySqlDS on mbean jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable: (javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found)]
      12:48:56,510 DEBUG [ServiceController] Creating service jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,569 DEBUG [ServiceController] Ignoring create request for service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,571 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceDeployer,type=org.jboss.deployment.SubDeployer.create,sequenceNumber=150,timeStamp=1077299336570,message=null,userData=org.jboss.deployment.DeploymentInfo@bb4ec28d { url=file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml }
      deployer: org.jboss.deployment.SARDeployer@2929b2
      status: null
      state: CREATE_DEPLOYER
      watch: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      lastDeployed: 1077299336357
      lastModified: 1077299336000
      mbeans:
      jboss.jca:service=LocalTxCM,name=MySqlDS state: Registered
      jboss.jca:service=LocalTxDS,name=MySqlDS state: Created
      ]
      12:48:56,571 DEBUG [MainDeployer] Done with create step of deploying mysql-service.xml
      12:48:56,572 DEBUG [MainDeployer] Begin deployment start file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,576 DEBUG [SARDeployer] Deploying SAR, start step: url file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,576 DEBUG [ServiceController] starting service jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,577 DEBUG [ServiceController] Ignoring start request for service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,577 DEBUG [ServiceController] starting service jboss.jca:service=LocalTxDS,name=MySqlDS
      12:48:56,578 INFO [RARDeployment] Starting
      12:48:56,579 DEBUG [RARDeployment] Not setting config property 'DriverClass'
      12:48:56,580 DEBUG [RARDeployment] Not setting config property 'ConnectionURL'
      12:48:56,580 DEBUG [RARDeployment] Not setting config property 'TransactionIsolation'
      12:48:56,581 DEBUG [RARDeployment] Not setting config property 'UserName'
      12:48:56,581 DEBUG [RARDeployment] Not setting config property 'Password'
      12:48:56,581 DEBUG [RARDeployment] Not setting config property 'ConnectionProperties'
      12:48:56,582 DEBUG [RARDeployment] Not setting config property 'NewConnectionSQL'
      12:48:56,582 DEBUG [RARDeployment] Not setting config property 'CheckValidConnectionSQL'
      12:48:56,583 DEBUG [RARDeployment] Not setting config property 'ExceptionSorterClassName'
      12:48:56,599 DEBUG [RARDeployment] setting property: ConnectionURL to value jdbc:mysql://localhost:3306/test
      12:48:56,600 DEBUG [RARDeployment] set property ConnectionURL to value jdbc:mysql://localhost:3306/test
      12:48:56,607 DEBUG [RARDeployment] setting property: DriverClass to value com.mysql.jdbc.Driver
      12:48:56,608 DEBUG [RARDeployment] set property DriverClass to value com.mysql.jdbc.Driver
      12:48:56,619 DEBUG [RARDeployment] setting property: UserName to value root
      12:48:56,620 DEBUG [RARDeployment] set property UserName to value root
      12:48:56,662 DEBUG [RARDeployment] setting property: Password to value rikku
      12:48:56,663 DEBUG [RARDeployment] set property Password to value rikku
      12:48:56,664 INFO [RARDeployment] Started
      12:48:56,665 DEBUG [ServiceController] Starting dependent components for: jboss.jca:service=LocalTxDS,name=MySqlDS dependent components: [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
      state: FAILED
      I Depend On: jboss.jca:service=LocalTxDS,name=MySqlDS

      Depends On Me: org.jboss.deployment.DeploymentException: Exception setting attribute javax.management.Attribute: name=ManagedConnectionFactoryName value=jboss.jca:service=LocalTxDS,name=MySqlDS on mbean jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable: (javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found)]
      12:48:56,665 DEBUG [ServiceController] starting service jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,666 DEBUG [ServiceController] Ignoring start request for service: jboss.jca:service=LocalTxCM,name=MySqlDS
      12:48:56,667 DEBUG [LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceDeployer,type=org.jboss.deployment.SubDeployer.start,sequenceNumber=151,timeStamp=1077299336666,message=null,userData=org.jboss.deployment.DeploymentInfo@bb4ec28d { url=file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml }
      deployer: org.jboss.deployment.SARDeployer@2929b2
      status: Starting
      state: START_DEPLOYER
      watch: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      lastDeployed: 1077299336357
      lastModified: 1077299336000
      mbeans:
      jboss.jca:service=LocalTxCM,name=MySqlDS state: Registered
      jboss.jca:service=LocalTxDS,name=MySqlDS state: Started
      ]
      12:48:56,793 DEBUG [ServiceModule] postRegister(), parent: jboss.management.local:j2eeType=J2EEServer,name=Local
      12:48:56,794 DEBUG [ServiceModule] Created JSR-77 ServiceModule, name: mysql-service.xml
      12:48:56,795 DEBUG [ServiceModuleFactory] Created ServiceModule: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=mysql-service.xml
      12:48:56,800 DEBUG [MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=mysql-service.xml
      12:48:56,802 DEBUG [ServiceModuleFactory] Create MBean, name: jboss.jca:service=LocalTxCM,name=MySqlDS, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=mysql-service.xml
      12:48:56,865 DEBUG [MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=mysql-service.xml
      12:48:56,867 DEBUG [ServiceModuleFactory] Create MBean, name: jboss.jca:service=LocalTxDS,name=MySqlDS, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=mysql-service.xml
      12:48:56,868 DEBUG [MainDeployer] End deployment start on package: mysql-service.xml
      12:48:56,868 INFO [MainDeployer] Deployed package: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      12:48:56,873 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:

      Incompletely deployed packages:
      [org.jboss.deployment.DeploymentInfo@bb4ec28d { url=file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml }
      deployer: org.jboss.deployment.SARDeployer@2929b2
      status: null
      state: FAILED
      watch: file:/Library/JBoss/3.2/server/default/deploy/mysql-service.xml
      lastDeployed: 1077298701937
      lastModified: 1077298701000
      mbeans:
      ]MBeans waiting for classes:

      MBeans waiting for other MBeans:
      [ObjectName: jboss.jca:service=LocalTxCM,name=test
      state: CONFIGURED
      I Depend On: jboss.jca:service=ManagedConnectionPool,name=test
      jboss.jca:service=CachedConnectionManager
      jboss.security:service=JaasSecurityManager
      jboss:service=TransactionManager

      Depends On Me: , ObjectName: jboss.jca:service=ManagedConnectionPool,name=test
      state: CONFIGURED
      I Depend On: jboss.jca:service=ManagedConnectionFactory,name=test

      Depends On Me: jboss.jca:service=LocalTxCM,name=test
      , ObjectName: jboss.jca:service=ManagedConnectionFactory,name=test
      state: CONFIGURED
      I Depend On: jboss:service=MySQL
      jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper

      Depends On Me: jboss.jca:service=ManagedConnectionPool,name=test
      , ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
      state: FAILED
      I Depend On: jboss.jca:service=LocalTxDS,name=MySqlDS

      Depends On Me: org.jboss.deployment.DeploymentException: Exception setting attribute javax.management.Attribute: name=ManagedConnectionFactoryName value=jboss.jca:service=LocalTxDS,name=MySqlDS on mbean jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable: (javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found)]

      Here is mysql-service.xml file -

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




      <!-- Include a login module configuration named MySqlDbRealm.
      Update your login-conf.xml, here is an example for a
      ConfiguredIdentityLoginModule:

      <application-policy name = "MySqlDbRealm">

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

      </application-policy>

      NOTE: the application-policy name attribute must match SecurityDomainJndiName, and the
      module-option name = "managedConnectionFactoryName"
      must match the object name of the ConnectionManager you are configuring here.
      -->
      <!--uncomment out this line if you are using the MySqlDbRealm above
      MySqlDbRealm
      -->

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



      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/test</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property>
      <!--set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String">userXXX</config-property>
      <config-property name="Password" type="java.lang.String">passXXX</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:service=JaasSecurityManager

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



      Can anyone please point me in the right direction?

      thanks,
      vineet

        • 1. Re: mysql connection problem
          vineet bhatia Newbie

          I forgot to add the defaults section in jbosscmp-jdbc.xml

          <defaults>
           <datasource>test</datasource>
           <datasource-mapping>mySQL</datasource-mapping>
           </defaults>
          


          After adding this the above exception and Table not found exception went away.

          Now I am getting this error when the finder in my session bean is executed -

           java.lang.NullPointerException
           at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:361)
           at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:124)
           at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
           at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:478)
           at org.jboss.ejb.Container.invoke(Container.java:720)
           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:550)
           at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
           at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
           at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
           at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
           at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
           at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
           at $Proxy45.findByPrimaryKey(Unknown Source)
           at com.vb.profile.LoginSessionBean.verifyPassword(LoginSessionBean.java:57)
           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.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:646)
           at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
           at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
           at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
           at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:216)
           at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
           at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
           at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
           at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
           at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:323)
           at org.jboss.ejb.Container.invoke(Container.java:700)
           at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:353)
           at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
           at $Proxy44.verifyPassword(Unknown Source)
           at com.vb.web.profile.action.LoginAction.execute(LoginAction.java:56)
           at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:480)
           at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
           at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420)
           at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:520)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
           at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.jboss.web.catalina.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:229)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.jboss.web.catalina.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:75)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
           at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
           at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
           at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
           at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
           at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
           at java.lang.Thread.run(Thread.java:552)
          Caused by: java.lang.NullPointerException
           at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createBeanClassInstance(JDBCStoreManager.java:555)
           at org.jboss.ejb.plugins.CMPPersistenceManager.createBeanClassInstance(CMPPersistenceManager.java:127)
           at org.jboss.ejb.EntityContainer.createBeanClassInstance(EntityContainer.java:227)
           at org.jboss.ejb.plugins.AbstractInstancePool.get(AbstractInstancePool.java:146)
           at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:79)
           at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
           at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
           at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
           at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)
           at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
           at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
           at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
           ... 79 more
          


          Help!!

          - vineet