aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes how to connect to oracle? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "how to connect to oracle?" Watch "how to connect to oracle?" New topic
Author

how to connect to oracle?

Kay Tracid
Ranch Hand

Joined: Mar 06, 2002
Posts: 148
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

Joined: Mar 17, 2000
Posts: 5782
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.


Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
Kay Tracid
Ranch Hand

Joined: Mar 06, 2002
Posts: 148
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

Joined: Jul 18, 2001
Posts: 236
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

Joined: Mar 06, 2002
Posts: 148
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

Joined: Oct 17, 2002
Posts: 47
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

Joined: Mar 06, 2002
Posts: 148
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to connect to oracle?