Dear all,
I tried to make xml from my bean, and it run as I wanted it. But when I
wanted to create a JSP
which it can show data from that xml into JSP, I got these error message :
Unhandled error! You might want to consider having an error page to report
such errors more gracefully
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Function
sequence error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLFetch(JdbcOdbc.java:1250)
at sun.jdbc.odbc.JdbcOdbcResultSet.next(JdbcOdbcResultSet.java:1053)
at dbconnect.throwData(dbconnect.java, Compiled Code)
at
C_0003a.xml_0002dtr_00032.TIMAH.timah_0005fsementara.src.jsp_0005ftimah_0005
fsementara.test_0005fpertama_jsp_11._jspService(test_0005fpertama_jsp_11.jav
a:104)
at com.sun.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at
com.sun.jsp.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:88)
at com.sun.jsp.runtime.JspServlet.serviceJspFile(JspServlet.java:218)
at com.sun.jsp.runtime.JspServlet.service(JspServlet.java:294)
at com.borland.jbuilder.runtime.JspLoaderEcho.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:155)
at com.sun.web.core.Context.handleRequest(Context.java:414)
at com.sun.web.server.ConnectionHandler.run(ConnectionHandler.java:139)
Could you help me for this ?
Herewith I attach my bean and my JSP script :
1.This is my bean =
import java.sql.*;
public class dbconnect {
private Statement stmt;
private ResultSet rs;
public static void main(String argv[]) {
dbconnect db = new dbconnect();
}
public dbconnect() {
try
{ //register the driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connectDB();
runQuery("Select Product_Line,Product_Number from Table1");
displayData();
stmt.close();
}
catch (Exception e)
{ e.printStackTrace();
}
}
private void connectDB() throws SQLException {
// Prepare the connection URL
String db = "test_xml";
String url = "jdbc:odbc:" + db;
Connection con = DriverManager.getConnection(url,"test","coba");
stmt = con.createStatement();
}
private void runQuery(String aSQLStatement) throws SQLException {
rs = stmt.executeQuery(aSQLStatement);
}
private void displayData() throws SQLException {
String strXML = "<?xml version='1.0'?><root>";
while (rs.next())
{ String pl = rs.getString("Product_Line");
String pn = rs.getString("Product_Number");
strXML += "<child>\n<line>" + pl + "</line>\n";
strXML += "<no>" + pn + "</no>\n</child>" + "\n";
}
strXML += "</root>";
System.out.print(strXML);
}
public String throwData() throws SQLException {
String strXML = "<?xml version='1.0'?><root>";
while (rs.next())
{ String pl = rs.getString("Product_Line");
String pn = rs.getString("Product_Number");
strXML += "<child>\n<line>" + pl + "</line>\n";
strXML += "<no>" + pn + "</no>\n</child>" + "\n";
}
strXML += "</root>";
return strXML;
}
};
2. This is my JSP :
<HTML>
<HEAD>
<%@ page import ="dbconnect" %>
<jsp:useBean id="coba" scope="session" class="dbconnect" />
<jsp:setProperty name="coba" property="*" />
<TITLE></TITLE>
</HEAD>
<BODY>
<%! String str = ""; %>
<% out.println("<XML id='test'>\n");
str = coba.throwData();
out.println(str);
out.println("\n</XML>");
%>
<% out.println(str); %>
<table datasrc="#test">
<tr>
<td><span datafld='line'></td>
<td><span datafld='no'></td>
</tr>
</table>
</BODY>
</HTML>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
