I tried debug failing: trying to incle xml file contents to db table

[Leonidas Savvides]

I tried debug failing: trying to incle xml file contents to db table...
xmlPlantToDB.java:170
public void endElement(String namespaceURI,
String sName, String qName) throws SAXException {

if (state == 1) // here error does not go to endDocument( )
searchonHand[j-1]=str;

if (state == 2)
searchname[j-1]=str; // line 170

xmlPlantToDB.java:47
parser.parse(new File(xmlFile), eventHandler); // line 47

 
  Carnationjava.lang.NullPointerException
      at xmlPlantToDB.endElement(xmlPlantToDB.java:170)
      at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
      at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1774)
      at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2930)
      at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
      at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
      at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
      at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
      at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
      at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
      at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
      at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
      at javax.xml.parsers.SAXParser.parse(SAXParser.java:331)
      at xmlPlantToDB.main(xmlPlantToDB.java:47)   

 import java.io.*;
import java.sql.*;
import java.util.*;
import org.xml.sax.*;
import org.xml.sax.helpers.DefaultHandler;
import javax.xml.parsers.*;
// javac xmlPlantToDB.java  java xmlPlantToDB   https://coderanch.com/t/482693/XML-Related-Technologies/tried-find-BUG-this-SAX
// Class header for Java class CountEm    http://www.java-forums.org/xml/25590-i-tried-find-bug-sax-parser-but-no-result.html#post104555
public class xmlPlantToDB extends DefaultHandler  {

  // Variable j is a counter for number of plants
  public int j = 0;
  static public OutputStreamWriter writer;
  static public int state = 0;
  static public String plant = null;
  static public int min = Integer.MAX_VALUE;
  static public String minPlant = null;
  static public String str = " ";
  static public int getRest = 0;
  static public String searchname[];
  static public String searchscientificName[];
  static public String searchonHand[];
  static public String searchcolor[];
   private Statement sttmnt;
   private Connection conn;  
  // header for method main
  public static void main ( String args [ ] )   {

    String xmlFile = "plants2.xml";   

    // Uses instance of class CountEm as SAX event handler
    DefaultHandler eventHandler  = new xmlPlantToDB(  );

    // Create instance of SAXParseFactory called sFactory
    SAXParserFactory  sFactory  = 
       SAXParserFactory.newInstance( );

    // The name of the XML file is xmlFile
    try  {
       // Create output stream in UTF8 character mode
       writer = new  OutputStreamWriter(System.out, "UTF8");

       // Create a SAXParser object called parser
       SAXParser  parser  =  sFactory.newSAXParser(  );

       // execute method parse using the SAXParser object
       parser.parse(new  File(xmlFile), eventHandler);
	   

	   

    }  catch (Throwable t)  {
           t.printStackTrace( );
    }
    System.exit(0);

  } // end of main


  // output is a method used to write to System.out
  private  void  output(String  s) throws SAXException {
    try   {
        writer.write(s);
        writer.flush( );
    } catch (IOException  e)  {
        throw new SAXException("I/O error", e);
    }
  } // end of method output


  // This method writes a newline character to System.out
  private void newLine( ) throws SAXException  {
    String endOfLine = 
        System.getProperty("line.separator");
    try  {
         writer.write(endOfLine);
    }  catch (IOException  e)  {
         throw  new  SAXException("I/O error", e);
    }
  }  // end of method newLine


  // This method executes when the beginning of the XML 
  //  file is encountered
  public  void  startDocument( )  throws  SAXException  {
        newLine(  );
  } // end of method startDocument

