Connect to Oracle

[Rahul Mahindrakar]

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]

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]

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

How do i do the above

[Rahul Mahindrakar]

Are there any document online with bea that will help.

[anup vachali]

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).]