wood burning stoves 2.0*
The moose likes Servlets and the fly likes Issue Req Storing Result Set Data in a XML File Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Issue Req Storing Result Set Data in a XML File" Watch "Issue Req Storing Result Set Data in a XML File" New topic
Author

Issue Req Storing Result Set Data in a XML File

K Sathya Narayanan
Greenhorn

Joined: Feb 15, 2007
Posts: 28
i am developing a project using jsp & servlet.
i want�create a xml from result set using document builder but when the servlet is executed it displays the Http Status 500 error

tell me what to do . where to place that xml file

is there other for writing result set data as xml
below is the code that� does not work

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
Document mapDoc;
Document dataDoc=null;
String XmlFileName=request.getParameter("filename");
DocumentBuilder db;
DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance();
System.out.println(XmlFileName);
try {
db=dbf.newDocumentBuilder();
mapDoc=db.parse(XmlFileName);
dataDoc=db.newDocument();
} catch (ParserConfigurationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SAXException e) {
// TODO Auto-generated catch block
System.out.println("sax");
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
System.out.println("IO ->");
e.printStackTrace();
}
Connection con;
Statement st;
ResultSet rs;
ResultSetMetaData rsd=null;
Element DocRoot=null;
String query="select * from StationarRequest";
try {
Class.forName(DbConnect.getDriverName());
con=DriverManager.getConnection(DbConnect.getDsnName(),DbConnect.getUid(),DbConnect.getPwd());
st=con.createStatement();
rs=st.executeQuery(query);
rsd=rs.getMetaData();
DocRoot=dataDoc.createElement("StationaryDb");
while(rs.next())
{
Element row=dataDoc.createElement("Stationary");
for(int i=0;i<rsd.getColumnCount();i++)
{
String colName=rsd.getColumnName(i);
String colType=rsd.getColumnTypeName(i);
System.out.println(colType);
String colValue="";
if(colType.equals("String"))
{
colValue=rs.getString(i);
}
else if(colType.equals("int"))
{
colValue=rs.getInt(i)+"";
}
else if(colType.equals("float"))
{
colValue=rs.getFloat(i)+"";
}
else if(colType.equals("double"))
{
colValue=rs.getDouble(i)+"";
}
Element DataCol=dataDoc.createElement(colName);
DataCol.appendChild(dataDoc.createTextNode(colValue));
row.appendChild(DataCol);
}
DocRoot.appendChild(row);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("class");
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("sql");
e.printStackTrace();
}
dataDoc.appendChild(DocRoot);
System.out.println("The Result Set is written into XML File");
}
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

K Sathya Narayanan,
Javaranch tip:
If you use UBB CODE tags] when posting your code, the indentation will be preserved. It will also use a mono spaced font.
Doing this will increase the chances that someone will read it enough to spot the problem.


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12759
    
    5
I see creation of a DOM in memory but I don't see where that DOM is used to create either a file on the server or as output to the response.

Status 500 just says something went wrong. Are you getting the System.out.print messages where you can see them? Right now we have no information as to what went wrong.

The usage db.parse(XmlFileName) probably is throwing an IOException because it can't find the file. Code that depends on the "current" directory simply does not work in a servlet.

Surely you can get those stack traces logged better.

Bill
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Issue Req Storing Result Set Data in a XML File
 
Similar Threads
Struts 2 --java.lang.NullPointerException
performance issue in iterating through large list of result set
upgrading UTF data from mysql 4.0 to 4.1 script
Resultset processes 1 record
Getting value of static variable with Reflection ?