Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to connect to oracle?

 
Kay Tracid
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I'm looking for an example for a connection to oracle. I dont find good tutorials or similar.
Please help
Thanks!
 
Ajith Kallambella
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is something to get you started
JDBC Tutorial.
This ofcourse teaches the basics, and focuses on stand-alone JDBC apps. If you are looking to connect to a DB from the app server, you will have to tread a different path.
 
Kay Tracid
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the link. I already used JDBC with MySQL. Now I want to connect to oracle with EJBs. I want to know how is the structure and how can I realize it... Is there are any other link?
Thanks
regards Kay
 
Manjunath Subramanian
Ranch Hand
Posts: 236
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
To an extent, it is dependent on the AppServer you are using.From which appserver are you trying to connect to Oracle?
If you are using Bea Weblogic to connect to Oralce using Weblogic jDriver(Type 2 driver) then you can find useful information at http://e-docs.bea.com/wls/docs70/oracle/index.html
Most of the appserver's have examples and sufficient documentation which will help you on any question you have.So try to browse through the documentation of your appserver.If you find it scarce revert back for clarifications.
 
Kay Tracid
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your post.
I use JBoss, i will look at the documentation there. May be you (or some other) has some hints/examples for me?
regards kay
 
Volodymyr Shram
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Kay Tracid:
I use JBoss, i will look at the documentation there. May be you (or some other) has some hints/examples for me?

Please read my posts in this
http://www.coderanch.com/forums/ thread - it may be helpfull for You.
Regards, Volodymyr.
 
Kay Tracid
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry, for the stupid question, but where do I define dataSource to configure oracle with jboss?? what is dataSource exactly?
regards kay
[ January 13, 2003: Message edited by: Kay Tracid ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic