|
Using JDBC thin driver we open a pool
of connections to Oracle and after what seems a random time but probably is
not the connections timeout if not used. Can anyone advise
please.
----- Original Message -----
Sent: Friday, April 05, 2002 6:24
PM
Subject: Re: JDBC with oracle
We
use the the thin client driver without installing Oracle, we just copy
classes12.zip to the classpath.
Just an additional note...
You must install the Oracle client on the machine you are using to
run the servlets or map a permanent drive to a location where the Oracle
client is installed.
Margaret
1. the drivers come with your oracle installation. on my windoze
box they are
here: /oracle/ora81/jdbc/lib/classes12.zip.
2. put the classes12.jar file in your classpath. use a
connection string as follows in your code (Connection Conn =
DriverManager.getConnection
"jdbc:oracle:thin:@10.1.1.15:1521:nxtdb","NXTDB01","passwd!"
hello all,
I need some help regarding JDBC. At present I am using MSAccess as a
database and sun.jdbc.odbc.JdbcOdbcDriver driver. We are migrating to
Oracle database. now I need to change my servlet's code in order to work
with oracle database
My questions are
1. where can I download oracle.jdbc.driver.OracleDriver
2. What I need to configure in order to connect to oracle database.
Do i need to change my classpath or I need to download addition
library's.
Thanks
Tejas
Do You Yahoo!? Yahoo! Tax Center -
online filing with
TurboTax
|