-----Original Message----- From: Suon, Thla [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 9:18 AM To: [EMAIL PROTECTED] Subject: Please Help with: "full description error: java.lang.NullPointer Exception" Greetings Everyone, I have a very annoying problem and can't seem to solve it for 3 days now. Any help from you guys would be greatly appreciated. I think I am having this problem because one of tables has a column called CRDESC of datatype LONG. I used: "oracle.jdbc.driver.OracleStatement ostmt=(oracle.jdbc.driver.OracleStatement)stmt; ostmt.defineColumnType(2,Types.VARCHAR);" but it is giving me all kinds of problem. I put in a debug statement inside called " System.out.println("inside");" and have learned that it doesn't get further than that. It never print out another debug statement I put in called "System.out.println("full_crdesc: "+full_crdesc);" So suspect there is a problem with the getString? Please help....thanks. Tyla ============please see program below===================== try { int i = 0; int i_total = 0; String full_rel = ""; rs = stmt.executeQuery("SELECT release,platform,status,to_char(fixdate,'Mon dd,yyyy')fixdate,to_char(clsdate,'Mon dd,yyyy') clsdate,clsby,fldrelease,urgency from scars.strstat where strnr=" +strnum +"order by release"); while(rs.next()) { release[i] = rs.getString("release"); platform[i] = rs.getString("platform"); status[i] = rs.getString("status"); String fixdate = rs.getString("fixdate"); }//end while for (i_counter = 0; i_counter < i_total; i_counter++) { try { rs = stmt.executeQuery("SELECT crseqnum from scars.strstat where strnr="+strnum +" and release="+"'"+release [i_counter]+"'"+" and platform="+"'"+platform[i_counter]+"'"+" and status="+"'"+status[i_counter]+"'"); while(rs.next()){ crseqnum =rs.getInt(1); } }//end try catch (Exception ex) { System.out.println("closing/routing error: "+ex.toString()); } full2_crdesc = " < Release # "+platform[i_counter]+" "+ release[i_counter]+" >"; out.print(full2_crdesc); for(int cr = 1; cr <= crseqnum; cr++) { oracle.jdbc.driver.OracleStatement ostmt= (oracle.jdbc.driver.OracleStatement)stmt; ostmt.defineColumnType(2,Types.VARCHAR); rs= stmt.executeQuery("SELECT crdesc from scars.closeroute where strnr="+strnum +"and crseqnum="+cr +" and platform="+"'"+platform[i_counter]+"'"+" and release="+"'"+release [i_counter]+"'"); while (rs.next()) { full_crdesc = ""; System.out.println("inside"); String crdesc = rs.getString("CRDESC"); System.out.println("crdesc: " +crdesc); full_crdesc = full_crdesc + "\n"+"\n"+crdesc; System.out.println("full_crdesc: "+full_crdesc); out.print(full_crdesc); }//end while }//end for loop out.print("\n"); out.print("__________________________________________"); out.print("\n"); }//end i_counter for loop out.print("</textarea>"); out.print("<br>"); }// end outside try catch (Exception ex) { System.out.println("full description error: " +ex.toString()); } thank you, Tyla ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
