Hello

I'm using Hibernate 2.1.8 and trying to connect to Postgre database from Jboss server.

How everafter some time of configuring it i get this:

as you can see the output below is looping so after showing me a number of this looped output it starts to show Postgre exception : Non-superuser connection limit exceeded which means that i just ran out of connections available. What might be the problem?

Thank you



00:12:47,140 INFO [STDOUT] Staring service!
00:12:47,296 INFO [Environment] Hibernate 2.1.8
00:12:47,312 INFO [Environment] loaded properties from resource hibernate.prope
rties: {hibernate.connection.driver_class=org.postgresql.Driver, hibernate.cglib
.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.hibernate.
cache.EhCacheProvider, hibernate.cache.use_query_cache=true, hibernate.max_fetch
_depth=1, hibernate.dialect=net.sf.hibernate.dialect.PostgreSQLDialect, hibernat
e.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query
.substitutions=yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.co
nnection.username=tvc-gw, hibernate.cache.region_prefix=hibernate.test, hibernat
e.connection.url=jdbc:postgresql://localhost/twc-gw, hibernate.connection.passwo
rd=tvc-gw, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_s
ize=20}
00:12:47,312 INFO [Environment] using java.io streams to persist binary types
00:12:47,312 INFO [Environment] using CGLIB reflection optimizer
00:12:47,312 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
00:12:47,343 INFO [Configuration] configuring from resource: /hibernate.cfg.xml

00:12:47,343 INFO [Configuration] Configuration resource: /hibernate.cfg.xml
00:12:48,125 INFO [Configuration] Mapping resource: ee/tovacom/smsgw/domain/Mes
sage.hbm.xml
00:12:48,312 INFO [Binder] Mapping class: ee.tovacom.smsgw.domain.Message -> me
ssage
00:12:48,531 INFO [Configuration] Configured SessionFactory: null
00:12:48,531 INFO [Configuration] processing one-to-many association mappings
00:12:48,531 INFO [Configuration] processing one-to-one association property re
ferences
00:12:48,531 INFO [Configuration] processing foreign key constraints
00:12:48,625 INFO [Dialect] Using dialect: net.sf.hibernate.dialect.PostgreSQLD
ialect
00:12:48,640 INFO [SettingsFactory] Maximim outer join fetch depth: 1
00:12:48,640 INFO [SettingsFactory] Use outer join fetching: true
00:12:48,671 INFO [DriverManagerConnectionProvider] Using Hibernate built-in co
nnection pool (not for production use!)
00:12:48,671 INFO [DriverManagerConnectionProvider] Hibernate connection pool s
ize: 20
00:12:48,687 INFO [DriverManagerConnectionProvider] using driver: org.postgresq
l.Driver at URL: jdbc:postgresql://localhost/tvc-gw
00:12:48,687 INFO [DriverManagerConnectionProvider] connection properties: {use
r=tvc-gw, password=tvc-gw}
00:12:48,703 INFO [TransactionManagerLookupFactory] instantiating TransactionMa
nagerLookup: net.sf.hibernate.transaction.JBossTransactionManagerLookup
00:12:48,718 INFO [TransactionManagerLookupFactory] instantiated TransactionMan
agerLookup
00:12:49,468 INFO [SettingsFactory] Use scrollable result sets: true
00:12:49,468 INFO [SettingsFactory] Use JDBC3 getGeneratedKeys(): false
00:12:49,468 INFO [SettingsFactory] Optimize cache for minimal puts: false
00:12:49,468 INFO [SettingsFactory] echoing all SQL to stdout
00:12:49,468 INFO [SettingsFactory] Query language substitutions: {no='N', yes=
'Y'}
00:12:49,468 INFO [SettingsFactory] cache provider: net.sf.hibernate.cache.EhCa
cheProvider
00:12:49,500 INFO [SettingsFactory] query cache factory: net.sf.hibernate.cache
.StandardQueryCacheFactory
00:12:49,500 INFO [Configuration] instantiating and configuring caches
00:12:49,546 WARN [Configurator] No configuration found. Configuring ehcache fr
om ehcache-failsafe.xml found in the classpath: jar:file:/C:/Program Files/jboss
-3.0.8/server/default/lib/ehcache-0.9.jar!/ehcache-failsafe.xml
00:12:49,906 INFO [SessionFactoryImpl] building session factory
00:12:50,296 INFO [Configuration] configuring from resource: /hibernate.cfg.xml