You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2001/10/18 21:22:34 UTC

DO NOT REPLY [Bug 4275] New: - java.lang.NullPointerException

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=4275>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=4275

java.lang.NullPointerException 

           Summary: java.lang.NullPointerException
           Product: Tomcat 3
           Version: 3.2.2 Final
          Platform: PC
        OS/Version: Windows NT/2K
            Status: UNCONFIRMED
          Severity: Blocker
          Priority: Other
         Component: Unknown
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: pai_deepak@hotmail.com


// This problem happens only when i run a class with Tomcat 
// When i run my code with its own main - there are no problems. 
// I havent seen anyone else reporting anything like this before.
// Please check since it might change my plans of using Tomcat as our web 
server :( 
// Thank You so very much. 


java.lang.NullPointerException         at 
org.apache.xalan.serialize.SerializerToXML.writeAttrString(Serializer
ToXML.java:2001)
        at org.apache.xalan.serialize.SerializerToXML.processAttribute(Serialize
rToXML.java:957)
        at org.apache.xalan.serialize.SerializerToXML.startElement(SerializerToX
ML.java:829)
        at org.apache.xalan.transformer.TransformerIdentityImpl.startElement(Tra
nsformerIdentityImpl.java:982)
        at org.apache.xml.utils.TreeWalker.startNode(TreeWalker.java:284)
        at org.apache.xml.utils.TreeWalker.traverse(TreeWalker.java:119)
        at org.apache.xalan.transformer.TransformerIdentityImpl.transform(Transf
ormerIdentityImpl.java:320)
        at serRS.writetoString(serRS.java:237)
        at _0002fsimplebean_0002ejspsimplebean_jsp_9._jspService(_0002fsimplebea
n_0002ejspsimplebean_jsp_9.java:164)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspSer
vlet.java:130)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSer
vlet.java:282)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:4
29)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:4
05)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372
)
        at org.apache.tomcat.core.ContextManager.internalService(ContextManager.
java:797)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743
)
        at org.apache.tomcat.service.http.HttpConnectionHandler.processConnectio
n(HttpConnectionHandler.java:213)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
416)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java
:501)
        at java.lang.Thread.run(Thread.java:484)










/***********************************************************/
/***********************************************************/
/***********************************************************/


// jdbc api
import java.sql.*;
//reflect api
import java.lang.reflect.*;
//xml api
import org.w3c.dom.*;
import org.w3c.dom.Document;
import org.w3c.dom.DOMException;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;
import org.w3c.dom.Node;
import org.w3c.dom.NamedNodeMap;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;

import javax.xml.transform.*;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
//javax.xml.parsers.ParserConfigurationException
import javax.xml.parsers.*;


//standard packages
import java.io.*;

//exceptionz
import org.xml.sax.*;
import org.xml.sax.SAXException;
import java.io.IOException;

/*

<?xml version="1.0" encoding="UTF-8" ?>
<results>
<result type="AllUsers">
<record number="1">
  <column name="username" />
  <column name="password" />
  <column name="address1" />
  <column name="address2" />
  <column name="city" />
  <column name="state" />
  <column name="zip" />
  <column name="country" />
</record>
</result>
</results>

*/

public class serRS implements java.io.Serializable
{


	/* Empty Constructor */
	public void serRS() {}

