New Oracle driver connect problem

Martin Smith

unread,

Jul 7, 1997, 3:00:00 AM7/7/97

to

I'm having trouble getting the new Oracle type 4 driver ("thin") to
work.

I have installed the class files locally (on the client side) for the
moment, in several places zipped and unzipped since I'm a bit foggy on
the operation of the CLASSPATH and other procedures for finding classes
. . . I have classes111.zip from Oracle in BOTH my
lib directory and the directory where my application (not applet) is.
I have also tried unzipping the class111 files under my application
directory. One (small?) complication: I do have both jdk1.0 and 1.1
installed as well as Symantec VCP.

I am getting an error that says "no suitable driver "

I take this to mean java IS finding the oracle driver manager, but the
driver manager is not finding the actual thin driver class.

Can anyone report they are using this product successfully?

Can anyone tell me exactly what that message means so I can focus my
efforts?

Thanks.

Here's the error message log--

DriverManager.getConnection("jdbc:oracle:dnldthin:trade/trade@HPOracle")
trying
driver[className=oracle.jdbc.driver.OracleDriver,context=null,oracle.
jdbc.driver.OracleDriver@1ccc21] getConnection: no suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:111)
at java.sql.DriverManager.getConnection(DriverManager.java:149)
at sqltest4.main(sqltest4.java:17) SQLException: SQLState(08001)
*** SQLException caught ***
SQLState: 08001
Message: No suitable driver
Vendor: 0

Manuel Veloso

unread,

Jul 8, 1997, 3:00:00 AM7/8/97

to

In article <33C113...@erols.com> Martin Smith, mfs...@erols.com
writes:

>I'm having trouble getting the new Oracle type 4 driver ("thin") to
>work.

I couldn't tell from the snippet, so here goes:

did you do a Class.forName before calling getConnection()? For type 4
drivers (and for others too, I assume) you need to do this so the driver
can register with the DriverManager.

------------------------------------------------------
Manny Veloso Digital Plumber
vel...@pobox.com (home) vel...@itmasters.com (work)
------------------------------------------------------
"Ddecontextualization: just say no."

Bill Winiewicz

unread,

Jul 9, 1997, 3:00:00 AM7/9/97

to

On Mon, 07 Jul 1997 11:05:57 -0500, Martin Smith <mfs...@erols.com>
wrote:

>I'm having trouble getting the new Oracle type 4 driver ("thin") to
>work.
>

Where did you get this driver? I was under the understanding that
Oracle had not yet released a type 4 driver.

Bill

Martin Smith

unread,

Jul 9, 1997, 3:00:00 AM7/9/97

to Bill Winiewicz

From Deja News---

Following the alpha release, the beta release is now available for
download!

We now support JDK 1.1.1 as well as JDK 1.0.2. The drivers should work
with JDK 1.1.2, although we haven't tested the configuration. If you
find any problem, please let us know. Here's how you can get the
drivers:

For Sparc Solaris,

ftp://support.us.oracle.com/desktop/download/jdbc-beta-solaris.tar.gz

For x86 Win32 (Windows NT/95),

ftp://support.us.oracle.com/desktop/download/jdbc-beta-win32.zip

These files are available for temporary download until they are moved
to the official page at:

http://www.oracle.com/nca/java_nca/

The documentation has been completely redone to include much more
information than the alpha release. Since there are some incompatible
changes, please read the README.txt and the html documentation
carefully.

JDB...@us.oracle.com, Oracle Worldwide Customer Support