Oracle with JBoss 3.0

[alice_adler01]

Initially posted on "Installation and Configuration" but this forum seems to have many such questions so I thought I should post on this one ..

========================================================

I tried to do the settings according to the documentation but I get DeploymentException when deploying the bean "OracelDS not found".

Plz help!

Here are the files:

jboss_home/conf/default/standardjaws.xml:

OracleDS
<type-mapping>Oracle8</type-mapping>
false

jboss_home/conf/default/standardjbosscmp-jdbc.xml:

OracleDS
<type-mapping>Oracle8</type-mapping>
false

jboss_home/deploy/oracleds-service.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: oracle-service.xml,v 1.3 2002/03/01 00:02:00 d_jencks Exp $ -->

<!-- =====================================================================-->
<!-- oracleds-service.xml -->
<!-- JBoss v3.0alpha (november 23, 2001) ORACLE thin driver Configuration -->
<!-- tested against ORACLE v8.x -->
<!-- ==================================================================== -->
<!-- -->
<!-- please put jdbc driver (in this case classes12.zip) in jboss_home/lib/ext -->
<!-- please put this file (oracleds-service.xml) under jboss_home/deploy -->
<!-- Contributed by Christian Biasuzzi [e-mail]-->
<!-- ===================================================================== -->






ConnectionURL=jdbc:oracle:thin:@localhost:1521:oracle
DriverClass=oracle.jdbc.driver.OracleDriver

OracleDS
java:/TransactionManager
<depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0


org.jboss.resource.security.ManyToOnePrincipalMapping

userName=scott
password=tiger



thanks a lot.

[davidjencks]

Which version of jboss 3 are you using (alpha, beta or cvs?) This looks like it should work with beta or cvs.

You should check:

1. jndiview to see if OracleDS is bound. If it is, then the problem is in the ejb configuration. If not, it is with the ConnectionFactoryLoader configuration. Lets assume it isn't bound.

