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

mysql connection problem

vineetb Feb 20, 2004 12:11 PM

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>

<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"?>




<depends optional-attribute-name="ManagedConnectionFactoryName">


<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>

<config-property name="UserName" type="java.lang.String">userXXX</config-property>
<config-property name="Password" type="java.lang.String">passXXX</config-property>



<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper

<depends optional-attribute-name="ManagedConnectionPool">


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

jboss.jca:service=RARDeployer

Can anyone please point me in the right direction?

thanks,
vineet

1. Re: mysql connection problem

vineetb Feb 21, 2004 12:04 AM (in response to vineetb)

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