wood burning stoves 2.0*
The moose likes BEA/Weblogic and the fly likes Connect to Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Connect to Oracle" Watch "Connect to Oracle" New topic
Author

Connect to Oracle

Rahul Mahindrakar
Ranch Hand

Joined: Jul 28, 2000
Posts: 1850
Hi,
I need to connect to oracle from my Weblogic Server 6.1. Any ideas or documents on how to do it will help.
Thanks
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Connecting to Oracle is no different from any other database. Take a look at the JDBC submenu of the console application.
The basic steps would be:
- configure a new connectionpool,
- configure a new jdbc datasource
- configure a new jdbc TX datasource (if needed)
- configure a multipool (if needed)
You need to put the drivers (classes12.zip) in the classpath of the server.
Rahul Mahindrakar
Ranch Hand

Joined: Jul 28, 2000
Posts: 1850

You need to put the drivers (classes12.zip) in the classpath of the server.

How do i do the above
Rahul Mahindrakar
Ranch Hand

Joined: Jul 28, 2000
Posts: 1850
Are there any document online with bea that will help.
anup vachali
Ranch Hand

Joined: Oct 17, 2000
Posts: 54
If u r using a script, u are probably doing something like this:
set CLASSPATH=%WEBLOGIC%;%WL_HOME%;%JAVA_HOME%\lib\tools.jar;%BEA%;%ORACLE%
%JAVA_HOME%\bin\java -hotspot -ms64m -ms64m -classpath %CLASSPATH% -Dweblogic.Domain=xxx -Dweblogic.Name=yyy -Djava.security.policy=%WL_HOME%\lib\weblogic.policy weblogic.Server
Substitute the path to the classes12.zip in ur ORACLE variable above.
Go to www.e-docs.bea.com and find the documentation for the server u r interested in.
HTH
Anup

[This message has been edited by anup vachali (edited August 22, 2001).]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connect to Oracle