Simple-JNDI Connection Pooling - Connection limit exceeded error

20 views
Skip to first unread message

hide

unread,
Nov 27, 2009, 11:11:10 AM11/27/09
to osjava
Hi there,

I've been trying to setup connection pooling using simple-jndi in our
application, and each time I execute, I get an error message: FATAL:
connection limit exceeded for non-superusers.

I've checked the settings on my database server and there are 100
connections per user. I've set the dbcpMaxActive property to 8, but it
doesn't seem to have an affect. I still get the error message and
failure.

I'm using simple-jndi 11.4.1 and below is the ds.properties file
contents:

db.type=javax.sql.DataSource
db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://localhost:5432/test
db.user=test
db.password=blah
db.pool=pool
db.dbcpMaxActive=8
db.dbcpMaxIdle=8
db.dbcpMinIdle=2
db.dbcpValidationQuery=SELECT 1
db.dbcpTestOnBorrow=true

I've been through the source code and haven't been able to find what
I'm doing wrong.

Thank you

~Shawn
Reply all
Reply to author
Forward
0 new messages