Cognos Oracle Jdbc Driver Oracledriver

 Posted admin

'Hi,

I've got to use the Oracle OCI driver for database connection instead of the thin driver in my project.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. It worked fine as the code returned a 'connection successful' message. I then zipped up the file and save it on a disk. However when I unzipped the file and tried to run it with a Windows batch file I got the dreaded message 'Could not load driver: oracle.jdbc.driver.OracleDriver'.Below is the batch file. RRDI 1.0.2 failed installation, CM-CFG-5034, could not load driver 'oracle.jdbc.OracleDriver' 0. I downloaded the client from Oracle. The Cognos Configuration tool connected with its test. It didn't at first until I found a driver for it. So Cognos knows about at least one driver.

Oracle

In designer (5.2), I had to adapt designer.tra to get my application to connect to the database using the OCI driver. In test mode, the application connects just fine using the OCI driver.

Jagadguru Adi Sankara Full Movie Video Download 3GP, MP4, HD MP4, And Watch Jagadguru Adi Sankara Full Movie Video. Jagadguru Adi Sankara Scenes|| Argue Between Adi Sankara And Kati Kapari - Akkineni Nagarjuna. Adi Shankara movie clip. Aadi Shankaracharya - Full Movie with dubbing in Hindi. Jagadguru Adi Shankara Scene - Argue Between Mandana Misra And Adi Shankara - Sai Kumar. Jagadguru Adi Sankara Full Length Telugu Movie|| DVD Rip. Jagadguru Adi Sankara Scenes|| Argue Between Adi Sankara And Kati Kapari - Akkineni Nagarjuna. Adi Shankaracharya - Movie. Jagadguru Adi Shankara Scene - Argue Between Mandana Misra And Adi Shankara - Sai Kumar. Adi shankaracharya movie May 31, 2014 - 129 min - Uploaded by Telugu MoviesJagadguru Adi Sankara Full Length Telugu Movie Title: Jagadguru Adi Sankara, Cast.

When I deploy the application onto our Linux server, which has the Oracle 9.2 client installed, I'm not able to get the application to work.

I've tried adapting the

.tra file, CLASSPATH, PATH etc. but without success sofar. In the BW application logfile, I get this error:

.
caused by: 'Failed to find or create the JDBC driver : oracle.jdbc.driver.OracleDriver'
.

So my question is: has anyone had success in deploying an application that has an Oracle OCI database connection?

What files do I have to modify on the server for the application to be able load the OCI driver?

Any hints / tips are highly appreciated.

Gerwin.

Oracle Jdbc Driver

Greenhorn
posted 14 years ago
Hi all,
I got a problem that I can not solve for a few days.
I created a simple Java class to test connection to an Oracle database. It worked fine as the code returned a 'connection successful' message. I then zipped up the file and save it on a disk. However when I unzipped the file and tried to run it with a Windows batch file I got the dreaded message 'Could not load driver: oracle.jdbc.driver.OracleDriver' .Below is the batch file:
*********************************************************
set DEFAULT_HOME_HOME=.
set JAVA_HOME=%DEFAULT_HOME_HOME%JRE1.3.1
set PATH=%JAVA_HOME%bin;%PATH%
set CLASSPATH=%JAVA_HOME%librt.jar;%JAVA_HOME%libi18n.jar;%DEFAULT_HOME_HOME%libclasses12.zip;%DEFAULT_HOME_HOME%lib
java -jar testConn.jar
pause
************************************************
I have checked and made sure all of the required files are in their proper directories. Let me know if you spot a problem..
Ranch Hand
posted 14 years ago
So, is the 'could not load driver' message a polite version of a ClassNotFoundException? If that's the case then the JVM obviously can't find the driver class in your classpath. Is the driver in classes12.zip? You should really double-check. What's the idea of having ./lib on the classpath? Have you tried running with -classpath on the command line? Do you stil have your original before you put it on disk? Does that still work? If so have you tried to run a diff?
Anyway, I hope this gives you some ideas but I can't see any obvious reason why it isn't working for you.
Jules
Greenhorn
posted 14 years ago
Julian,
Thanks for the reply.
Yes all files are in their proper directories.
I have tried the following:
1) java -classpath java -classpath .;C:classes12;C:jbuilder9jdk1.4jrelibrt.jar;C:jbuilder9jdk1.4jrelibi18n.jar;C:jbuilder9jdk1.4jrelibsunrsasign.jar;C:jbuilder9jdk1.4jrelibjsse.jar;C:jbuilder9jdk1.4jrelibjce.jar;C:jbuilder9jdk1.4jrelibcharsets.jar;C:jbuilder9jdk1.4jreclasses;C:jbuilder9jdk1.4libtools.jar -jar testConn.jar
In jbuilder, I see this when I tried to run the application
C:jbuilder9jdk1.4binjavaw -classpath 'D:Documents and SettingsbwfxhhbjbprojectTestConnectionclasses;C:classes12;C:jbuilder9jdk1.4jrelibrt.jar;C:jbuilder9jdk1.4jrelibi18n.jar;C:jbuilder9jdk1.4jrelibsunrsasign.jar;C:jbuilder9jdk1.4jrelibjsse.jar;C:jbuilder9jdk1.4jrelibjce.jar;C:jbuilder9jdk1.4jrelibcharsets.jar;C:jbuilder9jdk1.4jreclasses;C:jbuilder9jdk1.4libtools.jar' com.****.test.ConnectionManager
Load of driver successful: oracle.jdbc.driver.OracleDriver
DBURL = jdbc racle:thin:@XXXXXXXX.com:1521 RSFMID1
Connection successful :jdbc racle:thin:@XXXXXXX.com:1521 RSFMID1
Do you see any problems?

Oracle Jdbc Url Driver

Greenhorn
posted 14 years ago
I finally got it to work
I put the classes12.jar in java_home/jre/lib/ext as per the following forum
http://forum.java.sun.com/thread.jsp?forum=48&thread=444320
Now the question is, why does it work?
Greenhorn
posted 14 years ago

Oracle Driver For Jdbc Connection

Hi
I have encountered the same issue while working with WSAD.In the available JREs I gave the path of where i had installed JDK1.3, yet I had to put the classes12.zip in the ext.
My guess is that when i run the program within WSAD, only /ext folder is searched.Perhaps Julian could clear the doubt for both of us.
What do you say Julian?
regards
Prashant Jain