aspose file tools*
The moose likes BEA/Weblogic and the fly likes Using Oracle Thin Driver in WLS 7.0 - Please help!! 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 » Products » BEA/Weblogic
Bookmark "Using Oracle Thin Driver in WLS 7.0 - Please help!!" Watch "Using Oracle Thin Driver in WLS 7.0 - Please help!!" New topic
Author

Using Oracle Thin Driver in WLS 7.0 - Please help!!

Simon Kelly
Greenhorn

Joined: Oct 02, 2002
Posts: 11
I am getting the following error upon server startup:
<Dec 12, 2002 7:54:15 PM MST> <Error> <JDBC> <001060> <Cannot startup connection pool "MyConnectionPool" java.sql.SQLException: No suitable driver>
My classpath contains Oracle's "classes12.jar". This is verified on the server console at startup.
The following are the relevant portions of my config.xml file in the domain root.
<JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
MaxCapacity="5" Name="MyConnectionPool"
Password="{3DES}OD0cIz1ljJk=" Properties="user=det"
Targets="MyServer" TestTableName="dual" URL="jdbc racle:thin@csdev1:1521 ev1"/>
<JDBCDataSource JNDIName="jdbc/MyDataSource"
Name="MyDataSource" PoolName="MyConnectionPool"/>
<JTA Name="MyDomain"/>
After setting my environment by navigating to the Domain root in a cmd box and running setEnv.cmd ...
CONTENTS OF setEnv.cmd
set CLASSPATH=C:\bea\weblogic700\server\lib\classes12.zip;%CLASSPATH%
set PATH=C:\bea\weblogic700\server\bin\oci817_8;%PATH%
call "C:\bea\weblogic700\server\bin\setWLSEnv.cmd"
...I ran the dbping utility and got the following error.
C:\bea\user_projects\ExodusDomain>java utils.dbping ORACLE user password dbname
Starting Loading jDriver/Oracle .....
Error encountered:
java.sql.SQLException: System.loadLibrary(weblogicoci38) threw java.lang.Unsatis
fiedLinkError: C:\bea\weblogic700\server\bin\oci817_8\weblogicoci38.dll: The spe
cified procedure could not be found
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:221)
at weblogic.jdbc.oci.Driver.connect(Driver.java:95)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:141)
at utils.dbping.main(dbping.java:157)
I did come across some mention of an oracle client installation requiring to be in my path.
Is anyone out there able to shine a light for me?
Update :
Still working on this one.
Would really appreciate some help.
I have now gotten the dbping utility to verify the connection and have set up the path and classpath identically for the server as for here and I am still getting 'Cannot startup connection pool - no suitable driver found' on startup!!
I really need help!!!

Thanks...
[ December 12, 2002: Message edited by: Simon Kelly ]
[ December 12, 2002: Message edited by: Simon Kelly ]
[ December 12, 2002: Message edited by: Simon Kelly ]
[ December 13, 2002: Message edited by: Simon Kelly ]
[ December 13, 2002: Message edited by: Simon Kelly ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using Oracle Thin Driver in WLS 7.0 - Please help!!