HI all
I am connecting oracle 10g DB through my java program for my project ...people advicing me to use connection pooling where it recommemnds for the reuse of resources..
DriverManager.r egisterDriver(n ew oracle.jdbc.dri ver.OracleDrive r());
con = DriverManager.g etConnection("j dbc:oracle:thin :@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(LOAD_BAL ANCE = yes)(CONNECT_DA TA =(SERVER = DEDICATED)(SERV ICE_NAME = orcl)(FAILOVER_ MODE=(TYPE=sele ct)(METHOD=basi c))))","name", "pwd");
stmt = con.createState ment(ResultSet. TYPE_SCROLL_INS ENSITIVE, ResultSet.CONCU R_READ_ONLY);
This is how i connect DB ....
I am using Tomcat as my web Server...
thanx in advance
I am connecting oracle 10g DB through my java program for my project ...people advicing me to use connection pooling where it recommemnds for the reuse of resources..
DriverManager.r egisterDriver(n ew oracle.jdbc.dri ver.OracleDrive r());
con = DriverManager.g etConnection("j dbc:oracle:thin :@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(LOAD_BAL ANCE = yes)(CONNECT_DA TA =(SERVER = DEDICATED)(SERV ICE_NAME = orcl)(FAILOVER_ MODE=(TYPE=sele ct)(METHOD=basi c))))","name", "pwd");
stmt = con.createState ment(ResultSet. TYPE_SCROLL_INS ENSITIVE, ResultSet.CONCU R_READ_ONLY);
This is how i connect DB ....
I am using Tomcat as my web Server...
thanx in advance