JBOSS - ORACLE
843829Mar 19 2003 — edited Mar 20 2003HI, I have a problem setting up oracle pool for Jboss.
The following is the thing that i have done:
1. Copy the "classes12.jar" from "oracle/ora90/jdbc/lib" to the "jboss/server/default/lib" catalog. (the Oracle JDBC driver)
2. Copy the "nls_charset12.jar" from "oracle/ora90/jdbc/lib" to the "jboss/server/default/lib" catalog. (Oralce language package)
3. Copy the "ocrs12.jar" from "oracle/ora90/jdbc/lib" to the "jboss/server/default/lib" catalog. (don't remember)
4. Copy the "jboss/docs/examples/jca/oracle-service.xml" file into the "jboss/server/default/deploy" catalog.
5. Edit the file "jboss/server/default/deploy/oracle-service.xml":
In the "OracleRealm" block
<blabla..."UserName">yourOralceLogin</module-option>
<blabla..."password">yourOraclePass</module-option>
In the "ManagedConnectionFactoryProperties" block:
<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin@localhost:1521:yourDB</configure-property>
localhost = your host (IP or DNS name) where you are running Oracle. An URL (eg "//oracle.foo.com" or "//129.129.129.129". Try both with and without "//")
1521 = port no.
yourDB = Oralce database name.
<blabla...UserName"...>yourOracleLogin</config-property>
<blabla...password"...>yourOraclePass</config-property>
6. Edit the the first lines in the file "jboss/server/default/conf/standardjaws.xml":
<jaws>
<datasource>java:/OracleDS</datasource>
<type-mapping>Oracle8</type-mapping>
<debug>false</debug>
In /JBoss/server/default/conf/standardjbosscmp-jdbc.xml.
Set
<defaults>
<datasource>java:/OracleDS</datasource>
<datasource-mapping>Oracle8</datasource-mapping></defaults>
However, it seems that something is missing ot the jar file is not deployed properly.
Is anyone there have the same problem?
The following is the messages i've got when starting Jboss:
11:44:57,667 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
<none>
Incompletely deployed packages:
<none>
MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
[ObjectName: jboss.jca:service=LocalTxCM,name=OracleDS
state: CONFIGURED
I Depend On: jboss.jca:service=LocalTxDS,name=OracleDS
jboss.jca:service=LocalTxPool,name=OracleDS
jboss.jca:service=CachedConnectionManager
jboss.security:name=JaasSecurityManager
jboss.jca:service=RARDeployer
Depends On Me: ]
Any quick help would be deeply appreciated.
cheers.