0 Replies Latest reply: Apr 5, 2014 4:45 PM by 937465 RSS

    Where are the error logs?

    937465


      I'm running one of the examples (ConnCacheBean) in a JSP page on Oracle Application Server 10g (10.1.3.1.0)

       

      The JSP page works fine the first time I access it through a browser, then fails with this on the second attempt. Other JSP pages still work fine. I have to use opmnctl to restart the server before I can get my page to work again. It only works once - then another bounce is required.

       

      The error message I am getting is this:

       

      500 Internal Server Error

      Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

       

      Where is this application log they refer to?

       

      If anyone can spot anything wrong with this code - let me know:

       

      <%@ page import="java.sql.*, javax.sql.*, oracle.jsp.dbutil.ConnCacheBean" %>

      <%
         session.putValue("connStr","jdbc:oracle:thin:@localhost:1522:orcl");
      %>

      <jsp:useBean id="SQLBean" class="oracle.jsp.dbutil.ConnCacheBean" scope="application">
        <jsp:setProperty name="SQLBean" property="user" value="scott"/>
        <jsp:setProperty name="SQLBean" property="password" value="tiger"/>
        <jsp:setProperty name="SQLBean" property="URL" value="<%= (String)session.getValue(\"connStr\") %>"  />
        <jsp:setProperty name="SQLBean" property="MaxLimit" value="5"  />
      </jsp:useBean>
      <HTML>
        <HEAD>
          <TITLE>
            SimpleQuery JSP Test 14
          </TITLE>
        </HEAD>
       
      <BODY BGCOLOR=EOFFFO>

       

      <%
            try
            {
                    Connection conn = SQLBean.getConnection();

                    Statement stmt = conn.createStatement ();
                    ResultSet rset = stmt.executeQuery ("SELECT name FROM v$database");

                    while (rset.next())
                    {
      %>

             <%= rset.getString(1) %>

      <%
                    }

                    rset.close();
                    stmt.close();
                    conn.close();
                    SQLBean.close();
            } catch (SQLException e) {
              out.println("<P>" + "There was an error doing the query:");
              out.println ("<PRE>" + e + "</PRE> \n <P>");
            }
      %>

      </BODY>
      </HTML>