how to connect to oracle?

Hi,
I'm looking for an example for a connection to oracle. I dont find good tutorials or similar.
Please help
Thanks!

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.

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

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.

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

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.

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 ]