jdbc drivers - Certification Community

how do you get the jdbctest, jdbcversion programs to work, i
tried to run them both, they do not work
im running windows 98, with jdk1.1.8, i changed my classpaths
as said in documentation
how do you know which drivers are installed, to use jdbc

Related

java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path

I am using weblogic 8.1. I have the Oracle 817 client install. I cannot figure
out why WEblogic is looking for a 9i driver. I have read endless amounts of documentation
talking about setting the PATH to this and the CLASSPATH to that. None of it
has worked for me. I am running on Win XP Pro. I have modifed the startWeblogic.cmd,
my system PATH etc, and none of it works for me.
I have tried the following:
Set ORACLE_HOME = C:\Orant817
Set PATH = C:\Orant817\lib;C:\Orant817\bin;%WL_HOME%\bin;%WL_HOME%\bin\oci817_8;C:\Program
Files\Oracle\jre\1.1.7\bin;C:\Program Files\Oracle\jre\1.1.7\bin;%java_home%\bin;c:\ant\bin
Updated the startWeblogic.cmd with:
set OCI_HOME=C:\bea\weblogic81\server\bin\oci817_8\classes12.zip
set DB_HOME=C:\Orant817\bin
set CLASSPATH=%WEBLOGIC_CLASSPATH%;%POINTBASE_CLASSPATH%;%JAVA_HOME%\jre\lib\rt.jar;%WL_HOME%\server\lib\webservices.jar;%WASP_HOME%\lib\xalan.jar;%WASP_HOME%\lib\security-ng.jar;C:\Orant817\jdbc\lib\classes12.zip;%CLASSPATH%
#REM Call WebLogic Server
set PATH=%OCI_HOME%;%DB_HOME%;%PATH%
I can't understand why Weblogic wants to use a 9i driver, when I am clearly pointing
it to 8i drivers. Obviously I am missing something here.
Thanks!
Congrats on the diligent work. The last step is to put the exact driver
you want to use, ahead of the weblogic stuff in the server's classpath.
Our weblogic.jar contains references to our packaged (later) driver.
In fact we also ship an earlier oracle driver, but we use the later
by default. Because oracle's drivers change much more frequently than
our server packaging, the one(s) we ship are usually not as good as the
ones you can download from oracle's site. Therfore I suggest you download
their latest version of the driver you want.
Joe
Nathan wrote:
I am using weblogic 8.1. I have the Oracle 817 client install. I cannot figure
out why WEblogic is looking for a 9i driver. I have read endless amounts of documentation
talking about setting the PATH to this and the CLASSPATH to that. None of it
has worked for me. I am running on Win XP Pro. I have modifed the startWeblogic.cmd,
my system PATH etc, and none of it works for me.
I have tried the following:
Set ORACLE_HOME = C:\Orant817
Set PATH = C:\Orant817\lib;C:\Orant817\bin;%WL_HOME%\bin;%WL_HOME%\bin\oci817_8;C:\Program
Files\Oracle\jre\1.1.7\bin;C:\Program Files\Oracle\jre\1.1.7\bin;%java_home%\bin;c:\ant\bin
Updated the startWeblogic.cmd with:
set OCI_HOME=C:\bea\weblogic81\server\bin\oci817_8\classes12.zip
set DB_HOME=C:\Orant817\bin
set CLASSPATH=%WEBLOGIC_CLASSPATH%;%POINTBASE_CLASSPATH%;%JAVA_HOME%\jre\lib\rt.jar;%WL_HOME%\server\lib\webservices.jar;%WASP_HOME%\lib\xalan.jar;%WASP_HOME%\lib\security-ng.jar;C:\Orant817\jdbc\lib\classes12.zip;%CLASSPATH%
#REM Call WebLogic Server
set PATH=%OCI_HOME%;%DB_HOME%;%PATH%
I can't understand why Weblogic wants to use a 9i driver, when I am clearly pointing
it to 8i drivers. Obviously I am missing something here.
Thanks!
Thanks Joe! That was the problem. You're a life saver!
Joe Weinstein <joeNOSPAM#bea.com> wrote:
Congrats on the diligent work. The last step is to put the exact driver
you want to use, ahead of the weblogic stuff in the server's classpath.
Our weblogic.jar contains references to our packaged (later) driver.
In fact we also ship an earlier oracle driver, but we use the later
by default. Because oracle's drivers change much more frequently than
our server packaging, the one(s) we ship are usually not as good as the
ones you can download from oracle's site. Therfore I suggest you download
their latest version of the driver you want.
Joe
Nathan wrote:
I am using weblogic 8.1. I have the Oracle 817 client install. Icannot figure
out why WEblogic is looking for a 9i driver. I have read endless amountsof documentation
talking about setting the PATH to this and the CLASSPATH to that. None of it
has worked for me. I am running on Win XP Pro. I have modifed thestartWeblogic.cmd,
my system PATH etc, and none of it works for me.
I have tried the following:
Set ORACLE_HOME = C:\Orant817
Set PATH = C:\Orant817\lib;C:\Orant817\bin;%WL_HOME%\bin;%WL_HOME%\bin\oci817_8;C:\Program
Files\Oracle\jre\1.1.7\bin;C:\Program Files\Oracle\jre\1.1.7\bin;%java_home%\bin;c:\ant\bin
Updated the startWeblogic.cmd with:
set OCI_HOME=C:\bea\weblogic81\server\bin\oci817_8\classes12.zip
set DB_HOME=C:\Orant817\bin
set CLASSPATH=%WEBLOGIC_CLASSPATH%;%POINTBASE_CLASSPATH%;%JAVA_HOME%\jre\lib\rt.jar;%WL_HOME%\server\lib\webservices.jar;%WASP_HOME%\lib\xalan.jar;%WASP_HOME%\lib\security-ng.jar;C:\Orant817\jdbc\lib\classes12.zip;%CLASSPATH%
#REM Call WebLogic Server
set PATH=%OCI_HOME%;%DB_HOME%;%PATH%
I can't understand why Weblogic wants to use a 9i driver, when I amclearly pointing
it to 8i drivers. Obviously I am missing something here.
Thanks!
Nathan wrote:
Thanks Joe! That was the problem. You're a life saver!No, I just have a lot of experience (read: "I'm old") ;-)
Glad to help. We want you successful.
Joe
>
Joe Weinstein <joeNOSPAM#bea.com> wrote:
Congrats on the diligent work. The last step is to put the exact driver
you want to use, ahead of the weblogic stuff in the server's classpath.
Our weblogic.jar contains references to our packaged (later) driver.
In fact we also ship an earlier oracle driver, but we use the later
by default. Because oracle's drivers change much more frequently than
our server packaging, the one(s) we ship are usually not as good as the
ones you can download from oracle's site. Therfore I suggest you download
their latest version of the driver you want.
Joe
Nathan wrote:
I am using weblogic 8.1. I have the Oracle 817 client install. Icannot figure
out why WEblogic is looking for a 9i driver. I have read endless amountsof documentation
talking about setting the PATH to this and the CLASSPATH to that. None of it
has worked for me. I am running on Win XP Pro. I have modifed thestartWeblogic.cmd,
my system PATH etc, and none of it works for me.
I have tried the following:
Set ORACLE_HOME = C:\Orant817
Set PATH = C:\Orant817\lib;C:\Orant817\bin;%WL_HOME%\bin;%WL_HOME%\bin\oci817_8;C:\Program
Files\Oracle\jre\1.1.7\bin;C:\Program Files\Oracle\jre\1.1.7\bin;%java_home%\bin;c:\ant\bin
Updated the startWeblogic.cmd with:
set OCI_HOME=C:\bea\weblogic81\server\bin\oci817_8\classes12.zip
set DB_HOME=C:\Orant817\bin
set CLASSPATH=%WEBLOGIC_CLASSPATH%;%POINTBASE_CLASSPATH%;%JAVA_HOME%\jre\lib\rt.jar;%WL_HOME%\server\lib\webservices.jar;%WASP_HOME%\lib\xalan.jar;%WASP_HOME%\lib\security-ng.jar;C:\Orant817\jdbc\lib\classes12.zip;%CLASSPATH%
#REM Call WebLogic Server
set PATH=%OCI_HOME%;%DB_HOME%;%PATH%
I can't understand why Weblogic wants to use a 9i driver, when I amclearly pointing
it to 8i drivers. Obviously I am missing something here.
Thanks!

