Hi
I have a problem with my resin server. It is very unstable and tends to
loose persistence(?). What happens is that database connection is ok for a
while, but as soon as I change a class, or a jsp, it throws the error
mentioned below. What I do is delete all the *.jsp and *.class files form
the WEB-INF/work directory and the files/folders form the WEB-INF/session
directory, restart resin, and everything is ok again. Runs for a while and
then it crashes. All my JSP uses a Java bean that implements the
java.io.Serializable interface.
Here is my configuration:
Win2k Professional edition
Resin-2.1.0
Apache 1.3 Web Server.
Listed below is the stack trace which is displayed in the stderr log file.
What really happens is that the ConnectionPool class fails to initialise
and in effect a connection object is not released from the connection pool.
I have also include after the stack trace some of my resin.conf settings
for arguments
sake.
I am not sure what is causing this. If anyone has any ideas please help.
TIA
Patrick
public Connection createConnection () {
Connection con = null;
System.out.println("user::createConnection initialise is
"+String.valueOf(initialise));
if (!initialise) {
DbPool.initialise(className,url,name,password,dbMinConn,dbMaxConn);
initialise=true;
}
try {
con = DbPool.getInstance().getConnection();
}
catch (SQLException se) {
System.err.println("SQLException found in User:createConnection
"+se.getMessage());
se.printStackTrace();
}
return con;
}//end of createConnection Method
Connection Pool is null.. initialising pool now
java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:130)
at ConnectionPool.<init>(ConnectionPool.java:32)
at DbPool.getInstance(DbPool.java:64)
at User.closeDB(User.java:1969)
at User.getOneResultwithConditions(User.java:761)
at _browsingtopics__jsp._jspService(_browsingtopics__jsp.java:243)
at com.caucho.jsp.JavaPage.service(JavaPage.java:74)
at com.caucho.jsp.Page.subservice(Page.java:485)
at
com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:181)
at com.caucho.server.http.Invocation.service(Invocation.java:291)
at
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:132)
at
com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:341)
at
com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:271)
at com.caucho.server.TcpConnection.run(TcpConnection.java:136)
at java.lang.Thread.run(Thread.java:536)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<jsp precompile="true" static-encoding="true"
recompile-on-error="false"></jsp>
<http-server>
<!--- For production sites, change class-update-interval to something
- like 60, so it only checks for updates every minute.-->
<class-update-interval>15</class-update-interval>
<!--
- If true, the classloader order follows the Servlet spec.
- If false, the classloader order follows the JDK spec.
-->
<servlet-classloader-hack>false</servlet-classloader-hack>
<app-dir>C:\Work</app-dir>
<srun host="localhost" port="6802"></srun>
<caucho-status>true</caucho-status>
<thread-min>50</thread-min>
<thread-max>200</thread-max>
<thread-keepalive>30</thread-keepalive>
<accept-buffer-size id="256"></accept-buffer-size>
<thread-min id="5"></thread-min>
<cache dir="cache" size="1024" entries="2048"></cache>
<host id="">
<error-log id="log/error.log"></error-log>
<stdout-log href='log/stdout.log' rollover-period='1W'/>
<stderr-log href='log/stderr.log' rollover-period='1W'/>
<servlet-mapping url-pattern='*.jsp'
servlet-name='com.caucho.jsp.JspServlet'/>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