  // This method executes when the end of the XML file is 
  //   encountered
  public  void  endDocument(  )  throws SAXException  {
    try  {
         // Write newline character and then flush the output
         newLine( );
         writer.flush( );
         // Display total number of plant tags encountered
         output("Total number of different plants was: " 
            + j);

        
     String url = "jdbc:odbc:plants"; //dsn plants
     String user="";
     String password="";
     try {
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       conn=DriverManager.getConnection
         ("jdbc:odbc:plants", user, password);
       sttmnt=conn.createStatement();
  
          //get statement object
      }catch (Exception exception)  {
	  //return (exception.getMessage());
      } // end of catch
        finally {
            //
        }		
		String sqlCommand3;
		for (int i = 0; i < j; i++)  //lineList2.length
        {

          sqlCommand3 = "INSERT INTO Plants VALUES("+150+i+",'"+searchname[i]+"','"+searchscientificName[i]+"','"+searchcolor[i]+"',"+10.00+",'xxxx')" ;
  
            sttmnt.executeUpdate(sqlCommand3);
        }
	} // end of try
    catch (IOException  e)  {
         throw  new  SAXException("I/O error", e);
    }	
	catch (SQLException sqlException)  {
          // catch SQLExceptions
	  //return ("Exception 1: " + sqlException.getMessage( ));
	}  // end of catch
	catch (Exception exception)  {
          // catch general exceptions
  	 // return ("Exception 2: "+ exception.getMessage( ));
	} // end of catch

  } // end of method endDocument

  //Executes when new element start tag is encountered
  public void startElement (String namespaceURI, 
     String sName, String qName, Attributes  attrs)   
     throws  SAXException   {
    String eName = sName;  // The name of an element
    if ("".equals(eName))  eName = qName; 

    if (eName == "plant") // Check for plant element
       j++;  // increment j by 1 for each plant element
    
    if (eName == "name")
       state = 2;
    else if (eName == "onHand")
       state = 1;
    else if (eName == "scientificName")
       state = 3;
    else if (eName == "color")
       state = 4;
    else 
       state = 0;
  } // end of method startElement

  //Executes when end element tag is encountered
  public  void  endElement(String namespaceURI, 
    String sName, String qName) throws SAXException    {

    if (state == 1) 
		searchonHand[j-1]=str;	  
		   
    if (state == 2)
		searchname[j-1]=str;	

    if (state == 3)
		searchscientificName[j-1]=str;	
		
    if (state == 4)
		searchcolor[j-1]=str;	
	/*	
    if (state == 1 && Integer.parseInt(str) < min)
    {
           minPlant = plant;
           min = Integer.parseInt(str);   
    }
    else if (state == 2)
           plant = str;  
	*/
	//		
  } // end of method endElement

  // Outputs the characters the parser sees
  public void characters(char  buf[ ], int offset, 
     int len) throws SAXException    {
    str  =  new  String(buf, offset, len);
    output(str);
   
  } // end of method characters

} // end of the CountEmModified class definition   

 <?xml version="1.0"?> 
<plants  xmlns = "x-schema:your-first-schema.xml">
  <plant id="25">
    <name>Carnation</name>
    <scientificName>Dianthus</scientificName>
    <onHand>4000</onHand>
    <color>Red</color>
  </plant>
  <plant id="65">
    <name>Lily-Of-The-Valley</name>
    <scientificName>Convallaria</scientificName>
    <onHand>250</onHand>
    <color>White</color>
  </plant>
  <plant id="115">
    <name>Violet</name>
    <scientificName>Viola</scientificName>
    <onHand>900</onHand>
    <color>Purple</color>
  </plant>
</plants>   

[Paul Clapham]

You haven't initialized the searchname variable, so it's null. And when you try to use it, you get that exception.

[William Brogden]

Note that the following implementation:

   public void characters(char  buf[ ], int offset,    
     int len) throws SAXException    {   
    str  =  new  String(buf, offset, len);   
    output(str);   
      
  } // end of method characters     

Will fail to work as expected in many cases where the input file is longer than one buffer load. Any decent tutorial on SAX processing will explain why.

Bill

[Leonidas Savvides]

input file is too short, no this the problem, and the arrays instatiated, how to initialized if I do not know length?

[Paul Clapham]

If you want an array of things, but you don't know how many things are going to be in the array? Then don't use an array. Use a List. An ArrayList would work just fine.

And your questions don't really seem to be about XML, they are ordinary questions about Java programming. Let's move this thread to a general forum about Java programming.