u should put ":" instead of "." as seperator ...
i lined errors with "----"
1...use " " to a complete the statement
u should write
2...Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
replace this and have a go ...
good luck ....
--- Martin Smith <[EMAIL PROTECTED]> wrote:
> Shouldn't he put "." and not ":" as separators in
> that Class.forName string?
>
> mfs
>
>
> T L wrote:
>
> > It seemes the compiler did not find your JDBC
> driver. You are using
> > JDBC:ODBC, then
> use"Class.forName("jdbc:odbc:JdbcOdbcDriver")". It
> is in the
> > java.sql package.
> > good luck
> >
> > >From: JEANCHG <[EMAIL PROTECTED]>
> > >Reply-To: A mailing list about Java Server Pages
> specification and
> > > reference <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: JSP connects to DB
> > >Date: Tue, 7 Nov 2000 16:05:29 +0800
> > >
> > >I am new to this field, so I have some silly
> questions here.
> > >
> > >Can I call directly the method in JDBC classes in
> my jsp file to connect to
> > >my database, or it is necessary to write a
> connection bean to connect the
> > >DB.
> > >
> > >My JSP source code:
> > >
> > ><%@ page language="java" %>
> > ><%@ page import="java.lang.*" %>
> > ><%@ page import="java.sql.*" %>
-------> > ><%@ page contentType="text/html;
charset=Big5" %>
-------> > ><%Class.forName("Driver");%>
> > ><%String url="jdbc:odbc:localhost";%>
> > ><%Connection
>
con=DriverManager.getConnection(url,"1234567890","1111");%>
> > ><%Statement stmt =con.createStatement();%>
> > ><%String test="select * from tbl_eDN";%>
> > ><%ResultSet rs=stmt.executeQuery(test);%>
> > >
> > >But the error message on the web page is:
> > >
> > >Error: 500
> > >Location: /examples/jsp/jean/DBtest.jsp
> > >Internal Servlet Error:
> > >
> > >javax.servlet.ServletException: Unable to load
> class Driver
> > > at
> >
>
>org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
> > >l.java:386)
> > > at
> >
>
>jsp.jean._0002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0._jspService(_0
> >
>
>002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0.java:111)
> > > 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.ja
> > >va: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(ServletWrapper.java:503)
> > > at
> >
>
>org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> > > at
> >
>
>org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
> > >(Ajp12ConnectionHandler.java:156)
> > > at
> >
>
>org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
> > >)
> > > at java.lang.Thread.run(Thread.java:484)
> > >
> > >Root cause:
> > >java.lang.ClassNotFoundException: Unable to load
> class Driver
> > > at
> >
>
>org.apache.jasper.runtime.JspLoader.findClass(JspLoader.java:184)
> > > at
> >
>
>org.apache.jasper.runtime.JspLoader.loadClass(JspLoader.java:136)
> > > at
>
java.lang.ClassLoader.loadClass(ClassLoader.java:253)
> > > at
>
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
> > > at java.lang.Class.forName0(Native
> Method)
> > > at
> java.lang.Class.forName(Class.java:120)
> > > at
> >
>
>jsp.jean._0002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0._jspService(_0
> >
>
>002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0.java:72)
> > > 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.ja
> > >va: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(ServletWrapper.java:503)
> > > at
> >
>
>org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> > > at
> >
>
>org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
> > >(Ajp12ConnectionHandler.java:156)
> > > at
> >
>
>org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
> > >)
> > > at java.lang.Thread.run(Thread.java:484)
> > >
> > >Thanks
> > >
> >
>
>===========================================================================
> > >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
> >
> >
>
_________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> >
> > Share information about yourself, create your own
> public profile at
> > http://profiles.msn.com.
> >
> >
>
===========================================================================
> > 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
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.com/
===========================================================================
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
