Solved

How to configure an Oracle Connection Pool using oci8 from Weblogic 7.0

Posted on 2004-09-07
10
1,523 Views
Last Modified: 2008-02-01
Gentlemen,

As part of our experiments, we are now trying to configure an Oracle Connection pool from Weblogic 7.0.

 

The Connection pool parameters we are using are on the Weblogic console (services->jdbc->connection pools):
 

Name: OracleConnectionPool

URL: jdbc:oracle:oci8:@(description=(address=(host=devt_oracle)(protocol=tcp)(port=1521))(connect_data=(SID=BizAgiOr)))

Driver ClassName: oracle.jdbc.driver.OracleDriver

Properties (key=value) : dll=ocijdbc8
                                    DatabaseName=BizAgiVision
                                    protocol=oci8

 

Since we are using the oci8 protocol, we installed the Oracle 8 client on my machine.

 

The URL connection string already worked in one of our coworker’s machine.

 

The classpath on startWLS.cmd (Weblogic start script) is


set CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_sp.jar;%WL_HOME%\server\lib\weblogic.jar;
set CLASSPATH=%CLASSPATH%;%MSSQLDRIVER_HOME%\msbase.jar;%MSSQLDRIVER_HOME%\msutil.jar;%MSSQLDRIVER_HOME%\mssqlserver.jar;
set CLASSPATH=%CLASSPATH%;C:\Downloads\Oracle\classes12.zip

where obviously classes12.zip was copied in this said path in my machine. .

 

The string "C:\Downloads\Oracle\classes12.zip" was also added to CLASSPATH on my machine’s environment variables.


Unfortunately, we are obtaining this exception upon Weblogic startup:

<Sep 7, 2004 5:36:12 PM GMT-05:00> <Error> <JDBC> <001060>
<Cannot startup connection pool "OracleConnectionPool" weblogic.common.ResourceException: weblogic.common.ResourceException:
 Could not load 'oracle.jdbc.driver.OracleDriver

 If this is a type-4 JDBC driver, it could occur if the JDBC
 driver is not in the system CLASSPATH.

 If this is a type-2 JDBC driver, it may also indicate that
 the Driver native layers(DBMS client lib or driver DLL)
 have not been installed properly on your system
 or in your PATH environment variable.

 This is most likely caused by one of the following:
 1. The native layer SO, SL, or DLL could not be found.
 2. The file permissions on the native layer SO, SL, or DLL
    have not been set properly.
 3. The native layer SO, SL, or DLL exists, but is either
    invalid or corrupted.

 For more information, read the installation documentation
 for your JDBC Driver, available from:
 http://e-docs.bea.com

        at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Con

nectionEnvFactory.java:220)…(Exception continues..)

 

Have you ever had this kind of problem before?

Thanks in advance.


0
Comment
Question by:eduardotorres17
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
10 Comments
 
LVL 92

Expert Comment

by:objects
ID: 12001789
does the error include the complete stack trace?
0
 
LVL 86

Accepted Solution

by:
CEHJ earned 400 total points
ID: 12001849
You may need to set Weblogic's own classpath. See

http://www.weblogic.com/docs51/classdocs/oraclethin.html
0
 
LVL 92

Expert Comment

by:objects
ID: 12001870
Try using the -classpath option on the java startup command (if it is a classpath problem).
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 1

Expert Comment

by:jLasitha
ID: 12003458
Do you have Oracle client on your machine..?
0
 
LVL 12

Expert Comment

by:Giant2
ID: 12004025
you must set the classpath for Weblogic.
Read this:
http://www.weblogic.com/docs51/admindocs/classpath.html#cpwls

Hope this help you.

Bye, Giant.
0
 
LVL 12

Expert Comment

by:Giant2
ID: 12004041
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 12004573
>>you must set the classpath for Weblogic.

(already mentioned)
0
 
LVL 12

Expert Comment

by:Giant2
ID: 12004596
>>>you must set the classpath for Weblogic.
>(already mentioned)

whoooops!

eduardotorres17,
could you tell us if the suggestions given to you solve your problem?
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
Suggested Courses

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question