Forum:

problem with java lib

Greenhorn

Posts: 1

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Script a.jsp

script b.jsp

<%@ page session="true" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<jsp:include page="adminHeader.html" flush="true" />
 
 
 
<%
Connection conn = null;
DataSource dspool = null;
PreparedStatement psatt = null;
ResultSet rs = null;
 
try 
{
Context ctx = new InitialContext();
dspool = (DataSource) ctx.lookup("jdbc/icems-studpool");
} 
catch (NamingException ne)
{
session.setAttribute( "errmsg", "Cannot make a connection with the Database.");

}  
 
if (dspool!=null)
{
try
{
conn = dspool.getConnection();
}
catch (SQLException e)
{
conn.close();
session.setAttribute( "errmsg", "Cannot make a connection with the Database.");

}
}
if( conn != null ){
  Statement stmt = conn.createStatement();
  rs = stmt.executeQuery("SELECT css_stud_id, stud_name, stud_status, stud_method, stud_degree, stud_faculty, degree_desc_long, faculty_desc, stud_program, program_desc, css_subj_det_id, subj_det_desc, css_application, css_approval, css_transfer_status " +
       " FROM ct_stud_subj_det, student_profile, degree_main, faculty_main, program, course_main, ct_subject_detail " +
       " WHERE css_stud_id = '" + request.getParameter("css_stud_id") + "' " +
       " AND css_subj_det_id = '" + request.getParameter("css_subj_det_id") + "' " +
       " AND stud_id = '" + request.getParameter("css_stud_id") + "' " +
       " AND EXISTS ( SELECT degree_desc_long " +
       " FROM student_profile, degree_main WHERE stud_id = '" + request.getParameter("css_stud_id") + "' " +
       " AND stud_degree = degree_id)" +
       " AND EXISTS ( SELECT faculty_desc " +
       " FROM student_profile, faculty_main WHERE stud_id = '" + request.getParameter("css_stud_id") + "' " +
       " AND stud_faculty = faculty_id)" +
       " AND EXISTS ( SELECT program_desc " +
       " FROM student_profile, program WHERE stud_id = '" + request.getParameter("css_stud_id") + "' " +
       " AND stud_program = prog_id)" +
       " AND EXISTS ( SELECT course_desc_short " +
       " FROM  course_main, ct_subject_detail WHERE course_id = csd_unitele_course " +
       " AND csd_id = '" + request.getParameter("css_subj_det_id") + "')");
       }
       
       if (rs.next())
       {
          String css_stud_id = rs.getString("css_stud_id");
          String stud_name = rs.getString("stud_name");
          String stud_status = rs.getString("stud_status");
          String stud_method = rs.getString("stud_method");
          String stud_degree = rs.getString("stud_degree");
          String degree_desc_long = rs.getString("degree_desc_long");
          String stud_faculty = rs.getString("stud_faculty");
          String faculty_desc = rs.getString("faculty_desc");
          String stud_program = rs.getString("stud_program");
          String program_desc = rs.getString("program_desc");
          String css_subj_det_id = rs.getString("css_subj_det_id");
          String subj_det_desc = rs.getString("subj_det_desc");
          String css_application = rs.getString("css_application");
          String css_approval = rs.getString("css_approval");
          String css_transfer_status = rs.getString("css_transfer_status"); %>
       
       
 <form>
  <table cellspacing="2" cellpadding="3" border="0" width="100%">
    <tr>
      <td bgcolor="#FFFFFF"><font color="#000099" size="6" face="Courier New, Courier, mono"><strong>CREDIT 
        TRANSFER STATUS</strong></font></td>
      <td bgcolor="#FFFFFF"> </td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Student ID</font>                    
        <input type="text" size="10" name="css_stud_id" value="<%= css_stud_id %>" maxlength="10"/></td>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Student Name</font> 
        <input type="text" name="stud_name" value="<%= stud_name %>"/></td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Status</font>                           
        <input type="text" name="stud_status" value="<%= stud_status %>" maxlength="20" size="20"/>
        </td>
      <td> </td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Method                        </font> 
        <input type="text" name="stud_method" value="<%= stud_method %>" maxlength="20" size="20"/></td>
      <td> </td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Degree</font>                         
        <input type="text" name="stud_degree" value="<%= stud_degree %>" maxlength="6" size="6"/>
      <input type="text" name="degree_desc_long" value="<%= degree_desc_long %>"/></td>
      <td> </td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Faculty</font>                         
        <input type="text" name="stud_faculty" value="<%= stud_faculty %>" maxlength="10" size="10"/>
      <input type="text" name="faculty_desc" value="<%= faculty_desc %>"/>
      </td>
      <td> </td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Program</font>                       
        <input type="text" name="stud_program" value="<%= stud_program %>" maxlength="5" size="5"/>
      <input type="text" name="program_desc" value="<%= program_desc %>"/></td>
      <td> </td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Subject</font>                        
      <input type="text" name="css_subj_det_id" value="<%= css_subj_det_id %>" maxlength="10" size="10"/> 
      <input type="text" name="subj_det_desc" value="<%= subj_det_desc %>"/></td>
      <td> </td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Date Apply</font>                    
        <input type="text" name="css_application" value="<%= css_application %>" maxlength="10" size="10"/></td>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Date Approval</font> 
        <input type="text" name="css_approval" value="<%= css_approval %>" maxlength="10" size="10"/></td>
    </tr>
    <tr>
      <td><font face="Geneva, Arial, Helvetica, sans-serif">Status Credit Transfer</font> 
      <input type="text" name="css_transfer_status" value="<%= css_transfer_status %>" maxlength="10" size="10"/> 
        </td>
      <td> </td>
    </tr>
    <% } rs.close(); conn.close(); %>
  </table>
 
</form>

at the page a.jsp i press submit button it's appear this error

java.lang.NullPointerException
at _auto__cr__status__next._jspService(auto_cr_status_next.jsp:60)
[/auto_cr_status_next.jsp]
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java: 65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatch er.java:604)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletReques tDispatcher.java:317)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.j ava:790)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResou rcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)

Can you tell me what is the cause of this error?

Zaheer Nanji

Greenhorn

Posts: 5

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

Would recommend putting some debug statements (SOPs) to determine the line where this exception is being raised.

Also, the stack trace suggests that the problem occurs on line 60 of the JSP.

We can have a look after you get this info.

Cheers