hide
unread,Nov 27, 2009, 11:11:10 AM11/27/09Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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