RE: Java Error. HELP NEEDED URGENTLY

["Anand, Rajesh" <Rajesh_Anand@xxxxxx>]

        The best way to learn, in my opinion, is to start coding.

        I've read a couple of books but you don't really grasp the
language until you start coding.

        I'm, however, thankful to you and everyone in the forum who have
pointed out errors in my code.

        Thanks for all the help and rest be assured that I won't give up
even if it means learning the hard way.

        On a separate note, does anyone know how to open Iseries to web
traffic?

        rgds,

Rajesh Anand
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Sergio Carabetta
Sent: 22 December 2004 19:33
To: java400-l@xxxxxxxxxxxx
Subject: Java Error. HELP NEEDED URGENTLY


This class has several errors. First, you "hide" all your fields by
declaring them as local (when you say "ResultSet rs" you are declaring a
NEW
field named "rs", not using your instance field "rs", for example). When
you
try to get your rs.next(), rs is empty (null). Learn how to use
Checkstyle
or some of the good tools out there to verify your code, you will love
'em.

Try your hand at Java with simpler tasks first. XML and JDBC are
somewhat
tricky and may distract you from the language. Forums could help, but
you
have to walk before you run.

Hope this helps,

Sergio
 

>> ---------
>> 
>> message: 1
>> date: Wed, 22 Dec 2004 13:58:55 -0000
>> from: "Anand, Rajesh" <Rajesh_Anand@xxxxxx>
>> subject: Java Error. HELP NEEDED URGENTLY
>> 
>> 
>>      Folks,
>>      
>>      This is the copy of the source that I ran on AS400.
>> 
>>      One thing I know for sure is that it gives error on the
>> highlighted statement below....
>> 
>>      import java.io.*;
>>      import java.sql.*;
>>      import java.text.*;
>>      import java.util.*;
>> 
>>      import org.jdom.output.*;
>>      import org.jdom.input.*;
>>      import org.jdom.*;
>>      import org.jdom.transform.*;
>>      import org.jdom.contrib.input.*;
>>      import com.ibm.as400.access.*;
>> 
>>      public class createFsaxml 
>>      {
>>      Element elcct = null;
>>      Element elpt = null;
>>      ResultSet rs = null;
>>      Document doc = null;
>>      PrintWriter pw = null;
>>      Element rootelem = null;
>> 
>>      
>> 
>>      public createFsaxml() throws Exception{
>> 
>>      
>>      try{
>>      // register driver
>> 
>>      DriverManager.registerDriver(new
>> com.ibm.as400.access.AS400JDBCDriver());
>>               
>>      Connection c =
>> DriverManager.getConnection("jdbc:as400://mldev400/SPANAND");
>> 
>>      System.out.println("Got connection.. processing");
>> 
>>      Statement stmt = c.createStatement();
>> 
>>      ResultSet rs = stmt.executeQuery("Select * from GMISFAF1");
>> 
>>      System.out.println("Got Query results");
>>      System.out.println("Trying to create XML file");
>> 
>>      createxml();    
>> 
>>      c.close();
>>           } catch(SQLException e){
>>              System.out.println(e);
>>                                   }
>>      }
>> 
>> 
>> 
>>      public void createxml() throws Exception{
>> 
>>      int cntr = 0;
>> 
>>      Document doc = new Document();
>> 
>>      Element rootelem = new Element("FSArootElement");
>> 
>>      doc.setRootElement(rootelem);
>> 
>>      
>>      try{
>>      
>>      PrintWriter pw = new PrintWriter(new BufferedWriter(new
>> FileWriter("/java/demo/fsa.xml")));
>> 
>>      while (rs.next()){
>>      Element elcct = new Element("CurrencyCodeType");
>>      elcct.addContent(rs.getString(12).trim());
>> //
>>      Element elpt = new Element("PriceType");
>>      elpt.addContent(rs.getString(13).trim());
>>      cntr++;
>> //
>>                       }
>> //
>>      rootelem.addContent(elcct);
>>      rootelem.addContent(elpt);
>> //
>> 
>>      XMLOutputter outputter = new XMLOutputter();
>>      outputter.output(rootelem, pw);
>>      pw.flush();
>>      pw.close();
>>      }catch(IOException e){
>>              System.out.println(e);
>>                              }
>>      catch(SQLException e){
>>              System.out.println(e);
>>      }       
>>      System.out.println("total no of records: " +
>> String.valueOf(cntr));
>>      
>> }
>> 
>> 
>>      //public ValidateDoc(File f){
>> 
>>      //private String f;
>> 
>>      //try{ 
>> 
>>      //    }
>>      //}
>> 
>>      public static void main(String[] args) throws Exception{
>> 
>> //   String sfile = args[0];
>> 
>> //   String spath = args[1];
>> 
>>      if (args.length != 2){
>> 
>> // report errors
>> 
>>      System.out.println("Error! ");
>>      System.out.println("Pls enter location of the schema");
>>      return;
>>      }
>>      createFsaxml cxml = new createFsaxml();
>> 
>> //Validate val = new ValidateDoc(File cxml);
>> 
>> //   System.exit(1);
>> 
>> }
>> }
>> 
>>      The Error is....
>> 
>>      java.lang.NullPointerException 
>> 
>>      Thanks for your help in advance.
>> 
>>      regards,
>> 
>>      
>> Rajesh Anand
>> Email:Rajesh_anand@xxxxxx 
>> --------------------------------------------------------
>>  
>> If you are not an intended recipient of this e-mail, please 
>> notify the sender, delete it and do not read, act upon, 
>> print, disclose, copy, retain or redistribute it. Click here 
>> for important additional terms relating to this e-mail.     
http://www.ml.com/email_terms/ 
--------------------------------------------------------
 


------------------------------

-- 
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
digest list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.



End of JAVA400-L Digest, Vol 2, Issue 406
*****************************************
-- 
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l. 
--------------------------------------------------------
 
If you are not an intended recipient of this e-mail, please notify the sender, 
delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/ 
--------------------------------------------------------