This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

help,config the oracle'datasource driver and connection pool in jboss+tomcat,thanks a lot!!

Posted by woken on May 18, 2001 at 4:46 AM

I am a beginner in jboss and want to use the oracle database in my application ,but after I have followed the jboss docu to config the corresponding files,the jboss server cannot load the connection pool of the Oracle database . Anyone has met these question? Could you please help me?? Thanks a lot!!!

Note:The red parts are added by me below!
1. running environments
os: window2000 professional
jdk: jdk1.3.0
container: JBoss-2.2.1 + Tomcat-3.2.1 (9671204) [APR-19-2001] (no configuration needed!) (come from http://www.jboss.org/business/binary.html)">http://www.jboss.org/business/binary.html)">http://www.jboss.org/business/binary.html)
database: Oracle8i Enterprise Edition Release 8.1.7.0.0

2. Jboss.property:

# System properties
# These will be loaded and set by jBoss
#java.rmi.server.useLocalHostName=true
#java.rmi.server.hostname=localhost
#java.rmi.server.codebase=http://localhost:8080/">http://localhost:8080/">http://localhost:8080/
jboss.xa.xidclass=oracle.jdbc.xa.OracleXid

# Deprecated: JDBC Drivers should be specified in jboss.jcml, in JDBCProvider
jdbc.drivers=oracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver

#java.security.manager=java.lang.SecurityManager

java.security.auth.login.config==file:../conf/default/auth.conf

# Tomcat session Id generation. Uncomment to make Tomcat initial request faster
# tomcat.sessionid.randomclass=java.util.Random

3.jboss.conf:

oracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver

OracleDB
jdbc:oracle:thin:@10.2.20.46:1521:ambowedu
scott
tiger

1476
true
default
false

InstantDB
org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl

jdbc:idb:../conf/default/instantdb.properties
1200000

10

false
false
false
true
120000
1800000
false
false
1.0
0

DefaultDS
org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl

jdbc:HypersonicSQL:hsql://localhost:1476
1200000
sa
10

false
false
false
true
120000
1800000
false
false
1.0
0

����������

5. the result when running the server:
When I finish the configurations, I open a dos window and enter the directory to type the command : run_with_tomcat, now the result is below, the jboss server cannot load the connection pool of Oracle, Have I lost some configuration???

D:\JBoss-2.2.1_Tomcat-3.2.1\jboss\bin>run_with_tomcat
JBOSS_CLASSPATH=;C:\jdk1.3/lib/tools.jar;C:\jdk1.3/lib/tools.jar;C:\jdk1.3/lib/t
ools.jar;C:\jdk1.3/lib/tools.jar;C:\jdk1.3/lib/tools.jar;C:\jdk1.3/lib/tools.jar
;run.jar;../lib/crimson.jar
jboss.home = D:\JBoss-2.2.1_Tomcat-3.2.1\jboss
Using configuration "tomcat"
[Info] Java version: 1.3.0,Sun Microsystems Inc.
[Info] Java VM: Java HotSpot(TM) Client VM 1.3.0-C,Sun Microsystems Inc.
[Info] System: Windows 2000 5.0,x86
[Shutdown] Shutdown hook added
[Service Control] Registered with server
[Service Control] Initializing 27 MBeans
[JDBC provider] Initializing
[JDBC provider] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
[JDBC provider] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC provider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JDBC provider] Initialized
[OracleDB] Initializing
[OracleDB] Initialized
[Webserver] Initializing
[Webserver] Initialized
[Naming] Initializing
[Naming] Initialized
[JNDIView] Initializing
[JNDIView] Initialized
[Transaction manager] Initializing
[Transaction manager] Initialized
[JAAS Security Manager] Initializing
[JAAS Security Manager] Initialized
[OracleDB] Initializing
[OracleDB] Initialized
[Hypersonic] Initializing
[Hypersonic] Initialized
[InstantDB] Initializing
[InstantDB] Initialized
[DefaultDS] Initializing
[DefaultDS] Initialized
[Container factory] Initializing
[Container factory] Initialized
[EmbeddedTomcat] Initializing
[EmbeddedTomcat] Initialized
[JBossMQ] Initializing
[JBossMQ] Initialized
[DefaultJMSProvider] Initializing
[DefaultJMSProvider] Initialized
[StdJMSPool] Initializing
[StdJMSPool] Initialized
[J2EE Deployer Default] Initializing
[J2EE Deployer Default] Initialized
[Auto deploy] Initializing
[Auto deploy] Initialized
[RARDeployer] Initializing
[RARDeployer] Initialized
[ConnectionManagerFactoryLoader] Initializing
[MinervaNoTransCMFactory] Initialized
[ConnectionManagerFactoryLoader] Initializing
[MinervaSharedLocalCMFactory] Initialized
[ConnectionManagerFactoryLoader] Initializing
[MinervaXACMFactory] Initialized
[ConnectionFactoryLoader] Initializing
[BlackBoxDS] Initialized
[JMX RMI Adaptor] Initializing
[JMX RMI Adaptor] Initialized
[JMX RMI Connector] Initializing
[JMX RMI Connector] Initialized
[Mail Service] Initializing
[Mail Service] Initialized
[Service Control] Initialized 27 services
[Service Control] Starting 27 MBeans
[JDBC provider] Starting
[JDBC provider] Started
[OracleDB] Starting
[OracleDB] Stopped
[OracleDB] java.lang.IllegalStateException: Cannot start XA Connection Pool; the
re is no TransactionManager in JNDI!
[OracleDB] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo
ader.java:320)
[OracleDB] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.
java:93)
[OracleDB] at java.lang.reflect.Method.invoke(Native Method)
[OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:162
[OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1523)
[OracleDB] at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[OracleDB] at java.lang.reflect.Method.invoke(Native Method)
[OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:162
[OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1523)
[OracleDB] at org.jboss.Main.(Main.java:203)
[OracleDB] at org.jboss.Main$1.run(Main.java:107)
[OracleDB] at java.security.AccessController.doPrivileged(Native Method)
[OracleDB] at org.jboss.Main.main(Main.java:103)
[Service Control] Could not start DefaultDomain:service=XADataSource,name=null
[Service Control] java.lang.IllegalStateException: Cannot start XA Connection Po
ol; there is no TransactionManager in JNDI!
[Service Control] at org.jboss.jdbc.XADataSourceLoader.startService(XAData
SourceLoader.java:320)
[Service Control] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBean
Support.java:93)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:162
[Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Service Control] at org.jboss.util.ServiceControl.start(ServiceControl.ja
va:97)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:162
[Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Service Control] at org.jboss.Main.(Main.java:203)
[Service Control] at org.jboss.Main$1.run(Main.java:107)
[Service Control] at java.security.AccessController.doPrivileged(Native Me
thod)
[Service Control] at org.jboss.Main.main(Main.java:103)
[Webserver] Starting
[Webserver] Codebase set to http://zhangjianguo:8083/">http://zhangjianguo:8083/">http://zhangjianguo:8083/
[Webserver] Started webserver on port 8083
[Webserver] Started
[Naming] Starting
[Naming] Naming started on port 1099
[Naming] Started
[JNDIView] Starting
[JNDIView] Started
[Transaction manager] Starting
[Transaction manager] Started
[JAAS Security Manager] Starting
[JAAS Security Manager] JAAS.startService, cachePolicy=null
[JAAS Security Manager] JAAS.startService, SecurityProxyFactory=org.jboss.securi
ty.SubjectSecurityProxyFactory@39b538
[JAAS Security Manager] Started
[OracleDB] Starting
[OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
[OracleDB] Started
[Hypersonic] Starting
[Hypersonic] Server 1.4 is running
[Hypersonic] Database started
[Hypersonic] Started
[InstantDB] Starting
[InstantDB] XA Connection pool InstantDB bound to java:/InstantDB
Enhydra InstantDB - Version 3.26
[InstantDB] The Initial Developer of the Original Code is Lutris Technologies In
c.
Portions created by Lutris are Copyright (C) 1997-2001 Lutris Technologies, Inc.

All Rights Reserved.
[Hypersonic] Press [Ctrl]+[C] to abort
[InstantDB] Started
[DefaultDS] Starting
[DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[DefaultDS] Started
[Container factory] Starting
[Container factory] Started
[EmbeddedTomcat] Starting
[EmbeddedTomcat] Starting EmbeddedTomcat....
����������
[Service Control] Started 27 services
[Default] JBoss 2.2.1 Started in 0m:15s