Oracle 8i DataSource configuration

[eslam_ma]

Can any one help me in how to configure Oracle8i datasource on JBoss 3.0?please help

[rsal]

Take a look in jboss\docs\examples\jca. In there you'll find an oracle-service.xml file. In that file, there will be a couple of things you'll need to change:

1. Find all instances of name=OracleDS and change that you what your DataSource is called in your app.
2. Find this line:
<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@youroraclehost:1521:yoursid</config-property>
and change the ConnectionURL to match yours.
3. Find this:
<config-property name="UserName" type="java.lang.String"></config-property>
<config-property name="Password" type="java.lang.String"></config-property>
and enter in your username and password for your database.

That should give you something functional..

HTH,
/rick

[muaddib]

And when your file is correct, what do you do with it?? Where do you put it?

[break]

In the /deploy folder

[davidjencks]

1. Find all instances of name=OracleDS and change that you what your DataSource is called in your app.

This isn't quite right. You just need to find
OracleDS
and change it to the name you look up. The name=OracleDS stuff is part of the object name for the mbean and not related to jndi lookup.

[eslam_ma]

Thanx guys I do what u all tell me to do but I think I still make an error. I want to ask u if I want to make my datasource name for example pyramid Shall I write the JNDINAME in oracle-services.xml
pyramid or jdbc/pyramid or java:/pyramid
and if I want to lookup it from my code which JNDI name I must write in my code

[davidjencks]

pyramid
results in binding under java:/pyramid

You can use that name directly in code or use the env redirection to make it available as somethingelse under

java:/comp/env/somethingelse