Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic