Yep,
I did have the import statement at the beginning of the file.
JOdy
----- Original Message -----
From: "m venkateswara rao" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 5:21 AM
Subject: Re: JSP->DB error
> Hi..
> I wonder whether you did use import java.sql.* or not.
> If you don't use, then it might look for the statement , resultset classes
> of com.caucho.jdbc.mysql package.
> If you use import java.sql.*, your problem can be resolved.
> with rgds,
> M.V.Rao
> Wipro Technologies
> Survey No 64, Madhapur
> Hyderabad - 500 033 , India.
> Tel(w): +91-40-656 5334(direct), Board +91-40-656 5000
> Tel(h): +91-40-657 7762
> E-mail:[EMAIL PROTECTED]
> Corporate Web Site : www.wipro.com
> The World's First SEI CMM Level 5 Software Services Company
> ----- Original Message -----
> From: Jody F. Kerr <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, February 27, 2001 7:54 AM
> Subject: JSP->DB error
>
>
> > Hello Folks,
> >
> > I'm trying to connect from a jsp page to a MySQL database, both
resdiding
> > on
> > a Win2K box running Apache and Resin. I went through everything, and am
> > pretty
> > certain
> > I have all the configs correct. I get the following error when I load
the
> > jsp page:
> >
> > 500 Servlet Exception
> > java.lang.VerifyError: (class: com/caucho/jdbc/mysql/ResultSet, method:
> > findColumn signature: (Ljava/lang/String;)I) Incompatible object
argument
> > for function call
> > at com.caucho.jdbc.mysql.Statement.<init(Statement.java:65)
> > at
com.caucho.jdbc.mysql.Connection.createStatement(Connection.java:153)
> > at
> >
> >
>
_jsp._www__studebakercars__com_0._dbquery__jsp._jspService(_dbquery__jsp.jav
> > a, Compiled Code)
> > at com.caucho.jsp.JavaPage.service(JavaPage.java:89)
> > at com.caucho.jsp.JavaPage.subservice(JavaPage.java:83)
> > at com.caucho.jsp.Page.service(Page.java:280)
> > at com.caucho.jsp.QServlet.service(QServlet.java:161)
> > at
> > com.caucho.server.http.AbstractRequest.service(AbstractRequest.java:452)
> > at
> > com.caucho.server.http.AbstractRequest.service(AbstractRequest.java:395)
> > at com.caucho.server.http.PageCache$Entry.service(PageCache.java:256)
> > at com.caucho.server.http.PageCache.service(PageCache.java:105)
> > at com.caucho.server.http.VirtualHost.service(VirtualHost.java:406)
> > at com.caucho.server.http.Request.dispatch(Request.java:211)
> > at
> >
> com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:307)
> > at
> >
com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java,
> > Compiled Code)
> > at com.caucho.server.TcpConnection.run(TcpConnection.java, Compiled
Code)
> > at java.lang.Thread.run(Thread.java:479)
> >
> >
> > I checked my classpaths and everything looks ok. The code itself is
right
> > out of the Wrox Professional JSP book.
> > Here's the relevant code snippet:
> >
> > <%
> > Class.forName("com.caucho.jdbc.mysql.Driver");
> > Connection myConn =
> >
> DriverManager.getConnection("jdbc:mysql-caucho://localhost:3306/wroxjsp");
> > Statement stmt = myConn.createStatement();
> > ResultSet myResultSet = stmt.executeQuery("select * from employee");
> > if (myResultSet != null){ while (myResultSet.next()){ String eid =
> > myResultSet.getString("empid"); String last =
> > myResultSet.getString("lastname"); String first =
> > myResultSet.getString("firstname"); String ext =
> > myResultSet.getString("extension");%
> >
> >
> > Many thanks
> > Jody
> >
> >
>
===========================================================================
> > 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
>
===========================================================================
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
