Olá Anderson.
Eu e Felipe somos parceiros, veja só:
Nossa aplicação realmente está muito restrita na Locaweb, meu contexto e datasource ao máximo está conforme abaixo, e não podemos modificá-lo:
maxActive=8 e maxIdle=8 está baixo concorda?
…<maxActive=“8” maxIdle=“8” maxWait=“10000” removeAbandoned=“true” removeAbandonedTimeout=“15” logAbandoned=“true” />
<Service name=“Tomcat-Standalone”>
<Connector port=“8061” address="127.0.0.1"
maxThreads=“512” minSpareThreads=“15” maxSpareThreads="75"
enableLookups=“false” redirectPort=“443” debug=“0” maxKeepAliveRequests=“1” connectionTimeout="10000"
acceptCount=“100” protocol=“AJP/1.3” />
<!-- An Engine represents the entry point (within Catalina) that processes
every request. The Engine implementation for Tomcat stand alone
analyzes the HTTP headers included with the request, and passes them
on to the appropriate Host (virtual host). -->
<!-- Define the top level container in our container hierarchy -->
<Engine name="Standalone" defaultHost="localhost" debug="0">
<Valve className="br.com.locaweb.tomcat.LocaWebValve" arquivo="/var/log/java/ecocentro2/ecocentro2.log" />
<!-- Realm className="org.apache.catalina.realm.UserDatabaseRealm"
debug="0" resourceName="UserDatabase"/ -->
<Host name="ecocentro2.tempsite.ws">
<Alias>ecocentro.org</Alias>
<Alias>suacasasustentavel.com.br</Alias>
<Alias>www.suacasasustentavel.com.br</Alias>
<Alias>suacasasustentavel.com</Alias>
<Alias>www.suacasasustentavel.com</Alias>
<Alias>casasustentavel.com.br</Alias>
<Alias>www.casasustentavel.com.br</Alias>
<Alias>casasustentavel.com</Alias>
<Alias>www.casasustentavel.com</Alias>
<Alias>ecocentro2.locaweb.com.br</Alias>
<Alias>www.ecocentro.org</Alias>
<Alias>wap.ecocentro.org</Alias>
<Context path="" docBase="/home/ecocentro2/public_html/" debug="0" crossContext="false" reloadable="false" workDir="/home/ecocentro2/tomcat/work/">
<Resource name="jdbc/ecocentro2" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" username="ecocentro2" password="XXXXXX" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://hm405.locaweb.com.br:5432/ecocentro2" maxActive="8" maxIdle="8" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="15" logAbandoned="true" />
<Realm className="org.apache.catalina.realm.DataSourceRealm" dataSourceName="jdbc/ecocentro2" localDataSource="true" userTable="ca_usuario_pessoa" userNameCol="nomelogin" userCredCol="senha" userRoleTable="ca_usuario_role" roleNameCol="roleid" debug="99"/>
</Context>
<Context path="/teste" docBase="/home/ecocentro2/public_html/teste/" debug="0" crossContext="false" reloadable="false" workDir="/home/ecocentro2/tomcat/work/teste/"/>
</Host>
</Engine>
</Service>
Este são os erros gerados:
2007-05-28 00:04:35,126 [TP-Processor9] ERROR org.hibernate.util.JDBCExceptionReporter - Connection is closed.
2007-05-28 00:04:35,164 [TP-Processor9] ERROR org.hibernate.util.JDBCExceptionReporter - Connection is closed.
2007-05-28 00:04:35,165 [TP-Processor9] ERROR org.hibernate.util.JDBCExceptionReporter - Connection is closed.
2007-05-28 00:04:35,165 [TP-Processor9] ERROR org.apache.catalina.core.ContainerBase.[Standalone].[ecocentro2.tempsite.ws].[/].[action] - Servlet.service() for servlet action threw exception
org.hibernate.exception.GenericJDBCException: could not inspect JDBC autocommit mode
Caused by: java.sql.SQLException: Connection is closed.
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:291)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.getAutoCommit(DelegatingConnection.java:241)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getAutoCommit(PoolingDataSource.java:221)
at org.hibernate.jdbc.ConnectionManager.isAutoCommit(ConnectionManager.java:128)
at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:328)
… 36 more
