Re: [dbforms] Populating Date Fields on Insert

Bill Tribley Wed, 06 Apr 2005 22:04:22 -0700

Henner, I agree, triggers are the way to go. However, we are not using MySQL 5 yet, so no triggers. The Bookstore example is proving to be a really good way to help me spin up to speed. Bill

Augusto, Thank you very much for the example and encouragement to do an interceptor. I was avoiding advanced topics until I got better with the basics.

It worked, except for some reason the MySQL now() function, which does return date and time in a test off to the side, is not populating the time when used by the interceptor, only the date. This is a small detail.

The really important thing is that I now have creation dates and can move forward. I may be making more use of interceptors. As the manual points out, they are a great way to do server-side validation.

Bill

On Wed, 6 Apr 2005 10:15:42 -0500 (CDT), Augusto Meza Lizardi <[EMAIL PROTECTED]> wrote:

use interceptors to set values for creation_date and
other values before the insert  event, look  in the
examples directory ,
/bookstore/WEB-INF/src/interceptors/BookstoreInsertDataInterceptor.java

i use it  for this purpose, i change the preInsert
method for this

 public int preInsert(HttpServletRequest request,
                        Table              table,
                        FieldValues
fieldValues,
                        DbFormsConfig      config,
                        Connection         con) throws
ValidationException {
      String     fieldName = table.getName() + "_ID";
      FieldValue fv        =
fieldValues.get(fieldName);

         String qry = "select sysdate() ";
         String fecha="";

         try {
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(qry);
            rs.next();
            fecha  = rs.getString(1);
            stmt.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }

         setValue(table, fieldValues,
"fecha_creacion", fecha);
         setValue(table, fieldValues,
"fecha_modificacion", fecha);

      return GRANT_OPERATION;
   }

--- Bill Tribley <[EMAIL PROTECTED]> wrote:

I have a form working perfectly except that the
creation date is null. I
want to use a hidden textField with an overrideValue
that will force this
creation date to be the system date at the time the
page loads.

Any ideas on how I could find out what would throw
this exception? Log
does not point to any jsp page number:

At webapp reload:
2005-04-06 00:31:47
StandardContext[/manager]Manager: restart: Reloading

web application at '/prayerdb'
2005-04-06 00:31:52
StandardContext[/prayerdb]config: finalizing
2005-04-06 00:33:09 ApplicationDispatcher[/prayerdb]
Servlet.service() for
servlet jsp threw exception
java.lang.ThreadDeath
         at

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1229)

at

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)


At page reload after webapp reload:
2005-04-06 00:33:09 StandardWrapperValve[control]:
Servlet.service() for
servlet control threw exception
java.lang.ThreadDeath
         at

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1229)

at

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)

at

java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)

at

org.apache.log4j.spi.LoggingEvent.<init>(LoggingEvent.java:145)

at

org.apache.log4j.Category.forcedLog(Category.java:372)

         at
org.apache.log4j.Category.log(Category.java:864)

My code to implement the date:

<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>
<html>
<%@ page import="java.util.Date,java.text.*" %>
<%!
Date d = new Date();
SimpleDateFormat df = new
SimpleDateFormat('yyyy-MM-dd k:mm:ss');
%>

---- code removed for clarity, line below is a test
expression in the body
-----

The Date Is <%= df.format(d); %>


Thanks in advance for any insight.

Bill

-------------------------------------------------------

SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT
Products from real users.
Discover which products truly live up to the hype.
Start reading now.

http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click

_______________________________________________
DbForms Mailing List

http://www.wap-force.net/dbforms


_________________________________________________________
Do You Yahoo!?
Informaci�n de Estados Unidos y Am�rica Latina, en Yahoo! Noticias.
Vis�tanos en http://noticias.espanol.yahoo.com


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
DbForms Mailing List

http://www.wap-force.net/dbforms

-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
DbForms Mailing List

http://www.wap-force.net/dbforms

Re: [dbforms] Populating Date Fields on Insert

Reply via email to