ORA-12545 from WLS5.1sp10 and JDBC

I'm trying to connect to an oracle 8.1.7 database from a solaris 8 box via jdbc. The weblogic server will connect fine and other apps run, however when I attempt Class.forName("oracle.jdbc.driver.OracleDriver"); from my Java 1.3.1 app, I get java.sql.SQLException: ORA-12545: Connect failed because target host or object does not exist. This app works locally and used to work on an old Solaris 2.6 server. I have classes12.zip in the path/classpath as the first entry, the tnsnames.ora is correct, and the LD_LIBRARY_PATH is pointing to $ORACLE_HOME/bin as it should. A test application written and run outside of Weblogic is able to connect using the same code. Any help is greatly appreciated.
Hi. You should check that the LD_LIBRARY_PATH for the server contains the weblogic driver library,
the oracle client libraries, and the standard OS C libraries. You are trying to use
Oracle's driver (thin or type-2?). For that driver you also need to make sure the
classes12.zip (or whatever version of the oracle driver you want) is in the server
classpath.
Show me the non-weblogic program that works, and the LD_LIBRARY_PATH and CLASSPATH that is in effect
when it works.
Joe
ccase wrote:
I'm trying to connect to an oracle 8.1.7 database from a solaris 8 box via jdbc. The weblogic server will connect fine and other apps run, however when I attempt Class.forName("oracle.jdbc.driver.OracleDriver"); from my Java 1.3.1 app, I get java.sql.SQLException: ORA-12545: Connect failed because target host or object does not exist. This app works locally and used to work on an old Solaris 2.6 server. I have classes12.zip in the path/classpath as the first entry, the tnsnames.ora is correct, and the LD_LIBRARY_PATH is pointing to $ORACLE_HOME/bin as it should. A test application written and run outside of Weblogic is able to connect using the same code. Any help is greatly appreciated.

