> 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/
I talked to the folks at Caucho (makers of Resin). Their driver has a bug in
it. I switched over to the MySQL drivers and it all worked perfectly.
thanks for the help
Jody
> :^)
> 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
>
===========================================================================
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
