call e.printStackTrace() in your empty catch blocks. It will probably give
more hints
> -----Original Message-----
> From: Jonas Devries [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 18, 2001 10:35 AM
> To: [EMAIL PROTECTED]
> Subject:
>
>
> Does somebody knows why this code doesn't work? I want to
> acces a MS =
> Access DB and give a simple query. I give the ResultSet back
> to my JSP =
> file but he gives some errors. JSP and Java-bean are
> included. Errors =
> also. There is data in the db and the odbc-jdbc driver is installed.
>
> Thank you very much in advance
>
> Jonas
>
>
> import java.sql.*;
> import java.util.*;
>
> public class databank {
>
> private String driver =3D "sun.jdbc.odbc.Jdbc.OdbcDriver";
> private String url =3D "jdbc:odbc:db1";
> private Connection connection;
> private Statement statement;
> private ResultSet res;
> private ResultSetMetaData meta;
> private String naam;
> private int aantal;
>
> public databank(){}
> =20
> =20
> public ResultSet lijst(){
>
> try {
> String query =3D "select * from klant";
> Class.forName(driver);
> connection =3D DriverManager.getConnection(url); =20
> statement =3D connection.createStatement();
> res =3D statement.executeQuery(query); =20
> =20
> }
> catch (SQLException e){}
> catch (ClassNotFoundException cnfex){}=20
>
> return res;
>
> }
>
> }
>
>
>
>
> ResultSetMetaData meta =3D res.getMetaData(); int aantal =3D
> meta.getColumnCount(); %> while (res.next()){ for (kol =3D 1; kol <=3D
> aantal; kol++) %>
>
>
>
>
>
> Error: 500
> Location: /test9.jsp
> Internal Servlet Error:
>
> javax.servlet.ServletException
> at =
> org.apache.jasper.runtime.PageContextImpl.handlePageException(
> PageContext=
> Impl.java:386)
> at =
> _0002ftest_00039_0002ejsptest9_jsp_0._jspService(_0002ftest_00
> 039_0002ejs=
> ptest9_jsp_0.java:126)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at =
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.service
> (JspServlet=
> .java:174)
> at =
> org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet
> .java:261)
> at
> org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at =
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWra
> pper.java:5=
> 03)
> at =
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> at =
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.pro
> cessConnect=
> ion(Ajp12ConnectionHandler.java:156)
> at =
> org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEnd
> point.java:=
> 338)
> at java.lang.Thread.run(Thread.java:484)
>
> Root cause:=20
> java.lang.NullPointerException
> at =
> _0002ftest_00039_0002ejsptest9_jsp_0._jspService(_0002ftest_00
> 039_0002ejs=
> ptest9_jsp_0.java:93)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at =
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.service
> (JspServlet=
> .java:174)
> at =
> org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet
> .java:261)
> at
> org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at =
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWra
> pper.java:5=
> 03)
> at =
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> at =
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.pro
> cessConnect=
> ion(Ajp12ConnectionHandler.java:156)
> at =
> org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEnd
> point.java:=
> 338)
> at java.lang.Thread.run(Thread.java:484)
>
>
> ______________________________________________________________
> ___________
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
> "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set
> JSP-INTEREST DIGEST".
> 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".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
