devnulled: A stream for software developers and engineers

Just a quick note in case someone else is looking for more information about this error. A server in our cluster kept randomly throwing this error, and it took me awhile to figure out what the problem was:

Error Occurred While Processing Request
Can’t find resource for base name coldfusion/server/j2ee/sql/pool/JDBCPool.ConnectionCreationException.properties

This is on a server using the Microsoft JDBC drivers for SQL Server, but I assume it could happen on other drivers as well. Essentially the ‘Limit Connections’ box was checked on one of the databases, thereby creating this error when it ran out of connections to use when under load. Googling for this error brings-up nothing, so hopefully that will change soon.

It looks like this happened a couple of weeks ago, but Microsoft has released SQL Server 2000 Driver for JDBC SP3.

I haven’t tried them out yet myself, but will be load testing them on a box soon which seems to have some JDBC problems under load.