2. Check the ConnectionFactoryLoader mbean to see if it is started. (at this point, it shouldn't be -- starting binds into jndi). Assuming it isn't, look in the server.log for ConnectionFactoryLoader to find the sections where this mbean is starting. You will probably see an error that explains what the problem is. The error may however be surrounded by reams of info you didn't really want to know...;-) If you can't figure it out post all the parts of the log where the ConnectionFactoryLoader is doing something. Please, however, try to prune out the non-ConnectionFactoryLoader parts.

[scoy]

You should try deploying the OracleDS service with the standard standardjbosscmp-jdbc.xml and standardjaws.xml first.

We are using this setup now, with the app's jbosscmp-jdbc.xml/jaws.xml being used to point it at OracleDS.

Presumably, "OracelDS" is a typo and not what is actually configured?

[alice_adler01]

I am using 3.0.0alpha.

This is the ConnectionFactoryLoader error from server logs. Am I missing some configuration??

[2002-03-14 10:57:17,750,ServiceDeployer,DEBUG] addMBeans: url file:/D:/jboss-3.0.0alpha/deploy/oracleds-service.xml
[2002-03-14 10:57:17,750,ServiceDeployer,DEBUG] deploying with ServiceController mbean

ConnectionURL=jdbc:oracle:thin:@localhost:1521:oracle
DriverClass=oracle.jdbc.driver.OracleDriver

OracleDS
java:/TransactionManager
<depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0


org.jboss.resource.security.ManyToOnePrincipalMapping

userName=scott
password=tiger

[2002-03-14 10:57:17,750,AutoDeployer,DEBUG] Received notification of mbean ZClassLoaders:id=-1874565311's deployment.
[2002-03-14 10:57:17,750,ServiceCreator,INFO] About to create the beanjboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,760,AutoDeployer,DEBUG] Received notification of mbean jboss.jca:service=ConnectionFactoryLoader,name=OracleDS's deployment.
[2002-03-14 10:57:17,760,ServiceCreator,INFO] Created the beanjboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,770,Configurator,DEBUG] ManagedConnectionFactoryProperties set to ConnectionURL=jdbc:oracle:thin:@localhost:1521:oracle
DriverClass=oracle.jdbc.driver.OracleDriver in jboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,770,Configurator,DEBUG] JndiName set to OracleDS in jboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,770,Configurator,DEBUG] TransactionManagerName set to java:/TransactionManager in jboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,770,Configurator,DEBUG] ConnectionManagerProperties set to #
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0 in jboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,770,Configurator,DEBUG] PrincipalMappingClass set to org.jboss.resource.security.ManyToOnePrincipalMapping in jboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,770,Configurator,DEBUG] PrincipalMappingProperties set to userName=scott
password=tiger in jboss.jca:service=ConnectionFactoryLoader,name=OracleDS
[2002-03-14 10:57:17,770,Configurator,DEBUG] found 0 mbean-ref elements
[2002-03-14 10:57:17,770,ConnectionFactoryLoader,INFO] Starting
[2002-03-14 10:57:17,780,OracleDS,ERROR] Stopped
javax.management.RuntimeOperationsException: Object name cannot be null
at com.sun.management.jmx.MBeanServerImpl.isRegistered(MBeanServerImpl.java:1096)
at org.jboss.resource.ConnectionFactoryLoader.startService(ConnectionFactoryLoader.java:402)
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.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-03-14 10:57:17,950,Default,ERROR] javax.management.RuntimeOperationsException: Object name cannot be null
[2002-03-14 10:57:17,960,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.isRegistered(MBeanServerImpl.java:1096)
[2002-03-14 10:57:17,960,Default,ERROR] at org.jboss.resource.ConnectionFactoryLoader.startService(ConnectionFactoryLoader.java:402)
[2002-03-14 10:57:17,970,Default,ERROR] at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:117)
[2002-03-14 10:57:17,970,Default,ERROR] at java.lang.reflect.Method.invoke(Native Method)
[2002-03-14 10:57:17,970,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[2002-03-14 10:57:17,980,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[2002-03-14 10:57:17,980,Default,ERROR] at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:775)
[2002-03-14 10:57:17,990,Default,ERROR] at $Proxy0.start(Unknown Source)
[2002-03-14 10:57:17,990,Default,ERROR] at org.jboss.system.ServiceController.start(ServiceController.java:479)
[2002-03-14 10:57:18,000,Default,ERROR] at org.jboss.system.ServiceController.registerAndStartService(ServiceController.java:273)
[2002-03-14 10:57:18,000,Default,ERROR] at org.jboss.system.ServiceController.deploy(ServiceController.java:257)
[2002-03-14 10:57:18,000,Default,ERROR] at java.lang.reflect.Method.invoke(Native Method)
[2002-03-14 10:57:18,010,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[2002-03-14 10:57:18,010,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[2002-03-14 10:57:18,020,Default,ERROR] at org.jboss.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
[2002-03-14 10:57:18,020,Default,ERROR] at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
[2002-03-14 10:57:18,030,Default,ERROR] at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
[2002-03-14 10:57:18,030,Default,ERROR] at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
[2002-03-14 10:57:18,040,Default,ERROR] at java.lang.reflect.Method.invoke(Native Method)
[2002-03-14 10:57:18,040,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[2002-03-14 10:57:18,050,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[2002-03-14 10:57:18,050,Default,ERROR] at org.jboss.deployment.AutoDeployer.deploy(AutoDeployer.java:654)
[2002-03-14 10:57:18,060,Default,ERROR] at org.jboss.deployment.AutoDeployer.run(AutoDeployer.java:327)
[2002-03-14 10:57:18,060,Default,ERROR] at org.jboss.deployment.AutoDeployer.startService(AutoDeployer.java:509)
[2002-03-14 10:57:18,070,Default,ERROR] at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:117)
[2002-03-14 10:57:18,070,Default,ERROR] at java.lang.reflect.Method.invoke(Native Method)
[2002-03-14 10:57:18,070,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[2002-03-14 10:57:18,080,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[2002-03-14 10:57:18,090,Default,ERROR] at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:775)
[2002-03-14 10:57:18,090,Default,ERROR] at $Proxy0.start(Unknown Source)
[2002-03-14 10:57:18,090,Default,ERROR] at org.jboss.system.ServiceController.start(ServiceController.java:479)
[2002-03-14 10:57:18,100,Default,ERROR] at org.jboss.system.ServiceController.registerAndStartService(ServiceController.java:273)
[2002-03-14 10:57:18,100,Default,ERROR] at org.jboss.system.ServiceController.deploy(ServiceController.java:257)
[2002-03-14 10:57:18,110,Default,ERROR] at java.lang.reflect.Method.invoke(Native Method)
[2002-03-14 10:57:18,110,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[2002-03-14 10:57:18,121,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[2002-03-14 10:57:18,121,Default,ERROR] at org.jboss.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
[2002-03-14 10:57:18,121,Default,ERROR] at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
[2002-03-14 10:57:18,131,Default,ERROR] at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
[2002-03-14 10:57:18,131,Default,ERROR] at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
[2002-03-14 10:57:18,141,Default,ERROR] at java.lang.reflect.Method.invoke(Native Method)
[2002-03-14 10:57:18,141,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[2002-03-14 10:57:18,151,Default,ERROR] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[2002-03-14 10:57:18,151,Default,ERROR] at org.jboss.Main.(Main.java:199)
[2002-03-14 10:57:18,161,Default,ERROR] at org.jboss.Main$1.run(Main.java:411)
[2002-03-14 10:57:18,161,Default,ERROR] at java.security.AccessController.doPrivileged(Native Method)
[2002-03-14 10:57:18,161,Default,ERROR] at org.jboss.Main.main(Main.java:406)
[2002-03-14 10:57:18,161,ServiceController,ERROR] javax.management.RuntimeOperationsException: Object name cannot be null

[scoy]

Two things to try:

a) My oracle-service.xml file contains:




...

b) You appear to be running the old 3.0alpha of JBoss. It's come a long way since then - you should give the beta a shot,or better still the version from CVS that's about a day newer than the beta.

[alice_adler01]

Stephen and David-

Thanks very much for the help. JBoss 3beta worked with exactly the same configuration..