Re: Setting up Oracle Type-4 JDBC Driver

Paul Mahler wrote:

> Jason Pugh wrote:
>
> > After reading the documentation that comes with the new Oracle JDBC
> > drivers, I'm under the impression that the only way to set up access
 

> > to an Oracle database using the Type-4 ("thin") Driver was by using
 

> > Oracle 8's connection manager.
>
> I have successfully connected my java application to an Oracle 7.3
> databaserunning the database server and the application on the same
> windows NT 4.0
> machine.
>
> I would suggest that you start with the "employee" example that you
> get
> in the JDBC download. The trick is to get the connection string set up
>
> right. here is the example that worked for my machine:
>
> // Connect to the database
> // You must put a database name after the @ sign in the connection
>
> URL.
> // You can use either the fully specified SQL*net syntax or a
> short
> cut
> // syntax as <host>:<port>:<sid>. The example uses the short cut
> syntax.
> Connection conn =
> DriverManager.getConnection
> ("jdbc:oracle:oci7:pmahler:1526:ORCL",
> "scott", "tiger");
>
> jdbc:oracle:oci7 gets you the driver
> pmahler:1526:ORCL is
> tcp/ip host name
> tcp/ip listener port
> instance name.
>
> You can find the listener port in the oracle configuration file
> \ORANT\NETWORK\ADMIN\Listener.ora,
> or whatever similar directory you have for your environment. You can
> find the instance name by
> running the instance manager.
>
> You will need to have the oracle JDBC class files in your CLASSPATH.
> You
> have to have a recent
> enough version of Oracle that is compliant with the JDBC drivers. You
> have to have SQL/Net running.
>

It worked fine when I connected to a ver 7.2.2.3.0 database engine but not to a ver 7.3.2.2.0 one with 64-bits option, do I have to change anything to make it work or it just won't support ?

Thanks

> >
> >
> > I'm not too familiar with Oracle, but I'm running a java servlet
 that
> >
> > connects to an Oracles 7 database and I'd like to get this working
> > eventually through a Web Browser so I was wondering if the Type-4
> > Driver would be the way to go. If so, does anyone know how to set
> > this up for an Oracle 7 database?
> >
> > Any help greatly appreciated.
> >
> > Thanks.
>
> --
> Paul Mahler
> Data Based Systems, Inc.
> email: pmahler_at_databased.com
>
> -----BEGIN PGP PUBLIC KEY BLOCK-----
> Version: 2.6.2
>
> mQCNAzN/SC8AAAEEAMCuCCh/91S1tpCnuVKPprNfs1UACh9bMfDCJ6qmzjM9RA0b
> 4qUX/7QC8a8f/7weRYKdwBuejx2mJuOzy32LDuwnyFU3hexTBplotAS67M4JOnV2
> YwO/OJGzW5rA8RTYIGx75c7fmG7gCJbWBIx2YbWlJaTZlGoUGZ14WfWZVswhAAUT
> tCZQYXVsIFMuIE1haGxlciA8cG1haGxlckBkYXRhYmFzZWQuY29tPg==
> =ei0y
> -----END PGP PUBLIC KEY BLOCK-----
Received on Fri Jul 11 1997 - 00:00:00 CDT