File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 1836
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: 1836

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: 1836
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).]
 
Don't get me started about those stupid light bulbs.
 
subject: Connect to Oracle
 
Similar Threads
mysql linux
oracle 10g
jdbc
java.sql.SQLException: ORA-03115: unsupported network datatype or representation
Configure datasource for SSL connection to Oracle DB