tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Venkata Ratnam Vadlamannati <venkat_at_w...@yahoo.com>
Subject Parsing text to date - Urgent
Date Sat, 20 Jan 2001 13:18:49 GMT
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.java: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(JspServlet.java:152)
	at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java: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:749)
	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: vadlamannati@yahoo.com



__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/

Mime
View raw message