Spring Connection Pooling
Can someone tell me or point me to a document/tutorial that explains the usage of Spring Connection Pool Datasource? ...
connectionpool
How can I configure hibernate to use context-specific connection information?
I'm writing a J2SE (Note, not JEE) application using Hibernate, and I need to provide a different connection to Hibernate for each thread of execution. These connections must be pooled, and each one has at the very least different authentication and, possibly, a different JDBC URL. The connections will be re-used (as can be inferred fr...
Why so many sp_resetconnections for C# connection pooling?
We have a web service coded in C# that makes many calls to MS SQL Server 2005 database. The code uses Using blocks combined with C#'s connection pooling. During a SQL trace, we saw many, many calls to "sp_resetconnection". Most of these are short < 0.5 sec, however sometimes we get calls lasting as much as 9 seconds. From what I've r...
SubSonic 3.0.0.3 t4 template generation on lage database runs out of connections
When running the templates against a database with 1400+ tables I get the following error. The server shows hundreds of connections. Does anyone know if this is a problem with template generation in general, or with these templates specifically. Other, smaller DBs generate ok for me. Running transformation: System.InvalidOperationExce...
ADO.NET SqlData Client connections never go away
An asp.net application I am working on may have a couple hundred users trying to connect. We get an error that the maximum number of connections in the pool has been reached. I understand the concept of connection pools in ADO.NET although in testing I've found that a connection is left "sleeping" on the ms sql 2005 server days after the...
How to configure a connection pool to access a Postgis database ?
Hello I am using Glassfish v2, Hibernate with Annotations+EntityManager and Postgresql 8.4. I am also using on top HibernateSpatial and PostGis. It works fine to persist entities with spatial properties ( com.vividsolutions.jts.geom.Point ) into the Postgis database. However, when trying to fetch objects using myEntityManager.find(MyCl...
Oracle connection error using Tomcat
I am using Eclipse Galileo and Tomcat 6.0. I am getting an error like this: 2010-08-17 00:09:42,684,JDBCExceptionReporter,WARN,,SQL Error: 0, SQLState: null 2010-08-17 00:09:42,684,JDBCExceptionReporter,ERROR,,Cannot create PoolableConnectionFactory (ORA-01033: ORACLE initialization or shutdown in progress ) 2010-08-17 00:09:42,684,Sett...