JDBC Connection Pooling

[Erik Ekote]

Hello, I want to access a db using properties object(connection pooling I think). Is there any one here who could give me an example how to do this? The reason why I want to do this is because the JDBC code should not be tempered with any time some one comes new. One just have to change the logon properties (basically the userid and pwd)in an external file.Below is the code.

import java.sql.*;
 
public class Sqltest {
 
public static void main(String[] args) {
 
Connection con = null;
Statement stmt = null;
ResultSet re = null;
//Properties logon; was just experimenting
 
try {
Class.forName("oracle.jdbc.driver.OracleDriver"); 
/* The line below is to be changed I think*/
con = DriverManager.getConnection 
("jdbc :-o	 racle:thin:@50.119.78.7:1521:test_db","testid","test"); 
stmt = con.createStatement ();
 ResultSet rs = stmt.executeQuery("SELECT test1, test2, test3, test4, test5 FROM testdb);

//Print the result out.
while (rs.next()) { 
for (int i = 1; i <= 5 ; i++){
System.out.print(rs.getString(i) + '\t');
}
  System.out.println();
}
} catch(Exception e) {
e.printStackTrace();
} finally {
try
{
if(stmt != null) stmt.close();
if(con != null) con.close();  

} catch (Exception exception) {
exception.printStackTrace();
}
}
}
}

[Jeanne Boyarsky]

Erik,
Welcome to JavaRanch!

You can create a Properties file by calling its load() method. Then you can use the getters to get the individual properties instead of hardcoding them in the connection request.

Note that this is not connection pooling. Connection pooling gets a connection from a datasource on an application server (or other pool.) Also, I don't see where you close the resultset.