[jboss-user] [Beginners Corner] - Connection Pooling java.sql.Connection?
deadend5001
do-not-reply at jboss.com
Fri Dec 15 16:38:24 EST 2006
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
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3994347#3994347
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3994347
More information about the jboss-user
mailing list