wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes Need a guide how to connect JBoss 3.2.5 to Oracle 9i Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Need a guide how to connect JBoss 3.2.5 to Oracle 9i" Watch "Need a guide how to connect JBoss 3.2.5 to Oracle 9i" New topic
Author

Need a guide how to connect JBoss 3.2.5 to Oracle 9i

Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 573
I have downloaded JBoss 3.2.5 what I want to do is connect it to my Oracle 9i database.

What I would like is a step by step guide is there is one about.

I guess I would add the classes12.zip to the C:\jboss-3.2.5\lib directory, would I need to set any config files.

Thanks for any help Tony
Jeff Shelley
Ranch Hand

Joined: May 21, 2003
Posts: 70
Hi Tony,
in docs/examples/jca, there should be an oracle-ds.xml datasource configuration file. To set this up as a datasource, copy/paste it to your deploy directory, then go in there and edit all the connection specific stuff. Also, you should be able to paste your classes zip file in the deploy directory of the configuration you're using. if you haven't messed with anything, it's server/default/deploy/

After that, you're in! Best of luck!
--Jeff


It's almost Friday
Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 573
Thanks Jeff,
Not being an Oracle DBA type

for this code :
<connection-url>jdbc racle ci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc racle ci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>


Where can I find my oracle-tns-name and servicename:

And would you know what sql code goes in here:
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->

<!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>


Thanks again Tony
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Need a guide how to connect JBoss 3.2.5 to Oracle 9i
 
Similar Threads
JMX in JBoss
Missing required library jboss-boot.jar
oracle 9i client for 8i database
jboss 3.0.3 and oracle 9i
Deployment on Jboss and using postgres with JBoss