• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

how to connect to oracle?

 
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 236
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
https://coderanch.com/forums/ thread - it may be helpfull for You.
Regards, Volodymyr.
 
Kay Tracid
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic