Forum:

SqlException accured at processing Jsp

Ranch Hand

Posts: 61

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hai...
this is my jsp...

<%@ page import="java.sql.*" import="org.bar.DbConnection" import="java.util.*" import="javax.imageio.ImageIO" import="java.io.*" import="java.awt.Image" import="java.net.URL"
    import="java.awt.image.BufferedImage" %>

<HTML>
    <HEAD>
      <style type="text/css">
     @media print {
     input#btnPrint {
     display: none;
        }
            }
            p.normal 
  { 
   border-style: ; 
  
  margin-left:5%; 
  line-height:150%;
  font-size:100%
   } 
           </style>
      
    </HEAD>

<BODY>
    <p class="normal" >
    <center>
   
    <font color="#0000FF"><br><br>
        <H1>RECEIPT</H1>

<% 
        //int bar=Integer.parseInt(request.getParameter("bar"));
       int bar = ((Integer)session.getAttribute("bar")).intValue();
         // int bar=Integer.parseInt((String)request.getAttribute("bar"));
              System.out.println(bar);
           //int b=Integer.parseInt(bar);
             Statement st=null;
	         ResultSet rs=null;	
             DbConnection dbc=new DbConnection();
             Connection con=dbc.getDbConnection();
             Properties props = new Properties();
          
		//PreparedStatement ps=null;
		 //ResultSet rs=null;	
	// DbConnection dbc=new DbConnection();
      //Connection con=dbc.getDbConnection();
     // Properties props = new Properties();
      try{
    	   props.load(getClass().getResourceAsStream("/org/bar/prop.properties")); 
			//props.load(fin);
	        String viewstatement =props.getProperty("view.query");
	        
		     
         //System.out.println(viewstatement);

st=con.createStatement();
	       rs=st.executeQuery(viewstatement+bar);
	       
            if(!rs.next()) {
                out.println("Sorry, could not find that publisher. ");
            } else {
             
        %>

<TABLE >
        
            <TR>
               <Td><font color="#0000FF">IREFNUM :</font></Td>
               <TD> <%= rs.getInt(1) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">REFNUM :</font></Td>
                <TD><%= rs.getInt(2) %> </TD>
               </tr>
               <Td><font color="#0000FF">FROM DEPT :</font></Td>
               <TD> <%= rs.getString(3) %> </TD>
               <tr>
               <Td><font color="#0000FF">FROM SEC :</font>
                <TD> <%= rs.getString(4) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">TO DEPT:</font></Td>
                <TD> <%= rs.getString(5) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">TOSEC:</font></Td>
               <TD> <%= rs.getString(6) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">SUBJECT:</font></Td>
               <TD> <%= rs.getString(7) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">NOTES:</font></Td>
                <TD> <%= rs.getString(8) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">BARCODE:</font></Td>
               <TD> <%= rs.getString(9) %> </TD>
               </tr>
           </TABLE>
       <BR>
      
       
      
        
         
       <% 
           
         } 
          
           }
           catch(Exception e){
           throw new SQLException();
           }
           finally {
		       	 try {
		             if (rs != null)
		             rs.close();
		             if (st != null)
		             st.close();
		             if(con !=null)
		             con.close();

} catch (Exception e) { 
		     
		      }
		      
	 }
	  
 %>
 <%= new java.util.Date() %>
        <br><br><br><br>
        <input type="Button" id="btnPrint" onClick="window.print()" value="Print This Page"/>
        </font>
       
       </center>
    </BODY>

when i am processing above jsp i am getting exception at

then how can i solve that exception and print values

Smitesh Shinde

Ranch Hand

Posts: 45

I like...

posted 13 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Ramesh, first of all JSP isn't place to write your application logic. It is considered as bad practice.

Regarding your exception problem -

You can't be absolutely sure of which exception your JSP is throwing. You'll always get java.lang.SQLException in every case as you are explicitly throwing it from your code. Try to print the stack trace to get the exact exception.

Bear Bibeault

Sheriff