Connection Pooling java.sql.Connection?

[deadend5001]

I am trying to connection pool a AS400 JDBC Connection. Have been trying to find a good tutorial but have yet to find one.

Basically right now for each user I am creating a connection (example below). I would like to get a pool of these types of connections that expands when necissary, and contracts say after 30 minutes.

public static java.sql.Connection getApplicationSecurityConnection() {
 String description = "Connection to the Application Security Database";
 //String driver = "com.inet.tds.TdsDriver";
 //String protocol = "inetdae";
 //String serverDNS = "localhost";
 //String port = "1433";
 //String instance = "";
 //String database = "APP_SECURITY";
 //String user = "security";
 //String password = "ssSetjESN5sgve6jQdNM8BTra";

 String driver = "com.ibm.as400.access.AS400JDBCDriver";
 String protocol = "";
 String serverDNS = "";
 String port = "";
 String instance = "";
 String database = "";
 String user = "CPSERVER";
 String password = "CPPROFILE";



 java.sql.Connection conn = null;
 try {
 // make sure DriverManager can load proper class to establish connection
 Class.forName(driver);
 String URL = "jdbc:" + protocol + ":" + serverDNS;
 Properties DBProperties = new Properties();
 if (!port.equals("")){
 DBProperties.setProperty("port",port);
 }
 if (!instance.equals("")){
 DBProperties.setProperty("instance",instance);
 }
 if (!database.equals("")){
 DBProperties.setProperty("database",database);
 }
 if (!user.equals("")){
 DBProperties.setProperty("user",user);
 }
 if (!password.equals("")){
 DBProperties.setProperty("password",password);
 }
 if(!getApplicationName().equals("")){
 DBProperties.setProperty("appname",getApplicationName());
 }
 conn = DriverManager.getConnection(URL,DBProperties);
 if (conn == null){
 throw new Exception("getDATAConnection(String, String): Unspecified error occured.");
 }
 } catch (Exception e) {
 System.out.println("\n\n*******************************************************");
 System.out.println("CONNECTION ERROR!!!!");
 System.out.println("DESCRIPTION: " + description);
 System.out.println("ERROR: " + e.getMessage());
 System.out.println("\n\n*******************************************************");
 e.printStackTrace();
 }
 return conn;
 }

any help us MUCH appreciated

[peterj]

Define a *-ds.xml file for your database and place it in the deploy directory. There is a BD2/as400 example *-ds.xml file at ./docs/examples/jca/db2-400-ds.xml that you can use as a starting point. Then in your code look up the datasource using JNDI. JBoss will automatically pool the connections based on the settings in *-ds.xml.

[deadend5001]

How would you lookup the connection with context? Example Source?

[peterj]

Assume that in *-ds.xml I have:

<jndi-name>ds/SomeDS</jndi-name>

then in my code I would look it up using:

InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:ds/SomeDS");
Connection conn = ds.getConnection();