unable to get jdrivers working on XP

I'm not sure whether this is an install problem or a jdbc problem so please forgive
my dual post...
On installation of WL6.1 I expected to find a bin directory below the wlserver6.1
directory, however, it wasn't there. This is a problem because I need the oci920_8
directory that contains the dll to use the jdriver. I tried re-installing but
with the same problem. Is there any way I can get hold of these files after the
installation process?
BTW - I should mention that I'm installing on XP pro, which I know is an unsupported
platform, but that I've been led to believe shouldn't cause a problem. At least
not one this major.
In a pinch I can change my code to work with oracle thin drivers which I have
got working with WL, but I'd rather get the jdrivers working if possible. So I
need that weblogicoci37.dll file (and maybe others) in that oci920_8 directory.
But where, oh where, could it be?
Any help would be much appreciated.
alan
I believe WLS 6.x has not shipped with Oracle 9 Jdriver yet right?
You can do things using thin driver where it can do almost the samething as
JDriver does.
"alan" <alanbrown#pacbell.net> wrote in message
news:3e246e31#newsgroups.bea.com...
>
I'm not sure whether this is an install problem or a jdbc problem soplease forgive
my dual post...
On installation of WL6.1 I expected to find a bin directory below thewlserver6.1
directory, however, it wasn't there. This is a problem because I need theoci920_8
directory that contains the dll to use the jdriver. I tried re-installingbut
with the same problem. Is there any way I can get hold of these filesafter the
installation process?
BTW - I should mention that I'm installing on XP pro, which I know is anunsupported
platform, but that I've been led to believe shouldn't cause a problem. Atleast
not one this major.
In a pinch I can change my code to work with oracle thin drivers which Ihave
got working with WL, but I'd rather get the jdrivers working if possible.So I
need that weblogicoci37.dll file (and maybe others) in that oci920_8directory.
But where, oh where, could it be?
Any help would be much appreciated.
alan
Hi Allan!
We have 920_8 driver from release 610sp4 and onwards. So, if you are using wls below
610sp4 you will not get 920 oracle jDriver. However, you can use oracle's 920 thin
driver to do your work.
Thanks,
Mitesh
alan wrote:
I'm not sure whether this is an install problem or a jdbc problem so please forgive
my dual post...
On installation of WL6.1 I expected to find a bin directory below the wlserver6.1
directory, however, it wasn't there. This is a problem because I need the oci920_8
directory that contains the dll to use the jdriver. I tried re-installing but
with the same problem. Is there any way I can get hold of these files after the
installation process?
BTW - I should mention that I'm installing on XP pro, which I know is an unsupported
platform, but that I've been led to believe shouldn't cause a problem. At least
not one this major.
In a pinch I can change my code to work with oracle thin drivers which I have
got working with WL, but I'd rather get the jdrivers working if possible. So I
need that weblogicoci37.dll file (and maybe others) in that oci920_8 directory.
But where, oh where, could it be?
Any help would be much appreciated.
alan

weblogic 6.1 and oci driver for Oracle 9.2.0.1

Have anybody tried to make weblogic 6.1 to work with the newest Oracle
database 9.2.0.1 through the oci driver? I had an error "no suitable driver"
though I tried different approaches: put shared libraries on a system path
and classes12.jar on a system classpath (first, of coarse), put shared
libraries under the bin directory of the weblogic 6.1 and classes12.jar
under the lib directory.
It is my impression that weblogic has to have its own dll files, like it
has under
\wlserver6.1\bin\oci901_8, for example , for the Oracle 9.0.1.8, to be able
to handle the oci driver.
I made the server to work with the thin driver for Oracle 9.2.0.1. However,
with the oci driver, I am not sure, how to set it up correctly, or even if
this is possible.
Any suggestions?
Regards,
Irene.

Using external jdbc drivers on Oracle

DB Version: Oracle 9i
OS: HPUX
I'm trying to access another database using a jdbc driver on a Java Stored Procedure.
When try to load jdbc driver using loadjava tool, several jdbc classes appears invalid.
I don't know if exists another way to use an external jdbc driver instead, such as adding to
java CLASSPATH environment variable path to jdbc driver, etc.
As additional info, I know that Oracle 9i uses java 1.3, tested extenal jdbc driver and classes on server jvm,
and everything runs fine.
I appreciate some help.
Regards.

Categories

Resources