-
1. Re: Oracle 8i DataSource configuration
rsal Jun 19, 2002 1:53 PM (in response to eslam_ma)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 -
2. Re: Oracle 8i DataSource configuration
muaddib Jun 19, 2002 2:56 PM (in response to eslam_ma)And when your file is correct, what do you do with it?? Where do you put it?
-
3. Re: Oracle 8i DataSource configuration
break Jun 19, 2002 4:38 PM (in response to eslam_ma)In the /deploy folder
-
4. Re: Oracle 8i DataSource configuration
davidjencks Jun 20, 2002 1:31 AM (in response to eslam_ma)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. -
5. Re: Oracle 8i DataSource configuration
eslam_ma Jun 20, 2002 4:35 AM (in response to 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 -
6. Re: Oracle 8i DataSource configuration
davidjencks Jun 20, 2002 10:13 AM (in response to eslam_ma)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