couple of things,
1. Don't cross post this to three different lists. Tomcat dev is for the
developers of tomcat and development related issues.
2. Try to convert your string into a Date before you pass it into the
prepared statement. A Date object is not of the same class as a String
object.
Date date = convertyMyStringToDate(string)
ps.setDate(3,date)
Filip
~
Namaste - I bow to the divine in you.
~
Filip Hanik
Technical Architect
[EMAIL PROTECTED]
----- Original Message -----
From: "Venkata Ratnam Vadlamannati" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 20, 2001 5:18 AM
Subject: Parsing text to date - Urgent
Dear All
I am taking date from an HTML form in 01/01/2001
format and take read this in a jsp page as
request.getParameter("date")
I try to put this in my MSSQL Server 7 table (table
column is date with 8 characters width - default) with
a prepared statement, it gives the following error:
***************
Error: 500
Location:/tests/test2.jsp
Internal Servlet Error:
org.apache.jasper.JasperException: Unable to compile
class for
JSPD:\tomcat\work\localhost_8080%2Ftests\_0002ftest_00032_0002ejsptest2_jsp_
3.java:194:
Incompatible type for method. Can't convert
java.lang.String to java.sql.Date.
ps.setDate(2,request.getParameter("publishdate"));
^
D:\tomcat\work\localhost_8080%2Ftests\_0002ftest_00032_0002ejsptest2_jsp_3.j
ava:195:
Incompatible type for method. Can't convert
java.lang.String to java.sql.Date.
ps.setDate(3,request.getParameter("archivedate"));
^
2 errors
at
org.apache.jasper.compiler.Compiler.compile(Compiler.java:254)
at
org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:453)
at
org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at
org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:424)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:152)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:164)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:309)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:382)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:387)
at
org.apache.tomcat.core.Handler.service(Handler.java:263)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:371)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:74
9)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:695)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:403)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
***************
Can anybody suggest me as how do I put this into my
table
Thanks in advance
Venkat
mail to: [EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
