Hi all,

I have looked everywhere for an answer....
Any help would ... help

followed the instructions from
http://www.thep.lu.se/~nicklas/base2/download/mysql_example4.zip

instaled the DBPool.jar ect
I lauched the ConnectionPool.java program all seemed good.

Now to simulate 2 users I ran it from 2 different dos prompt
looping in 100's of queries.

Somehow it seems to always create 2 different pools
instead of 2 connections (Initialized pool BaseDB twice)
see the logs and code below.
Did I forget something? Could it be a class loader problem
as the pool is I believe a singleton.

Thanks for any help

Fred,
London

Thu Jun 10 13:18:26 BST 2004: Already using JDBC driver com.mysql.jdbc.Driver
Thu Jun 10 13:18:26 BST 2004: Initialized pool BaseDB (pool=10,max=10,expiry=none)
Thu Jun 10 13:18:26 BST 2004: BaseDB: Created a new connection
Thu Jun 10 13:18:28 BST 2004: Already using JDBC driver com.mysql.jdbc.Driver
Thu Jun 10 13:18:28 BST 2004: Initialized pool BaseDB (pool=10,max=10,expiry=none)
Thu Jun 10 13:18:28 BST 2004: BaseDB: Created a new connection
Thu Jun 10 13:19:32 BST 2004: BaseDB: Destroyed connection
Thu Jun 10 13:19:41 BST 2004: BaseDB: Destroyed connection

code used

import java.io.*;
import java.util.*;
import snaq.db.*;

public class TimeDBPool
{
    public static void main( String args[] )
  {
        if (args.length == 0)
        {
            System.out.println("Please run with: java TimeDBPool 1 | 2 | 3 | 4");
            return;
        }
        try
        {

            // Open a properties file where connection info is stored
            FileInputStream infile = new FileInputStream( "dbpool.properties" );
            Properties props = new Properties();
            props.load(infile);

            // Connection info for MySQL
            String url = props.getProperty("BaseDB.url", "jdbc:mysql://localhost/base");
            String user = props.getProperty("BaseDB.user", "baseuser");
            String password = props.getProperty("BaseDB.password", "");
            String cs = url+"?user="+user+"&password="+password;

            // The SQL statement to execute
            //String sql = "SELECT * FROM customers ORDER BY Account_nb";
            String sql = "select * from customers";
           
           

            // Define useful objects and variables
            java.sql.Connection conn;
            java.sql.Statement stat;
            java.sql.ResultSet rs;
            long s1;
            long s2;
            int i;
            int ntries = 100;

            // Register MySQL driver
            Class.forName("com.mysql.jdbc.Driver").newInstance();

            // Open the connection manager
            ConnectionPoolManager conMgr = ConnectionPoolManager.getInstance();
           
           

            // Test 1: DriverManager with open() and close()
            if (args[0].equals("1"))
            {
                s1 = new Date().getTime();
                for(i = 0; i<= ntries; i++)
                {
                    conn = java.sql.DriverManager.getConnection(cs);
                    conn.close();
                }
                s2 = new Date().getTime();
                System.out.println("Test 1: "+(s2 - s1)+" milliseconds");
            }

            // Test 2: DriverManager with open(), select() and close()
            if (args[0].equals("2"))
            {
                s1 = new Date().getTime();
                for(i = 0; i<= ntries; i++)
                {
                    conn = java.sql.DriverManager.getConnection(cs);
                    stat = conn.createStatement();
                    rs = stat.executeQuery(sql);
                    rs.close();
                    stat.close();
                    conn.close();
                }
                s2 = new Date().getTime();
                System.out.println("Test 2: "+(s2 - s1)+" milliseconds");
            }

            // Test 3: DBPool with open() and close()
            if (args[0].equals("3"))
            {
                s1 = new Date().getTime();
                for(i = 0; i<= ntries; i++)
                {
                    conn = conMgr.getConnection("BaseDB");
                    conn.close();
                }
                s2 = new Date().getTime();
                System.out.println("Test 3: "+(s2 - s1)+" milliseconds");
            }

            // Test 4: DBPool with open(), select() and close()
            if (args[0].equals("4"))
            {
                s1 = new Date().getTime();
                for(i = 0; i<= ntries; i++)
                {
                    conn = conMgr.getConnection("BaseDB");
                    stat = conn.createStatement();
                    rs = stat.executeQuery(sql);
                    rs.close();
                    stat.close();
                    conn.close();
                }
                s2 = new Date().getTime();
                System.out.println("Test 4: "+(s2 - s1)+" milliseconds");
            }

            conMgr.release();
        }
        catch (Exception ex)
        {
            System.out.println( "An exception has been intercepted" );
            ex.printStackTrace();
        }
    }
}