Re: sql Connection.close() has already been called

2004-11-16 Thread Lorenzo Sicilia
Glenn Nielsen wrote: MySQL will by default close a db connection after it has been idle for 8 hours. You need to add the following to your jdbc connect url "?autoReconnect=true" to tell the MySQL JDBC driver to automatically reconnect to the db. Your url would be: jdbc:mysql://localhost:3306/mkterr

Re: sql Connection.close() has already been called

2004-11-15 Thread Glenn Nielsen
MySQL will by default close a db connection after it has been idle for 8 hours. You need to add the following to your jdbc connect url "?autoReconnect=true" to tell the MySQL JDBC driver to automatically reconnect to the db. Your url would be: jdbc:mysql://localhost:3306/mkterritoriale?autoReconn

Re: sql Connection.close() has already been called

2004-11-15 Thread Lorenzo Sicilia
Kris Schneider wrote: Do you have a context init param in web.xml for "javax.servlet.jsp.jstl.sql.dataSource"? If so, are you using a JNDI relative path or a JDBC parameters string? Yes, I have. In my web.xml javax.servlet.jsp.jstl.sql.dataSource mkterritoriale in my jrun-resource.xm

Re: sql Connection.close() has already been called

2004-11-15 Thread Kris Schneider
Do you have a context init param in web.xml for "javax.servlet.jsp.jstl.sql.dataSource"? If so, are you using a JNDI relative path or a JDBC parameters string? Which version of the Standard taglib (JSTL) are you using (1.0 or 1.1)? As an aside, attempting to close a connection that is already clos

Re: sql Connection.close() has already been called

2004-11-15 Thread Lorenzo Sicilia
Don Albertson wrote: Random as in it happens sometimes the first time or random as in it happens sometimes after sitting inactive long enough for some timeout value to close the connection? Random as in it happens sometimes. When it happens I need restart the application server (jrun4). The page i

Re: sql Connection.close() has already been called

2004-11-15 Thread Don Albertson
Lorenzo Sicilia wrote: Hi to all, I have a stange error in some index.jsp in two web site where I use sql tag. error: java.sql.SQLException: Connection.close() has already been called. Invalid operation in this state It's strange because I use only one tag sql in the page and the problem it's r

sql Connection.close() has already been called

2004-11-15 Thread Lorenzo Sicilia
Hi to all, I have a stange error in some index.jsp in two web site where I use sql tag. error: java.sql.SQLException: Connection.close() has already been called. Invalid operation in this state It's strange because I use only one tag sql in the page and the problem it's random. my snippets: