you may be accessing a non-String value with the getString() method.
Is the empid field of String datatype?
:^)
Ricky Y. Artigas
Analyst/Programmer
Information Technology Division
Easycall Communications Phils., Inc.
- Easycall Internet -
418 Arayat St., Mandaluyong City 1550, Philippines
Personal WAP Site: http://www.buzzed.co.uk/mobile/?rya
Company Website: http://www.easycall.com.ph
Tel.no: (+632) 5338001 ext.6574
Mobile:(+63) 0917-8951783
Pager: 141-002955
Email: [EMAIL PROTECTED]
> -------------------------------
> IMPORTANT NOTICE:
> This message (and any attachment hereto) may contain privileged and/or
> confidential information specific to EasyCall. If you are not the intended
> addressee indicated in this message, you may not copy or disseminate this
> message (or any attachment hereto) to anyone. Instead, please destroy this
> message (and any attachment hereto), and kindly notify the sender by reply
> email. Any information in this message (and any attachment thereto) that
> do not relate to the official business of EasyCall shall be understood as
> neither given nor endorsed by the company.
>
>
> -----Original Message-----
> From: Jody F. Kerr [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 27, 2001 10:24 AM
> To: [EMAIL PROTECTED]
> 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.j
> av
> 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
