the code which u havwe written is wrong.....write
stmt.executeUpdate("update user set pass='india' where eno=1001");
Regards
Laxmikanth M S
Off : 91-80-6610330 extn 1256
http://www.sonata-software.com
> Coming together is the beginning, staying together is progress and working
> together is Success
What lies behind us and what lies before us are tiny matters compared to
what lies within us - Emerson
> -----Original Message-----
> From: arun s [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 03, 2003 12:16 PM
> To: [EMAIL PROTECTED]
> Subject: JSP Exception
>
> hi,
> Here Im connecting to DB2 database and Im able to retrieve datas from
> data
> base but the pblm is Im unable to update the table.
> I use the query
>
> ResultSet rs1=stmt.executeQuery("update user set pass='india' where
> eno=1001");
>
> in my JSP page. I get exception as
>
>
> 500 Servlet Exception
> COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY cannot
> be found.
> at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throwInvalidQueryError(Unknown
> Source)
> at COM.ibm.db2.jdbc.app.DB2Statement.executeQuery(Unknown Source)
> at _final._cpass__jsp._jspService(/final/cpass.jsp:31)
> at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
> at com.caucho.jsp.Page.subservice(Page.java:497)
> at
> com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
> at com.caucho.server.http.Invocation.service(Invocation.java:312)
> at
> com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
> at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:244)
> at
> com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
> at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
> at java.lang.Thread.run(Thread.java:536)
>
>
>
>
> Can any one say how to solve it plz.
>
> rgds,
> karthik
>
> _________________________________________________________________
> Help STOP SPAM: Try the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> ==========================================================================
> =
> 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://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
*********************************************************************
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************
===========================================================================
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://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
