Problem creating/using JdbcConnectionPool

[Philip Antoniades]

hello,

I've read about all the docs I can get my hands on, and i suspect i 
still dont get how to properly deploy Components through avalon. But why 
does this code:

        JdbcConnectionFactory fac = new JdbcConnectionFactory( 
"jdbc:postgresql:myDB",
                   "fooser",
                   "barword",
                   true,
                   false);

        JdbcConnectionPool pool = new JdbcConnectionPool( fac, new 
DefaultPoolController(),
                                  1, 10, true );
        pool.initialize();

        pool.run();

        System.out.println( "Initialized, running..." );

        db = (JdbcConnection)pool.get();

have this output:

Initialized, running...

java.lang.IllegalStateException: You cannot get a Poolable before the 
pool is initialized
    at 
org.apache.avalon.excalibur.pool.DefaultPool.get(DefaultPool.java:107)
    at 
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnectionPool.java:70)
    at testing.DbPoolingTest.run(DbPoolingTest.java:35)

any help or further docs appreciated.




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]