|
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/
--------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.