jspInit() was called more than one at the Java WebServer 2.0
so the connection is full..
At the JSP Spec., jspInit() will be call at Initialize the page
But JavaWebServer 2.0 call always jspInit()
I make a sample code
<%@ page contentType="text/html; charset=euc-kr" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%!
private Connection conn = null;
public void jspInit()
{
connectDB();
}
public void jspDestory()
{
if (conn != null)
closeDB();
}
public void connectDB()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException e )
{
}
try
{
conn = java.sql.DriverManager.getConnection(
"jdbc:oracle:oci8:@adb","blah","blah");
}
catch (java.sql.SQLException e)
{
}
}
public void closeDB()
{
try
{
if (conn != null)
conn.close();
}
catch (java.sql.SQLException e)
{
}
}
%>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html