-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Possible bug with Criterion queries?!
PostPosted: Fri Apr 18, 2008 7:15 pm 
Beginner
Beginner

Joined: Thu Feb 28, 2008 11:53 am
Posts: 23
Hibernate version: 3.2
Mapping documents: Using XML
Name and version of the database I am using: Oracle XE/10G

Code:
2008-04-10 19:11:20,369 INFO [net.tp.util.CriterionFactoryForFilterTypes] - <From the criterion factory 1196658000000 and pattern yyyy-MM-dd>

The log line above shows the date (in milliseconds) that the user enters as well as the date pattern
Code:
2008-04-10 19:10:30,947 INFO [net.tp.util.DateUserType] - < The date coming back 1196658000000>

The log line above shows the date (in milliseconds) that DateUserType -- an implementation of UserType -- gets from the db but according to Hibernate the 2 dates do not match as a matter of fact anytime I run Criterion query with dates I get back absolutely no results and no error is thrown.
Code:
2008-04-10 19:11:20,447 INFO [net.tp.biz.FilterToHibernateMapper] - <Criteria info CriteriaImpl(net.tp.domain.HibernateRequestObject:this[][dateCreated=Mon Dec 03 00:00:00 EST 2007, ()])>

The above log line is the Criteria.toString() method before it is executed by Criteria.list(). This shows what date the user entered and the property I am querying.
Code:
2008-04-10 19:17:35,322 INFO [net.tp.DateUserType] - < The date coming back Mon Dec 03 00:00:00 EST 2007>

The above log line is the date in the UserType implementation; I see nothing wrong with the dates, they look identical so why is it not returning a result, I am just baffled and frustrated.

Can anyone shed some light please??

Below is my implementation of UserType, modified from my earlier post
Code:

import java.io.Serializable;
import org.hibernate.usertype.UserType;
import org.hibernate.Hibernate;
import org.hibernate.HibernateException;

import java.util.Date;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import org.apache.log4j.Logger;



public class DateUserType implements UserType
{
   private static final int[] SQL_TYPES = new int[] { Types.TIMESTAMP };
   private static final Logger log = Logger.getLogger(DateUserType.class);
   private static final DateFormat shortDate=new SimpleDateFormat("yyyy-MM-dd");
   
   public DateUserType(){
       super();
   }
 
   public int[] sqlTypes() {
      return SQL_TYPES;
   }

 
   public Class returnedClass() {
      return java.util.Date.class;
   }
   
   
   public boolean equals(Object x, Object y) throws HibernateException {
        if (x instanceof Date) {
                Date date1 = (Date) x;
            if (y instanceof Date) {
                Date date2 = (Date) y;
            //if(shortDate.format(date1).equalsIgnoreCase(shortDate.format(date2))){
              if(date1.equals(date2)){
                return true;
                }
            }
        }
        return false;
   }

   
   public Object nullSafeGet(ResultSet rs, String[] names, Object owner)throws HibernateException, SQLException
   {
      Date date;
      long milliseconds;
      Timestamp timestamp = (Timestamp) Hibernate.TIMESTAMP.nullSafeGet(rs, names[0]);//I think so :(
             
      if( timestamp==null )
      {
         return null;
      }
      else
      {   
         milliseconds = timestamp.getTime() + (timestamp.getNanos() / 1000000);
         try {
            log.info(" The date coming back "+shortDate.parse(shortDate.format(milliseconds))); 
            return shortDate.parse(shortDate.format(milliseconds));
         }
         catch(ParseException pe){
             throw new RuntimeException(pe.getMessage());
         }
         
      }
   }


 
   public void nullSafeSet(PreparedStatement st, Object value, int index)throws HibernateException, SQLException
   {
      // handle the NULL
      if( value==null )
      {
         st.setTimestamp(index, null);
         return;
      }
     
     
      if( ! Date.class.isAssignableFrom(value.getClass()) ) {
         throw new IllegalArgumentException("Required a (java.util.Date) but received a [" + value.getClass() + "]");
      }

     
      Timestamp tstamp = null;
      if( (value instanceof Timestamp) )
      {
         tstamp = (Timestamp) value;
      }
      else
      {
         tstamp = new Timestamp( ((Date) value).getTime() );
      }
     
      st.setTimestamp(index, tstamp);
   }



   public Object deepCopy(Object value) throws HibernateException {
      if( value==null )
      {
         return null;
      }
      else
      {   
         return ((Date) value).clone();
      }
   }

 
   public boolean isMutable() {
      return true;
   }
   
   //optional
   public Serializable disassemble(Object value) throws HibernateException {
        return (Serializable) value;
    }

    public Object assemble(Serializable cached, Object owner) throws HibernateException {
        return cached;
    }

    public Object replace(Object original, Object target, Object owner) throws HibernateException {
        return deepCopy(original);
    }
   
    public int hashCode(Object x){
        return x.hashCode();
    }

}


my criteria factory
Code:
public class CriterionFactoryForFilterTypes {
    private final static ArrayList<Criterion> criterion;
    private final static SimpleDateFormat format;
    private final static Logger log;
   
    static{
        criterion = new ArrayList<Criterion>();
        format = new SimpleDateFormat("yyyy-MM-dd");
        log = Logger.getLogger(CriterionFactoryForFilterTypes.class);
    }
        public static List<Criterion> matchTypeToCriteria(final List<Filter> filters){
          if(!criterion.isEmpty())
              criterion.clear();
          for(Filter f:filters)
              getCriteria(f);
          return Collections.unmodifiableList(criterion); 
        }
       
        private static void getCriteria(final Filter filter){
            Date date;
            final String type = filter.getType();
           
            if(type.equals("string"))
                criterion.add(Restrictions.ilike(filter.getField(),filter.getValue(),MatchMode.ANYWHERE));
           
            if(type.equals("numeric"))
            {
                switch(filter.getComparison())
                {
                    case eq:criterion.add(Restrictions.eq(filter.getField(), new Long(filter.getValue())));break;
                    case lt:criterion.add(Restrictions.lt(filter.getField(), new Long(filter.getValue())));break;
                    case gt:criterion.add(Restrictions.gt(filter.getField(), new Long(filter.getValue())));break;
                }
            }
           
            if(type.equals("date"))
            {
                try
                {
                    date = format.parse(filter.getValue().trim());
                }
                catch(ParseException pe)
                {
                    throw new RuntimeException("The date was not formatted correctly [ format: " + format.toPattern()+" value = "+filter.getValue().trim() + "]");
                }               
                switch(filter.getComparison())
                {
                   
                    case eq:criterion.add(Restrictions.eq(filter.getField(), date));log.info("From the criterion factory "+ date.getTime()+ " and pattern "+format.toPattern());break;
                    case lt:criterion.add(Restrictions.lt(filter.getField(), date));break;
                    case gt:criterion.add(Restrictions.gt(filter.getField(), date));break;
                }               
            }
           
            if(type.equals("list"))
            {
                String[] inParameters = filter.getValue().split(",");
                criterion.add(Restrictions.in(filter.getField(),inParameters));
            }
        }
       
       
}



Any ideas anyone???!


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.