10 Replies Latest reply on Aug 11, 2003 3:11 PM by javalis

Using Oracle as Datasource

s_kavita Oct 30, 2002 7:32 AM

hi,
instead of using Hypersonic as a Datasource for my CMP application i want to use Oracle for storing my data.i want the step by step detail of the process which i should follow.I tried the online documentation of JBOSS but there i didnot get any help.so if there is any link where i can get some help ,please write it to me.

thank u.....

1. Re: Using Oracle as Datasource

satyannair Oct 30, 2002 10:53 AM (in response to s_kavita)

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...
Actions
2. Re: Using Oracle as Datasource

haribda May 22, 2003 11:09 AM (in response to s_kavita)

I could not find oracle-service.xml file.
Only orcale-ds.xml
Actions
3. Re: Using Oracle as Datasource

ejbnewbie May 22, 2003 5:30 PM (in response to s_kavita)

you can use *-ds.xml instead of *-service.xml file.
it's located at

JBOSS_HOME\docs\examples\jca\oracle-ds.xml

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 :-)

peace

ejbnewbie
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.
Actions
4. Re: Using Oracle as Datasource

mikeklem May 22, 2003 6:58 PM (in response to s_kavita)

If you are using JBoss 3.0.7 you can find it here:

<JBOSS_HOME>/docs/examples/jca/oracle-service.xml
Actions
5. Re: Using Oracle as Datasource

kar2000 Jul 17, 2003 6:46 AM (in response to s_kavita)

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?
Actions
6. Re: Using Oracle as Datasource

juhalindfors Jul 17, 2003 8:11 AM (in response to s_kavita)

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.
Actions
7. Re: Using Oracle as Datasource

ksudhir Jul 17, 2003 9:06 AM (in response to s_kavita)

if u have jboss3.2.1 then use example file i.e., oracle-ds.xml from docs\examples\jca
or
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...
Actions
8. Re: Using Oracle as Datasource

kar2000 Jul 18, 2003 2:50 AM (in response to s_kavita)

hi,

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?

thanks,
kar2k
Actions
9. Re: Using Oracle as Datasource

juhalindfors Jul 18, 2003 3:05 AM (in response to s_kavita)

The sample code for the JMX book contains an example of a generic JMX monitor that can be attached to any MBean attribute. http://jboss.org/index.html?module=html&op=userdisplay&id=docs/index

-- Juha
Actions
10. Re: Using Oracle as Datasource

javalis Aug 11, 2003 3:11 PM (in response to s_kavita)

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.

Jose
Actions

Go to original post