Re: JDBC to Oracle8

I managed to connect to an Oracle8 db with the following syntax in Java: DriverManager.getConnection("jdbc:oracle:thin:_at_(description=(address=

                            (host=HOSTNAME)(protocol=tcp)(port=1521))
                            (connect_data=(sid=ORCL)))",
                           "scott", "tiger");

I don't know whether this syntax is correct and unfortunately I don't have further information (but I'd love to get some). Anyway, you might have to change the hostname, protocol, port, sid, username and password.

VKT schrieb:
>
> Has anyone ever got JDBC to connect to an Oracle8 DB?
> I'm desperately looking for connect strings (or URL's in java terms)
> I have tried thin and OCI8. nothing works. Why?
>
> Not even the examples from the jdbc directory can make a connection. I have
> changed the connections hundrens of times.
>
> I want to connect to a DB on the local NT machine.
>
> PS: ODBC Works.
Received on Tue Dec 14 1999 - 11:08:02 CET