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
