|
According to the "Oracle 9i DBA Handbook" (Oracle Press, 2002), p. 20,
you can set the timeout length for the pool.
Mark
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
|
