Solved

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

Posted on 2004-09-07
10
1,506 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
  • 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
 
LVL 1

Expert Comment

by:jLasitha
ID: 12003458
Do you have Oracle client on your machine..?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Starting to learn JAVA, 7 59
unix in java example 9 53
eclipse java  build path 6 45
How to convert String matching to regex in java 4 21
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
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…
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:
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now