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

Reply via email to