configure oracle 9.2.0.4 datasoure on Jboss error
jackytang Apr 13, 2004 2:26 AMJboss on Windows 2000(localhost)
DB:Oracle 9.2.0.4 on RedHat AS2.1(172.30.1.6)
JBOSS_HOME = D:\jboss-3.2.3
Java_Home = C:\j2sdk1.4.1_02
I did copy the class12.zip, ojdbc14.jar to my
JBOSS_HOME\server\default\lib
and make change of some xmls files "jboss-service.xml",
"login-config.xml", "standardjbosscmp-jdbc.xml", "standardjaws.xml" in the JBOSS_HOME\server\default\conf folder
*************************************************************
------------------jobss-service.xml-----------------------------
<!-- ==================================================================== -->
<!-- Transactions -->
<!--============================================================= -->
<!-- The configurable Xid factory. For use with Oracle, set pad to true -->
true
------------------jobss-service.xml-----------------------------
*************************************************************
------------------login-config.xml-------------------------------
<application-policy name = "FirebirdDBRealm">
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">sysdba</module-option>
<module-option name = "userName">sysdba</module-option>
<module-option name = "password">masterkey</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=FirebirdDS</module-option>
</login-module>
</application-policy>
------------------login-config.xml-------------------------------
************************************************************
------------------standardjbosscmp-jdbc.xml------------------
<!-- ===================================================================== -->
<!-- -->
<!-- Standard JBossCMP-JDBC Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->
<jbosscmp-jdbc>
java:/OracleDS
<datasource-mapping>Oracle</datasource-mapping>
</jbosscmp-jdbc>
------------------standardjbosscmp-jdbc.xml------------------
************************************************************
------------------standardjaws.xml-------------------------------
<!-- ===================================================================== -->
<!-- -->
<!-- Standard Jaws Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->
java:/OracleDS
<type-mapping>Oracle</type-mapping>
------------------standardjaws.xml------------------------------------
************************************************************
make change of some xmls files "oracle-xa-ds.xml" in the JBOSS_HOME\server\default\deploy folder
************************************************************
------------------oracle-xa-ds.xml-------------------------------
<xa-datasource>
<jndi-name>OracleDS</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:@172.30.1.6:1521:geo3pl</xa-datasource-property>
<xa-datasource-property name="User">nhweb</xa-datasource-property>
<xa-datasource-property name="Password">29178022</xa-datasource-property>
<depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager
------------------oracle-xa-ds.xml------------------------------------
************************************************************
make change of some xmls files "oracle-jdbc2-service.xml" in the JBOSS_HOME\server\default\deploy\jms folder
------------------oracle-jdbc2-service.xml-------------------------------
<depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=OracleDS
------------------oracle-jdbc2-service.xml-------------------------------
************************************************************
2004-04-13 13:41:06,867 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
Incompletely deployed packages:
MBeans waiting for classes:
MBeans waiting for other MBeans:
[ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker
jboss.web:service=WebServer
Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq:service=Invoker
state: CONFIGURED
I Depend On: jboss.mq:service=TracingInterceptor
Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
jboss.mq:service=InvocationLayer,type=JVM
jboss.mq:service=InvocationLayer,type=OIL
jboss.mq:service=InvocationLayer,type=OIL2
jboss.mq:service=InvocationLayer,type=RMI
jboss.mq:service=InvocationLayer,type=UIL2
, ObjectName: jboss.mq:service=TracingInterceptor
state: CONFIGURED
I Depend On: jboss.mq:service=SecurityManager
Depends On Me: jboss.mq:service=Invoker
, ObjectName: jboss.mq:service=SecurityManager
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
jboss.mq:service=TracingInterceptor
jboss.mq.destination:service=Queue,name=DLQ
, ObjectName: jboss.mq.destination:service=Queue,name=DLQ
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker
Depends On Me: ]
2004-04-13 13:41:06,877 INFO [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
2004-04-13 13:41:06,907 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/jboss-3.2.3/server/default/conf/jboss-service.xml
2004-04-13 13:41:06,907 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.3 (build: CVSTag=JBoss_3_2_3 date=200311301445)] Started in 14s:621ms