JBoss 3.0.4 and Oracle 8.1.7 Problem - Please help

[msnair]

Hello All,

I am trying to configure an Oracle datasource using:
JBOSS 3.0.4
Oracle 8.1.7 (running on a remote host)
Platform is WinNT

Here are is the procedure:
1. Put Oracle JDBC driver zip file classes12.zip in $JBOSS_HOME/server/default/lib
2. Modified oracle-service.xml from $JBOSS/docs/examples/jca
a. URL
b. UserName
c. Password
3. Copied oracle-service.xml to $JBOSS_HOME/server/default/deploy

Results:
1. JBOSS seemed to have done its work. The display on the console was:
13:37:07,175 INFO [MainDeployer] Starting deployment of package: file:/Q:/jboss
-3.0.4/jboss-3.0.4/server/default/deploy/oracle-service.xml
13:37:07,472 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=Ora8DS d
oes not implement any Service methods
13:37:07,504 INFO [JBossManagedConnectionPool] Creating
13:37:07,504 INFO [JBossManagedConnectionPool] Created
13:37:07,504 INFO [LocalTxConnectionManager] Creating
13:37:07,519 INFO [LocalTxConnectionManager] Created
13:37:07,519 INFO [JBossManagedConnectionPool] Starting
13:37:07,519 INFO [JBossManagedConnectionPool] Started
13:37:07,535 INFO [LocalTxConnectionManager] Starting
13:37:07,629 INFO [OracleDataSource] Bound connection factory for resource adap
ter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/OracleDataSource'
13:37:07,629 INFO [LocalTxConnectionManager] Started
13:37:07,629 INFO [MainDeployer] Deployed package: file:/Q:/jboss-3.0.4/jboss-3
.0.4/server/default/deploy/oracle-service.xml

Problem:
I could see no Oracle database connections being taken. For verifying I did a netstat and it shows no connections.

Any help on resolving this issue would be highly appreciated.

Thanks
MS

[lepekhine]

netstat will show connection when you really get connection from datasource. See also MinSize and MaxSize attributes in oracle-service.xml

[msnair]

Hello,

Thanks for finding some time for answering my question.

The value of Min and Max are 5 and 20 respectively.

thanks
MS

oracle-service.xml file is enclosed inline:

<?xml version="1.0" encoding="UTF-8"?>


<!--uncomment out this line if you are using the OracleDbRealm above
OracleDbRealm
-->
<depends
optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->


OracleDataSource



<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:mstest/[e-mail]:1523:ifam817</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<config-property name="UserName" type="java.lang.String">mstest</config-property>
<config-property name="Password" type="java.lang.String">mstest</config-property>



<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
<!--
jboss:service=Hypersonic
-->


<!-- Connection pool Setting ... -->
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->


5
20
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

<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

java:/TransactionManager

<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer