public   synchronized  OrderHeader getOrderHeader( int  xOID){
        OrderHeader oh =  new  OrderHeader();
        Statement stm =  null ;
        ResultSet rs =  null ;
         try  {
             try  {
                conn =  new  lbConnector().getConn();
            }  catch  (Exception e){
                e.printStackTrace();
            }           
            stm = conn.createStatement();
            String qry = "select * from orders where id="+xOID;
            rs = stm.executeQuery(qry);
            
             if (rs.next()){
                oh.iOrderID = rs.getInt( 1 );
...
            }

        }  catch  (SQLException e){
            e.printStackTrace();
        }  finally  {
             if ( rs !=  null  )
                 try  { rs.close(); }  catch ( SQLException ignore ) {}
             if ( stm !=  null  )
                 try  { stm.close(); }  catch ( SQLException ignore ) {}
             if ( conn !=  null  )
                 try  { conn.close(); }  catch ( SQLException ignore ) {}
        }
        
         return  oh;
    }

    public   synchronized   int  saveOHeader( int  xCst,  int  xSt,  int  xPt,  int  xAgent, String xDDate, String xPDate,  float  xCredit,  float  xDiscount,  int  xUID){
        Statement stm =  null ;
        ResultSet rs =  null ;
         int  x =  0 ;
         try  {
             try  {
                conn =  new  lbConnector().getConn();
            }  catch  (Exception e){
                e.printStackTrace();
            }
            stm = conn.createStatement();
            String qry = "insert into orders set ...";
            stm.executeUpdate(qry);
            rs = stm.getGeneratedKeys();
             if (rs.next()){
                x = rs.getInt( 1 );    
            }
        }  catch  (SQLException e) {
            e.printStackTrace(); 
        }  finally  {
             if ( rs !=  null  )
                 try  { rs.close(); }  catch ( SQLException ignore ) {}
             if ( stm !=  null  )
                 try  { stm.close(); }  catch ( SQLException ignore ) {}
             if ( conn !=  null  )
                 try  { conn.close(); }  catch ( SQLException ignore ) {}
        }                
         return  x;
    }

<%UserData ud = (UserData)session.getAttribute("User");%>
...
<% if (aa.sAction !=  null  && aa.sAction.equals("posAdd")){%>
...
    <%OrderHeader oh = tb.getOrderHeader(aa.iRID);%>
...
}

 10 . 09 . 2007   10 : 35 : 10  org.apache.catalina.core.ApplicationDispatcher invoke
SEVERE: Servlet.service()  for  servlet jsp threw exception
java.lang.NullPointerException
	at org.apache.jsp.orders_jsp._jspService(orders_jsp.java: 173 )
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java: 97 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 802 )
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java: 332 )
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: 314 )
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java: 264 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 802 )
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 252 )
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java: 672 )
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java: 463 )
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java: 398 )
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java: 301 )
	at xxx.lb_engine.doPost(lb_engine.java: 878 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 709 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 802 )
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 252 )
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213 )
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 178 )
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126 )
	at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java: 20 )
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 107 )
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 148 )
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 869 )
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 664 )
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 527 )
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java: 80 )
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: 684 )
	at java.lang.Thread.run(Thread.java: 619 )