For the record: The problem was (predictably) my code; I was missing a line that should have stored the SessionFactory in the servlet context - every attempt to obtain a session was obtaining a new factory, and hence a new connection pool.
Thanks for the help all, jim On Sat, Jan 04, 2003 at 10:18:29AM +1100, One Ovthafew wrote: > > I have never seen this problem (I test with Postgres 7.3 running under > cygwin), but I imagine that it is to do with how you have configured > connection pooling. You can set > > hibernate.connection.pool_size=0 > > to disable pooling, if you like, or try out Juozas' suggestion and use a > different pooling implementation. > > I do not think this is related to Matt Raible's problem, unless you are > also opening multiple Sessions per transaction (which is a very very bad > antipattern). > > Note that you can always bypass Hibernate's Connection and Transaction > handling _altogether_, if you have persistent problems.... > > s = sf.openSession( getMyJDBCConnection() ); > // do some work > s.connection().commit(); > closeMyJDBCConnection( s.close() ); > > That way you can be CERTAIN that Hibernate is not to blame when you see > these kinds of issues. > > > Hi all, > > > > I have a problem with hibernate and postgresql that I suspect might be > > related to Matt Raible's Oracle problems. Every time hibernate does > > it's stuff to update the database, postgres spawns another "idle in > > transaction" process. Eventually it gives up and the driver throws: - > > > > Backend start-up failed: FATAL 1: Sorry, too many clients already > > > > at > org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:306) > > at org.postgresql.Driver.connect(Driver.java:122) > > at java.sql.DriverManager.getConnection(DriverManager.java:512) > > at java.sql.DriverManager.getConnection(DriverManager.java:140) > > at > cirrus.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:81) > > > > --------------------------------------------------------------------- > NEW to mBox, receive faxes to any email address! > Find out more http://www.mbox.com.au/fax > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
