Thanks Jeff,
But I'm still got the same error message...:(
Could you advise to me about this ?
By the way, I try this (try to make & compile these files : bean and JSP)
in JBuilder 3.0.
Many thanks.
Arsyad.
> -----Original Message-----
> From: Hu Jeff [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, August 19, 2000 1:27 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Why I can't use my bean into my jsp ?
>
> try close your resuletset and connection after closing your statement.
>
> Jeff Hu
>
> -----Original Message-----
> From: Muhammad Arsyad [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 18, 2000 4:53 AM
> To: [EMAIL PROTECTED]
> Subject: Why I can't use my bean into my jsp ?
>
>
> 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_00
> 05
> fsementara.test_0005fpertama_jsp_11._jspService(test_0005fpertama_jsp_11.j
> av
> 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:8
> 8)
> 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
>
> ==========================================================================
> =
> 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
===========================================================================
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
