multiple oracle db connect pools

[lacarlota]

how can set multiple oracle connection pools with different username and passwords each?

example;

oraclepool1 user1/passw1
oraclepool2 user2/passw2
.. ..

is it possible in jboss?

thanks,

[jpoley]

oracle1-service.xml (for first one)
oracle2-service.xml (for second one)

make sure they have distinct DS + JNDI names

-jp

[lacarlota]

I did what you recommended it's giving me this error..

08:43:27,734 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss
-3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service1.xml
08:43:27,754 INFO [MainDeployer] deployment waiting for deployer: file:/C:/jbos
s-3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service1.xml
08:43:27,754 INFO [MainDeployer] Deployment of package: file:/C:/jboss-3.0.4_to
mcat-4.1.12/server/default/deploy/oracle-service1.xml is waiting for an appropri
ate deployer.
08:43:27,754 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
ration 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
[org.jboss.deployment.DeploymentInfo@3d08d30 { url=file:/C:/jboss-3.0.4_tomcat-4
.1.12/server/default/deploy/oracle-service1.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/jboss-3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service
1.xml
lastDeployed: 1045665807754
lastModified: 1045665807734
mbeans:
]Incompletely deployed packages:
[org.jboss.deployment.DeploymentInfo@3d08d30 { url=file:/C:/jboss-3.0.4_tomcat-4
.1.12/server/default/deploy/oracle-service1.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/jboss-3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service
1.xml
lastDeployed: 1045665807754
lastModified: 1045665807734
mbeans:
]MBeans waiting for classes:

MBeans waiting for other MBeans:





I copied the oracle-service.xml in docs/examples/jca..is there something that I need to modify other than the connection URL, jndi name and username/password ?

Please help, thanks..

[plandmann]

The filename has to end with "service.xml". So just rename your "oracle-service1.xml" to "oracle1-service.xml" in order to get it to work.

I had the same problem, it really took some time to find this out. :-/