You are viewing a plain text version of this content. The canonical link for it is here.
Posted to apps-dev@avalon.apache.org by Song Chang <cs...@yahoo.com> on 2002/06/25 23:49:31 UTC

question on JdbcConnectionPool

Hi, fellows,

I have a question about using JdbcConnectionPool. Here
is some log show the problem:
DEBUG   2002-06-25 17:14:30.966 [datasour] (): Loading
new driver: oracle.jdbc.driver.OracleDriver
INFO    2002-06-25 17:14:32.573 [datasour] ():
DataSource default ready
DEBUG   2002-06-25 17:14:32.582 [datasour] ():
org.apache.avalon.excalibur.datasource.Jdbc3Connection:
could not be instantiated.
java.lang.IllegalMonitorStateException
        at java.lang.Object.wait(Native Method)
        at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:93)
        at
org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:136)
        at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(HardResourceLimitingPool.java:104)
        at
org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91)
        at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnectionPool.java:200)
        at java.lang.Thread.run(Thread.java:536)


It seems that if I use default min and max connection
pool number, it work fine. However if I use
<pool-controller min="1" max="10" timeout="10000"> in
the config file, I got the above exception. I tried to
play around with JdbcConnectionPool.java and inserted
synchronized before wait() and notify(), and it didn't
work. Any input will be highly appreciated.

SC

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: question on JdbcConnectionPool

Posted by Song Chang <cs...@yahoo.com>.
Peter,

Thanks for the hint. But chaning timeout to 1000 or 10
doesn't fix that problem. Originally I thought timeout
refers to closing a connection if it idles for a
timeout value.

Thanks.

Song
--- Peter Royal <pr...@apache.org> wrote:
> On Tuesday 25 June 2002 05:49 pm, Song Chang wrote:
> > It seems that if I use default min and max
> connection
> > pool number, it work fine. However if I use
> > <pool-controller min="1" max="10" timeout="10000">
> in
> 
> Why is the timeout set so high?
> -pete
> 
> 
> -- 
> peter royal -> proyal@apache.org
> 
> --
> To unsubscribe, e-mail:  
>
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> 


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: question on JdbcConnectionPool

Posted by Peter Royal <pr...@apache.org>.
On Tuesday 25 June 2002 05:49 pm, Song Chang wrote:
> It seems that if I use default min and max connection
> pool number, it work fine. However if I use
> <pool-controller min="1" max="10" timeout="10000"> in

Why is the timeout set so high?
-pete


-- 
peter royal -> proyal@apache.org

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>