	public String writetoString (ResultSet rs, String typeid) {

	// return string
	String returnstr = new String();

		try{

			//XML
			DocumentBuilderFactory factory = 
DocumentBuilderFactory.newInstance();

			DocumentBuilder builder = factory.newDocumentBuilder();
			Document document = builder.newDocument();

			//<results/> Root element
			Element results = (Element) document.createElement
("results");
			document.appendChild(results);

			//<result/>
			Element result = (Element) document.createElement
("result");
			results.appendChild(result);

			//<result type="AllUsers"/>
			Attr type =(Attr) document.createAttribute("type");
			Node attrtextnode = (Node) document.createTextNode
(typeid);
			type.appendChild(attrtextnode);
			result.setAttributeNode(type);

			Element record;
			Element column;
			Node countnode ;
			Attr number;
			Attr name;
			Attr valuetype;
			Attr tablename;
			Node columnnametext;
			Node columnvaluetext;
			Node valuetypetext;
			Node tablenametext;

			int count = 1;

			// JDBC-ODBC Calls
			java.sql.ResultSetMetaData md = rs.getMetaData();

			  while(rs.next()) {
				// <record>

				record = (Element) document.createElement
("record");
				result.appendChild(record);

				// <record number="i">xxx</coulmn>
				number =(Attr) document.createAttribute
("number");
				countnode = (Node) document.createTextNode
(String.valueOf(count));
				count ++ ;
				number.appendChild(countnode);
				record.setAttributeNode(number);


				System.out.print("\nTUPLE: | ");
					for(int i=1; i<= md.getColumnCount(); 
i++) {
						// <column name="">value</value>
						column = (Element) 
document.createElement("column");
						record.appendChild(column);

						name =(Attr) 
document.createAttribute("name");
						//columnnametext = (Node) 
document.createTextNode(md.getColumnLabel(i));
						columnnametext = (Node) 
document.createTextNode(md.getColumnName(i));
						name.appendChild
(columnnametext);
						column.setAttributeNode(name);

						valuetype =(Attr) 
document.createAttribute("type");
						valuetypetext = (Node) 
document.createTextNode(md.getColumnTypeName(i));
						valuetype.appendChild
(valuetypetext);
						column.setAttributeNode
(valuetype);

						tablename =(Attr) 
document.createAttribute("table");
						tablenametext = (Node) 
document.createTextNode(md.getCatalogName(i));
						tablename.appendChild
(tablenametext);
						column.setAttributeNode
(tablename);


/*
						  System.out.print
(md.getColumnType(i) + " | ");
						  System.out.print
(md.getColumnTypeName(i) + " | ");
						  System.out.print
(md.getColumnLabel(i) + " | ");
						  //System.out.print
(rs.getString(i) + " | \n");
*/

						  try
						  {
							  Object o = 
rs.getObject(md.getColumnLabel(i));
							  if (!o.equals(null)){
								String s = 
o.toString();
								System.out.print
(s + "\n");
								columnvaluetext 
= (Node) document.createTextNode(s);
							
	column.appendChild(columnvaluetext);
							  }
						  }
						  catch (SQLException sqe ){
							
	sqe.printStackTrace();
						  }
						  catch (NullPointerException 
n ){
							  System.out.print
("Null pointer hui gava!!!!!!");
							
	n.printStackTrace();
						  }

						  // new line
						  System.out.print("\n");

					}
				}


/*
			File f = new File("local.xml");
			//document = builder.parse(f);
			// Use a Transformer for output
*/

/*
			TransformerFactory tFactory = 
TransformerFactory.newInstance();
			Transformer transformer = tFactory.newTransformer();

			DOMSource source = new DOMSource(document);
*/

			/*
			// write to the standard output
			StreamResult resultstdout = new StreamResult
(System.out);
			transformer.transform(source, resultstdout);
			*/

/*
			// write to a file
			StreamResult resultfile = new StreamResult(f);
			transformer.transform(source, resultfile);
*/

/*
			// write to a string
			java.io.StringWriter sw = new StringWriter();

			// use the transformer object
			StreamResult resultsw = new StreamResult(sw);
			transformer.transform(source, resultsw);
			resultsw.setWriter (sw);

			// create a new String variable (above)
			// convert the StringWriter object to String
			returnstr = sw.toString();
*/

			/*
			// write to the standard output
			System.out.println(returnstr);

			// write to the standard output
			System.out.println(sw.toString());
			*/

			// Trial basis
			TransformerFactory tFactory = 
TransformerFactory.newInstance();
			Transformer transformer = tFactory.newTransformer();
			DOMSource source = new DOMSource(document);
			java.io.StringWriter sw = new StringWriter();

			try{

			// write to the standard output
			//StreamResult resultstdout = new StreamResult
(System.out);
			//transformer.transform(source, resultstdout);

			// use the transformer object
			StreamResult resultsw = new StreamResult(sw);

			if(! (source.equals(null) || resultsw.equals(null)) )
			{

				transformer.transform(source, resultsw);
				resultsw.setWriter (sw);
			}
			else{

				if (source.equals(null))
				{
					System.out.println("********** 
source**************");
				}
				if (resultsw.equals(null))
				{
					System.out.println("********** resultsw 
**************");
				}

			}


			}
			catch (NullPointerException n ){
			  System.out.print("Null pointer hui gava again!!!!!!");
				n.printStackTrace();
			  }

			catch (Exception e ){
			  System.out.print("Null pointer hui gava again!!!!!!");
				e.printStackTrace();
			  }




			// create a new String variable (above)
			// convert the StringWriter object to String

			//returnstr = sw.toString();




		}
		catch (Exception e){
			e.printStackTrace();
		}


		return returnstr;

	}// end method

	/** Test main method*/
	public static void main( String args[]) {

		try {

			System.out.println("\nHello World\n");
			serRS serrs = new serRS ();

			SQLtoRS sqltors = new SQLtoRS();
			sqltors.setsqlstr("select * from users");
			ResultSet rs = sqltors.getrs();
			System.out.println(serrs.writetoString(rs, "AllUsers"));

		}//end try
		catch (Exception e)
		{

		}//end catch

	}// end main


}//end class

// jdbc api
import java.sql.*;
//reflect api
import java.lang.reflect.*;
//xml api
import org.w3c.dom.*;
import org.w3c.dom.Document;
import org.w3c.dom.DOMException;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;
import org.w3c.dom.Node;
import org.w3c.dom.NamedNodeMap;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;

import javax.xml.transform.*;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
//javax.xml.parsers.ParserConfigurationException
import javax.xml.parsers.*;


//standard packages
import java.io.*;

//exceptionz
import org.xml.sax.*;
import org.xml.sax.SAXException;
import java.io.IOException;

/*

<?xml version="1.0" encoding="UTF-8" ?>
<results>
<result type="AllUsers">
<record number="1">
  <column name="username" />
  <column name="password" />
  <column name="address1" />
  <column name="address2" />
  <column name="city" />
  <column name="state" />
  <column name="zip" />
  <column name="country" />
</record>
</result>
</results>

*/

public class serRS implements java.io.Serializable
{


	/* Empty Constructor */
	public void serRS() {}

	public String writetoString (ResultSet rs, String typeid) {

	// return string
	String returnstr = new String();

		try{

			//XML
			DocumentBuilderFactory factory = 
DocumentBuilderFactory.newInstance();

			DocumentBuilder builder = factory.newDocumentBuilder();
			Document document = builder.newDocument();

			//<results/> Root element
			Element results = (Element) document.createElement
("results");
			document.appendChild(results);

			//<result/>
			Element result = (Element) document.createElement
("result");
			results.appendChild(result);

			//<result type="AllUsers"/>
			Attr type =(Attr) document.createAttribute("type");
			Node attrtextnode = (Node) document.createTextNode
(typeid);
			type.appendChild(attrtextnode);
			result.setAttributeNode(type);

			Element record;
			Element column;
			Node countnode ;
			Attr number;
			Attr name;
			Attr valuetype;
			Attr tablename;
			Node columnnametext;
			Node columnvaluetext;
			Node valuetypetext;
			Node tablenametext;

			int count = 1;

			// JDBC-ODBC Calls
			java.sql.ResultSetMetaData md = rs.getMetaData();

			  while(rs.next()) {
				// <record>

				record = (Element) document.createElement
("record");
				result.appendChild(record);

				// <record number="i">xxx</coulmn>
				number =(Attr) document.createAttribute
("number");
				countnode = (Node) document.createTextNode
(String.valueOf(count));
				count ++ ;
				number.appendChild(countnode);
				record.setAttributeNode(number);


				System.out.print("\nTUPLE: | ");
					for(int i=1; i<= md.getColumnCount(); 
i++) {
						// <column name="">value</value>
						column = (Element) 
document.createElement("column");
						record.appendChild(column);

						name =(Attr) 
document.createAttribute("name");
						//columnnametext = (Node) 
document.createTextNode(md.getColumnLabel(i));
						columnnametext = (Node) 
document.createTextNode(md.getColumnName(i));
						name.appendChild
(columnnametext);
						column.setAttributeNode(name);

						valuetype =(Attr) 
document.createAttribute("type");
						valuetypetext = (Node) 
document.createTextNode(md.getColumnTypeName(i));
						valuetype.appendChild
(valuetypetext);
						column.setAttributeNode
(valuetype);

						tablename =(Attr) 
document.createAttribute("table");
						tablenametext = (Node) 
document.createTextNode(md.getCatalogName(i));
						tablename.appendChild
(tablenametext);
						column.setAttributeNode
(tablename);


/*
						  System.out.print
(md.getColumnType(i) + " | ");
						  System.out.print
(md.getColumnTypeName(i) + " | ");
						  System.out.print
(md.getColumnLabel(i) + " | ");
						  //System.out.print
(rs.getString(i) + " | \n");
*/

						  try
						  {
							  Object o = 
rs.getObject(md.getColumnLabel(i));
							  if (!o.equals(null)){
								String s = 
o.toString();
								System.out.print
(s + "\n");
								columnvaluetext 
= (Node) document.createTextNode(s);
							
	column.appendChild(columnvaluetext);
							  }
						  }
						  catch (SQLException sqe ){
							
	sqe.printStackTrace();
						  }
						  catch (NullPointerException 
n ){
							  System.out.print
("Null pointer hui gava!!!!!!");
							
	n.printStackTrace();
						  }

						  // new line
						  System.out.print("\n");

					}
				}


/*
			File f = new File("local.xml");
			//document = builder.parse(f);
			// Use a Transformer for output
*/

/*
			TransformerFactory tFactory = 
TransformerFactory.newInstance();
			Transformer transformer = tFactory.newTransformer();

			DOMSource source = new DOMSource(document);
*/

			/*
			// write to the standard output
			StreamResult resultstdout = new StreamResult
(System.out);
			transformer.transform(source, resultstdout);
			*/

/*
			// write to a file
			StreamResult resultfile = new StreamResult(f);
			transformer.transform(source, resultfile);
*/

/*
			// write to a string
			java.io.StringWriter sw = new StringWriter();

			// use the transformer object
			StreamResult resultsw = new StreamResult(sw);
			transformer.transform(source, resultsw);
			resultsw.setWriter (sw);

			// create a new String variable (above)
			// convert the StringWriter object to String
			returnstr = sw.toString();
*/

			/*
			// write to the standard output
			System.out.println(returnstr);

			// write to the standard output
			System.out.println(sw.toString());
			*/

			// Trial basis
			TransformerFactory tFactory = 
TransformerFactory.newInstance();
			Transformer transformer = tFactory.newTransformer();
			DOMSource source = new DOMSource(document);
			java.io.StringWriter sw = new StringWriter();

			try{

			// write to the standard output
			//StreamResult resultstdout = new StreamResult
(System.out);
			//transformer.transform(source, resultstdout);

			// use the transformer object
			StreamResult resultsw = new StreamResult(sw);

			if(! (source.equals(null) || resultsw.equals(null)) )
			{

				transformer.transform(source, resultsw);
				resultsw.setWriter (sw);
			}
			else{

				if (source.equals(null))
				{
					System.out.println("********** 
source**************");
				}
				if (resultsw.equals(null))
				{
					System.out.println("********** resultsw 
**************");
				}

			}


			}
			catch (NullPointerException n ){
			  System.out.print("Null pointer hui gava again!!!!!!");
				n.printStackTrace();
			  }

			catch (Exception e ){
			  System.out.print("Null pointer hui gava again!!!!!!");
				e.printStackTrace();
			  }




			// create a new String variable (above)
			// convert the StringWriter object to String

			//returnstr = sw.toString();




		}
		catch (Exception e){
			e.printStackTrace();
		}


		return returnstr;

	}// end method

	/** Test main method*/
	public static void main( String args[]) {

		try {

			System.out.println("\nHello World\n");
			serRS serrs = new serRS ();

			SQLtoRS sqltors = new SQLtoRS();
			sqltors.setsqlstr("select * from users");
			ResultSet rs = sqltors.getrs();
			System.out.println(serrs.writetoString(rs, "AllUsers"));

		}//end try
		catch (Exception e)
		{

		}//end catch

	}// end main


}//end class