How to insert date into database?

[Eman Adenola]

Hello,
before I go on...
Now I feel a little better..for the past hour I've been trying to insert a freaking date into the database...a date for crying out loud..
my lecturer stored it as a string...when i convert it into a string to debug i display and it displays fine....to insert it..always a freaking exception

I changed the format to Date/Time in the database..and still no freaking luck..aaargh


So I'm hoping the jsp gods in this forum can help me out here...how can I solve this problem?
How to insert a date into a database?

Btw i am using Access..and I have no choice..i gotta use it..
any help appreciated thanks.

[Bear Bibeault]

What does inserting a date into a database have to do with JSP? I'll move this along to the JDBC forum, where I'm sure you'll get asked for more details.

[Bear Bibeault]

Eman Adenola wrote:always a freaking exception

Perhaps it might be helpful to show the exception?

[Rob Spoor]

Dates and SQL can be a nightmare at time (which format does the server require? month-date-year? day-month-year? will year-month-date always work?), so I always use a PreparedStatement with its setTime, setDate and setTimestamp methods.

[Eman Adenola]

Hey thanks for replying..
@Bear I am trying to use JSTL and JSP..that's why I thought it would be in that forum...sorry.

Exception
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
                     INSERT INTO Reservations(ReservedDate) Values(?)
                
                

                




                  : Unexpected exception : 1
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:536)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:410)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
                     INSERT INTO Reservations(ReservedDate) Values(?)
                
                

                




                  : Unexpected exception : 1
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794)
	org.apache.jsp.webapps.LibraryWebsite.reserve_jsp._jspService(reserve_jsp.java:288)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

java.sql.SQLException: Unexpected exception : 1
	sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1442)
	sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1074)
	sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1065)
	org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.setParameters(UpdateTagSupport.java:254)
	org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.doEndTag(UpdateTagSupport.java:156)
	org.apache.jsp.webapps.LibraryWebsite.reserve_jsp._jspx_meth_sql_005fupdate_005f0(reserve_jsp.java:745)
	org.apache.jsp.webapps.LibraryWebsite.reserve_jsp._jspx_meth_c_005fif_005f1(reserve_jsp.java:671)
	org.apache.jsp.webapps.LibraryWebsite.reserve_jsp._jspService(reserve_jsp.java:218)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

One of many attempts

 
  <% SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy") ;

         String d=sdf.format(new Date()).toString();
      %>

        <c:set value="<%=sdf.format(new Date()).toString()%>" var="date"/>
              <c:if test="${res.rowCount > 0 && res.rows[0].NoBooksReserved<6}">
              
                     <sql:update dataSource="${datasource}" var="insert">
                           INSERT INTO Reservations(ReservedDate) Values(?)
                              
                               <sql:param value='${date}'/>




                  </sql:update>

               

The format is dd-mm-yyyy

@Rob I will google that PreparedStatement and see if I can resolve the problem thanks.

[Eman Adenola]

mmn...I think I resolved the problem now..
I used the same code I had..but it appears that one of the fields is a primary key...as a result inserting the same primary twice into database throws the exception.I
It's ridiculous..I would have thought a simple error to suffice...I think I can make my way from here now..if not i'll be back ha ha

Thanks fellas.

[Bear Bibeault]

Eman Adenola wrote:
@Bear I am trying to use JSTL and JSP..

Yikes! You're using the JSTL SQL tags for real code? Even the JSTL Spec says that those tags are for toy code only. I'd refactor to move the database access to a model layer as soon as possible.

[Eman Adenola]

eh..yeah i thought that was what <sql:update> was for?
And this is only how far.and if this isn't real code..then I am screwed then lol..

[Bear Bibeault]

In a properly structured web application, database access is handled in the model layer, completely sequestered away from the user interface. You may want to look up the concept of MVC and "Model 2".

Perhaps this article can get you started.

[leo donahue]

With regards as to the format the database requires, just issue a select date() query, or your database equivalent, and you'll have the format you need to insert.