Arquivo Discussoes de Programacao e Tecnologia Caros Colegas
Temos uma aplicação desenvolvida com o struts, estamos usando o tomcat 5.0.25 e mysql.
A aplicação funciona normalmente, mas de um dia para o outro ela para de funcionar. mas se restartada funciona o o dia inteiro (mesmo acessando de tempos em tempos). alguem ja viu algo parecido?
Oi
Gilson_Anselmo, eu, inclusive ja li sobre isso aqui no Forum do PJ mesmo… Se eu não me engano é alguma configuração do Tomcat que faz isso…
Vou pesquisar, se eu achar, posto aqui.
T+
Valeu,
Justamente éssa é minha dúvida, será algumas configuração no Tomcat ou a aplicação não esta configurada corretamente (por exemplo struts-config.xml incorreto) …
gilson, tu ta usando connection pool pra acesar o MySQL ou ta fazendo direto a conexão?
A conexão é direta, a aplicação esta em teste em duas maquinas. E o extranho é que mesmo que niguem acesse a aplicaçao ela para de funcionar, durante o dia, após restartada a aplicação funciona normalmente no dia seguinte a aplicação precisa ser restartarda. ai fica dificil achar o problema.
Vou postar em um outro momento o log do tomcat para voces darem uma olhada. mas desde ja agradeço.
abraço
Na realidade, estou usando o padrão do struts
no struts-config:
data-sources
data-source
set-property property=“autoCommit” value=“true”/set-property
set-property property=“description” value=“RCPE Data Source
Configuration”/set-property
set-property property=“driverClass"
value=“org.gjt.mm.mysql.Driver”/set-property
set-property property=“maxCount” value=“4”/set-property>
set-property property=“minCount” value=“2”/set-property>
set-property property=“password” value=”"/set-property>
set-property property="url"
value=“jdbc:mysql://192.168.0.212/rcpe”/set-property
set-property property=“user” value=“epeople”/set-property
set-property property=“password” value=“rCpe”/set-property
data-source
data-sources
no action:
DataSource ds = getDataSource(request);
Connection con = ds.getConnection();
ih cara… eu não sei oq pode ser, realmente ta chato de descobrir oq é… se todas as noites a aplicação para de funcionar… bem, só vendo os logs do horário mesmo… :roll:
estou mandando somente uma parte do log e tem alguns comentários.
02/07/2004 17:10:42 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
*** Etapa 2: após o try
*** Etapa 3: após criar o stmt
*** Etapa 4: após setar o stmt
*** Etapa 5: após executar o query
*** Etapa 5: antes do finally
*** Etapa 6: fechando o rs
*** Etapa 6: fechando o stmt *******{ate aqui ok }
02/07/2004 17:10:42 org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
02/07/2004 17:10:42 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
02/07/2004 17:10:42 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=0
02/07/2004 17:10:42 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
02/07/2004 17:10:42 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
02/07/2004 17:10:42 org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
02/07/2004 17:10:49 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.logic.LocalStrings’, returnNull=true
*** Etapa 1: construtor
03/07/2004 10:31:55 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
03/07/2004 10:31:55 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=0
03/07/2004 10:31:55 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
03/07/2004 10:31:55 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
*** Etapa 2: após o try
*** Etapa 3: após criar o stmt
*** Etapa 4: após setar o stmt
***java.lang.NullPointerException ********{aqui ja deu pau}
at rcpe.db.LogonDAO.getUser(LogonDAO.java:46)
at rcpe.actions.LogonAction.execute(LogonAction.java:22)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
at java.lang.Thread.run(Thread.java:534)
03/07/2004 10:31:55 org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
03/07/2004 10:48:27 org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started ******{aplicacao restartada}
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=0
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=1, useCount=1
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=1, useCount=2
03/07/2004 10:48:27 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.util.LocalStrings’, returnNull=true
03/07/2004 10:48:27 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.action.ActionResources’, returnNull=true
03/07/2004 10:48:27 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘resources.application’, returnNull=true
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource createConnection
INFO: createConnection()
03/07/2004 10:48:27 org.apache.struts.legacy.GenericDataSource createConnection
INFO: createConnection()
03/07/2004 10:48:28 org.apache.struts.tiles.TilesPlugin init
INFO: Tiles definition factory loaded for module ‘’.
03/07/2004 10:48:28 org.apache.struts.validator.ValidatorPlugIn initResources
INFO: Loading validation rules file from '/WEB-INF/validator-rules.xml’
03/07/2004 10:48:28 org.apache.struts.validator.ValidatorPlugIn initResources
INFO: Loading validation rules file from '/WEB-INF/validation.xml’
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.logic.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.tiles.TilesRequestProcessor initDefinitionsMapping
INFO: Tiles definition factory found for request processor ‘’.
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.actions.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.util.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:31 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
*** Etapa 1: construtor
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=0
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
*** Etapa 2: após o try
*** Etapa 3: após criar o stmt
*** Etapa 4: após setar o stmt
*** Etapa 5: após executar o query
*** Etapa 5: antes do finally
*** Etapa 6: fechando o rs
*** Etapa 6: fechando o stmt ***** {ai conecta normalmente}
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=0
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
03/07/2004 10:48:41 org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
03/07/2004 10:48:41 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.bean.LocalStrings’, returnNull=true
03/07/2004 10:48:41 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:41 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:41 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.html.LocalStrings’, returnNull=true
03/07/2004 10:48:41 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.bean.LocalStrings’, returnNull=true
03/07/2004 10:48:41 org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config=‘org.apache.struts.taglib.logic.LocalStrings’, returnNull=true
03/07/2004 10:48:45 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
03/07/2004 10:48:45 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=0
03/07/2004 10:48:45 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
03/07/2004 10:48:45 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=2, useCount=1
03/07/2004 10:48:45 org.apache.struts.legacy.GenericDataSource returnConnection
INFO: releaseConnection(), activeCount=2, useCount=0
esse erro ta relacionado a conexão com o banco… ta usando DataSource né? …pode postar pra gente teu código de conexão referente ao DAO? é Tomcat ou JBoss?
Sim estou usando Datasource e o servidor é o tomcat 5
segue
import java.util.*;
import java.sql.*;
import rcpe.forms.*;
public class LogonDAO extends DAO{
private final String SQL_PATH = "resources/sql_logon.properties";
private Properties sql;
public LogonDAO(){
try{
sql = new Properties();
sql.load(this.getClass().getClassLoader().getResourceAsStream(SQL_PATH));
}catch (Exception e){
System.out.println("Err:" + e.toString());
}
}
public UserForm getUser(String username){
UserForm user = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try{
stmt = con.prepareStatement(sql.getProperty("select.authentication"));
stmt.setString(1,username);
rs = stmt.executeQuery();
if (rs.next()){
user = new UserForm();
user.setId_contato(rs.getString(sql.getProperty("field.id_contato")));
user.setNm_contato(rs.getString(sql.getProperty("field.nm_contato")));
user.setEmail(rs.getString(sql.getProperty("field.email")));
user.setNm_senha(rs.getString(sql.getProperty("field.nm_senha")));
user.setId_tipo(rs.getString(sql.getProperty("field.id_tipo")));
}
}catch (Exception e){
System.out.println("Err:" + e.toString());
}finally{
try{
stmt.close();
rs.close();
//con.close();
}catch (SQLException e){
System.out.println("Err:" + e.toString());
}
}
return user;
}
public static LogonDAO getInstance(){
if (instance == null){
instance = new LogonDAO();
}
return (LogonDAO)instance;
}
***********************
classe DAO
import java.sql.*;
/**
* @author Administrator
*
* To change the template for this generated type comment go to
* Window - Preferences - Java - Code Generation - Code and Comments
*/
public abstract class DAO {
protected Connection con;
protected static DAO instance;
/**
* @return Returns the con.
*/
public Connection getConnection() {
return con;
}
/**
* @param con The con to set.
*/
public void setConnection(Connection con) {
this.con = con;
}
}
[color="green"][size="11"]Mantenha seu código mais claro para os outros usuários usando a tag CODE - matheus[/size][/color]
o exemplo de datasource q trabalho com Tomcat 5 é diferente, bem.. primeiro eu edito o server.xml do Tomcat, colocando o seguinte conteúdo dentro de <GlobalNamingResources>:
<Resource name="jdbc/PostgresDS" auth="Container" type="javax.sql.DataSource" />
<ResourceParams name="jdbc/PostgresDS">
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>
<parameter><name>driverClassName</name><value>org.postgresql.Driver</value></parameter>
<parameter><name>url</name><value>jdbc:postgresql://192.168.17.5:5432/bancoDeDados</value></parameter>
<parameter><name>username</name><value>postgres</value></parameter>
<parameter><name>password</name><value>postgres</value></parameter>
<parameter><name>maxActive</name><value>20</value></parameter>
<parameter><name>maxIdle</name><value>10</value></parameter>
<parameter><name>maxWait</name><value>100</value></parameter>
</ResourceParams>
q é a configuração do DS, ai dentro da tag <Host> do mesmo arquivo eu coloco o contexto da app:
<Context path="/Postgres" docBase="C:\eclipse\workspace\testeDao" debug="1">
<!-- Link to the user database we will get roles from -->
<ResourceLink name="jdbc/PostgresDS" global="jdbc/PostgresDS" />
</Context>
e no código do DAO eu acho o DataSource assim:
InitialContext context = new InitialContext();
Context ctx = (Context) context.lookup("java:comp/env/");
DataSource dataSource = (javax.sql.DataSource)ctx.lookup("jdbc/PostgresDS");
ai a cada q a camada cliente usa um método do DAO, ele chama uma conexão com o banco do DataSource... executa o método, e devolve a conexão pro pool, bem, nao respondi tua duvida né.. é q não reconheci teu código... eu uso bem diferente... :roll:
Colegas
depois de tanto bater a cabeça, optamos por substituir o banco mysql pelo postgresql, pois encontramos em alguns foruns de discussão varios usuários relatando o mesmo problema com o mysql. Como nós ja haviá-mos atualizado a versao do mysql e o problema continuou, decidimos substituir o banco, o que de cara resolveu nosso problema.
valeu