tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vincent Aumont <vincent.aum...@vsl.ca>
Subject Re: Connection timeout Problem
Date Thu, 13 Nov 2003 03:14:43 GMT
MySQL drops the connection after a certain period of inactivity. Just 
add autoReconnect=true to you jdbc url:
E.g. jdbc:mysql://localhost:3306/mydb?autoReconnect=true

-Vincent.
Gary Lee wrote:

>My tomcat 4.1.27 connects to mysql thu. jdbc driver.
>If I keep some connections overnite, i found they all got lost in the next
>morning, and hence my tomcat need to restart.
>
>does anybody has some hint?
>
>Thanks
>
>
>----- Original Message -----
>From: Veselin Kovacevic <veso@promonte.com>
>To: Tomcat Users List <tomcat-user@jakarta.apache.org>
>Sent: Wednesday, November 12, 2003 4:17 PM
>Subject: RE: Problem with ConnectionPool on Linux
>
>
>You think DBCP 1.1?
>I try to install Tomcat 4.1.29 but I get some error with connection
>pool.
>Is there some changes in server.xml settings?
>
>-----Original Message-----
>From: Kwok Peng Tuck [mailto:pengtuck@makmal.net]
>Sent: Wednesday, November 12, 2003 9:13 AM
>To: Tomcat Users List
>Subject: Re: Problem with ConnectionPool on Linux
>
>
>The new version of DBCP should be able to cope with this as well. I
>tested it with MaxDB and it works ok.
>
>Veselin Kovacevic wrote:
>
>  
>
>>Now, everything working fine. :)
>>
>>Thanks Jon.
>>
>>
>>
>>
>>-----Original Message-----
>>From: Jon Wingfield [mailto:jon.wingfield@mkodo.com]
>>Sent: Tuesday, November 11, 2003 4:50 PM
>>To: Tomcat Users List
>>Subject: Re: Problem with ConnectionPool on Linux
>>
>>
>>MySql times out idle connections. If your pool implementation doesn't
>>take care of weeding out dead connections you need to add
>>autoReconnect=true to your connection string.
>>
>>HTH,
>>
>>Jon
>>
>>Veselin Kovacevic wrote:
>>
>>
>>
>>    
>>
>>>Hi,
>>>
>>>I have o problem with Tomcat 4.1.24 on SuseLinux7.3. Our application
>>>has Controller servlet (below) where using connection objects from
>>>connection pool. When tomcat started, application working fine and
>>>everything OK that day. But next day when we try to start application
>>>we get error message in isUser method (PortalUserDB class). It's first
>>>
>>>
>>>      
>>>
>>
>>    
>>
>>>place where we use connection object in application. Method isUser is
>>>very simple method for authenticate user (below). We get this
>>>exception: SQL Exception:java.sql.SQLException: No operations allowed
>>>after connection closed
>>>
>>>Connection object is not null in this case, and this message for me is
>>>
>>>
>>>      
>>>
>>
>>    
>>
>>>not correct. Next, if I restart tomcat, everything working ok... (for
>>>next day).
>>>
>>>On windows (we using windows for development platform) we have not
>>>this problem.
>>>
>>>What is problem?
>>>Is configuration server.xml or similar configuration files on Linux
>>>different rather on windows?
>>>
>>>Note:
>>>On both platform we using Tomcat 4.1.24 and j2sdk1.4.1_03.
>>>
>>>
>>>public class Controller extends HttpServlet {
>>>
>>>private DataSource ds;
>>>
>>>public void init(ServletConfig config) throws ServletException {
>>>super.init(config);
>>>try {
>>>InitialContext initCtx = new InitialContext();
>>>Context envCtx =
>>>(Context)initCtx.lookup("java:comp/env");
>>>ds =
>>>(DataSource)envCtx.lookup("jdbc/MySQLPool");
>>>} catch (Exception e){
>>>throw new UnavailableException(e.getMessage());
>>>}
>>>}
>>>
>>>public void doGet(HttpServletRequest request,
>>>
>>>
>>>      
>>>
>>HttpServletResponse
>>
>>
>>    
>>
>>>response)
>>>  throws IOException,
>>>ServletException {
>>>
>>>request.setCharacterEncoding("iso-8859-2");
>>>
>>>........................
>>>........................
>>>
>>>if (ds != null) {
>>>Connection conn = ds.getConnection();
>>>if (conn != null) {
>>>boolean isUserExists =
>>>PortalUserDB.isUser(conn, userName, userPass);
>>>........................
>>>........................
>>>conn.close();
>>>}
>>>........................
>>>........................
>>>
>>>}
>>>}
>>>
>>>public static boolean isUser(Connection conn, String userName, String
>>>userPass)
>>>throws SQLException, IOException {
>>>
>>>String query = "SELECT user_name FROM admin_user " +
>>>   "WHERE user_name = ? " +
>>>   "AND user_pass = ?";
>>>
>>>boolean isUserExists = false;
>>>
>>>try {
>>>PreparedStatement pstmt = conn.prepareStatement(query);
>>>pstmt.setString(1, userName);
>>>pstmt.setString(2, userPass);
>>>
>>>ResultSet rs = pstmt.executeQuery();
>>>
>>>isUserExists = rs.next();
>>>
>>>rs.close();
>>>rs = null;
>>>pstmt.close();
>>>pstmt = null;
>>>
>>>} catch (SQLException sqle) {
>>>PortalLog.addLogLine("Class: PortalUserDB, Method:
>>>isUser. SQL Exception:" + sqle, userName);
>>>}
>>>
>>>return isUserExists;
>>>}
>>>
>>>Thanks,
>>>Veso
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>>
>>>
>>>
>>>
>>>      
>>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>
>>
>>
>>
>>    
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>  
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message