tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Filip Hanik" <fi...@filip.net>
Subject Re: Parsing text to date - Urgent
Date Sat, 20 Jan 2001 18:16:39 GMT
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
filip@filip.net

----- Original Message -----
From: "Venkata Ratnam Vadlamannati" <venkat_at_work@yahoo.com>
To: <tomcat-user@jakarta.apache.org>
Cc: <JSP-INTEREST@java.sun.com>; <tomcat-dev@jakarta.apache.org>
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: vadlamannati@yahoo.com



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

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, email: tomcat-user-help@jakarta.apache.org


Mime
View raw message