File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP 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: 579
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: 579
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
 
 
subject: Need a guide how to connect JBoss 3.2.5 to Oracle 9i