Hi, Jody. Another possible case would be that you are trying to access a
field after retrieving empid field which is before empid. Try accessing
fields according to their field position. (e.g. if table fields are
lastname, firstname, empid, access lastname first and then firstname and
lastly empid)......
why not use the mysql driver found in http://mmmysql.sourceforge.net/
:^)
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 11:12 PM
> To: [EMAIL PROTECTED]
> Subject: Re: JSP->DB error
>
> Ricky,
>
> The empid field was actually an int. I switched the code to
> int eid = myResultSet.getInt("empid")
>
> But that's not resolving the error. I'm still learning/figuring out how to
> read the error messages, so I'm still not certain what I'm looking at. The
> remaining fields are all text fields in the db.
>
> Thanks
>
> Jody
>
> > 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
> >
>
> ==========================================================================
> =
> 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
