Connection pool in 3.0 alpha

[pldougless]

I'm attempting to create a mySQL connection pool in the 3.0 alpha server. It is apparent that 3.0 does not work the same as 2.2.2. I copied the mm.mysql-2.0.4-bin.jar file to the %JBOSS_CLASSPATH%\lib\ext directory, then I created a mysql-service.xml file as follows...
------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>



ConnectionURL=jdbc:mysql://localhost/Engtools DriverClass=org.gjt.mm.mysql.Driver UserName=
adminPool
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.ManyToOnePrincipleMapping
UserName=


-------------------------------------------------------

The xml file is copied to the %JBOSS_CLASSPATH%\deploy directory, and the server is started. When the server tries to deploy the connection pool the following error occurs...


[08:50:04,689,AutoDeployer] Auto deploy of file:/C:/jboss-3.0.0alpha/deploy/mysql-service.xml
[08:50:04,739,ServiceCreator] About to create the beanDefaultDomain:service=ConnectionFactoryLoader,name=adminPool
[08:50:04,840,ServiceController] Could not create MBean: DefaultDomain:service=ConnectionFactoryLoader,name=adminPool
javax.management.ReflectionException: The MBean class could not be loaded by the specified loader
at com.sun.management.jmx.MBeanServerImpl.createMBean(MBeanServerImpl.java:754)
at org.jboss.system.ServiceCreator.create(ServiceCreator.java:85)
at org.jboss.system.ServiceController.deploy(ServiceController.java:178)
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.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
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.deployment.AutoDeployer.deploy(AutoDeployer.java:654)
at org.jboss.deployment.AutoDeployer.run(AutoDeployer.java:327)
at org.jboss.deployment.AutoDeployer.startService(AutoDeployer.java:509)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:117)
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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:775)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:479)
at org.jboss.system.ServiceController.registerAndStartService(ServiceController.java:273)
at org.jboss.system.ServiceController.deploy(ServiceController.java:257)
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.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
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:199)
at org.jboss.Main$1.run(Main.java:411)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:406)
[08:50:05,470,ServiceDeployer] Mbean exception while executing deploy on [Ljava.lang.Object;@3c6641
javax.management.ReflectionException: The MBean class could not be loaded by the specified loader
at com.sun.management.jmx.MBeanServerImpl.createMBean(MBeanServerImpl.java:754)
at org.jboss.system.ServiceCreator.create(ServiceCreator.java:85)
at org.jboss.system.ServiceController.deploy(ServiceController.java:178)
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.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
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.deployment.AutoDeployer.deploy(AutoDeployer.java:654)
at org.jboss.deployment.AutoDeployer.run(AutoDeployer.java:327)
at org.jboss.deployment.AutoDeployer.startService(AutoDeployer.java:509)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:117)
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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:775)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:479)
at org.jboss.system.ServiceController.registerAndStartService(ServiceController.java:273)
at org.jboss.system.ServiceController.deploy(ServiceController.java:257)
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.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
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:199)
at org.jboss.Main$1.run(Main.java:411)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:406)


Any help would be appreciated.

Regards,

pldougless.

[davidjencks]

What you posted appears to have a typo in the mbean class name, lower case l in Loader. If this is not the problem, please check the server log and find out if jbosscx.sar has been deployed before your mysql-service.xml.

[pldougless]

Thanks David;

I had more than a couple of "dumb thumb" entries in my xml file. I fixed them and the connection pool deploys fine.

Regards,

pldougless