you have to have a oracle-service.xml configured for that..
the jboss contains a sample oracle-service.xml
change it to suit ur needs...
and drop it in the deploy dir...
I could not find oracle-service.xml file.
you can use *-ds.xml instead of *-service.xml file.
it's located at
configure it to your needs like your jndi name, where the database is hosted and the username password. rest of it stays pretty much the same ..
do post back if you're having any problems :-)
PS: and btw, remove that hsqldb-ds.xml from your JBOSS_HOME\yourserver\deploy folder if you dont want it to load up when 'yourserver' starts up.
If you are using JBoss 3.0.7 you can find it here:
Well, I have a doubt in this regard - is there any means of finding in the jboss 3.0.7 server side and not in the Oracle 8 database server side,
how many connections are there in the pool,
how many connections are in use and
how many connections are being returned at a given point of time?
Pool maxSize and availableConnectionCount in your Managed Connection Pool MBean. Available connection count is a numeric type, you can trivially attach a JMX monitor to this attribute.
if u have jboss3.2.1 then use example file i.e., oracle-ds.xml from docs\examples\jca
for jboss3.0.? then use example file i.e., oracle-service.xml from docs\examples\jca
by default JndiName is "OracleDS", change it to suit ur needs...
i really appreciate your reply. can u give me some sample code by which the number of conections in use and available could be monitored?
Hi everyone, I'm facing a lot of problems in connecting Oracle 8.1.7i to Jboss using XA drivers.
Can anyone provide an example of the configuration??
thanks a lot.