exception using cmp with oracle
ejbclinic May 18, 2002 8:43 AMI can't find oracle-service.xml in jboss-3.0.0rc1.(jboss3,0orc2 version can't find any where only orc1 available)
Well i was trying on jboss3.0 alpha and oracle 8.0 and have done a lot of struggle to work with cmp but fails i have done the follwing work.
1)make oracle-service.xml accoringly and put in deploy folder and don't remove the hsqldb-default-service.
2)put the classes102.jar in lib\ext folder which i have downloaded it from
http://otn.oracle.com/software/htdocs/distlic.html?/software/tech/java/sqlj_jdbc/htdocs/winsoft.html
3)change standardjaws.xml as
java:/OracleDS
<type-mapping>Oracle8</type-mapping>
false
..................
4)change standardjbosscmp-jdbc like
...........................
<!DOCTYPE jbosscmp-jdbc PUBLIC
"-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN"
"http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd"><jbosscmp-jdbc>
<!-- Andrew changed: -->
java:/OracleDS
<datasource-mapping>Oracle8</datasource-mapping>
true
<create-table>false</create-table>
...........................
but i am getting the following exception n middle(i have not deployed databaserelated bean and my session bean based programs are being deployed )
[2002-05-18 16:17:29,270,AutoDeployer,DEBUG] Received notification of mbean ZClassLoaders:id=1231171914's deployment.
[2002-05-18 16:17:29,270,ServiceCreator,INFO] About to create the beanjboss.jca:service=LocalTxCM,name=oracledb
[2002-05-18 16:17:29,380,ServiceController,ERROR] Could not create MBean: jboss.jca:service=LocalTxCM,name=oracledb
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)
[2002-05-18 16:17:29,440,ServiceDeployer,ERROR] Mbean exception while executing deploy on [Ljava.lang.Object;@aeed0
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)
[2002-05-18 16:17:29,440,ServiceDeployer,DEBUG] deploying with ServiceController
My oracle-service.xml file is as:
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- ==================================================================== -->
<!-- New ConnectionManager setup for OracleDB -->
<!-- ==================================================================== -->
<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
<!--real attributes-->
<config-property>
<config-property-name>ConnectionURL</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>jdbc:odbc:first</config-property-value>
</config-property>
<config-property>
<config-property-name>DriverClass</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>sun.jdbc.odbc.JdbcOdbcDriver</config-property-value>
</config-property>
<config-property>
<config-property-name>UserName</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>scott</config-property-value>
</config-property>
<config-property>
<config-property-name>Password</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>tiger</config-property-value>
</config-property>
jdbc/oracledb
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
0
50
5000
15
<!--criteria indicates if Subject (from security domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
ByContainer
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
java:/jaas/OracleDbRealm
java:/TransactionManager
Please help where i am wrong