Forum:

SqlException accured at processing Jsp

ramesh poorella

Ranch Hand

Posts: 61

posted 5 years ago

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 5 years ago

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

Author and ninkuma
Marshal

Posts: 65833

134

I like...

posted 5 years ago

As Smitesh Shinde pointed out, the first step os to move the Java code out of the JSP and into a Java class where it can be properly tested.

[Asking smart questions] [About Bear] [Books by Bear]

SqlException accured at processing Jsp

Similar Threads