Null problem(java.sql.TimeStamp) for iBatis

Hi all,

I am using iBatis with oracle database. I found that if the database date field is null, the iBatis throws nullPointerException.

--- Check the result mapping for the 'activationDate' property.
--- Cause: com.ibatis.common.beans.ProbeException: Could not set property 'activationDate' for java.util.Hashtable. Cause: java.lang.NullPointerException

I search the JavaDoc and seems the java.sql.Timestamp/Date does not allow null value.

1) How to solve this? I can write more steps to convert it back into date but I would like to know if there is other solution...

2) Does Hibernate have the same problem?
[ April 11, 2007: Message edited by: Donald Fung ]

1, in your query, you need to do something like NVL(myDate, someReallyOddDateThatNoRealRecordWouldEverHaveThatYouCanCheckFor)

Or have the database set that field to not allow nulls.

I am not sure if Hibernate has that issue.

Mark

Thanks for your suggestion, Mark.

I had wrote a simple TypeHandler to convert the null field.
It returns null, which as a result that the iBatis set NULL in the returned Object.

Here it is:

package database.handler;
 
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Date;
 
import org.apache.log4j.Logger;
 
import cnms.eAlert.MailRunner;
 
import com.ibatis.sqlmap.client.extensions.ParameterSetter;
import com.ibatis.sqlmap.client.extensions.ResultGetter;
import com.ibatis.sqlmap.client.extensions.TypeHandlerCallback;
 
public class DateTypeHandler implements TypeHandlerCallback {

static Logger log = Logger.getLogger(DateTypeHandler.class.getName());
 
   public void setParameter(ParameterSetter setter, Object parameter)
throws SQLException {
       if (parameter == null) {
           setter.setNull(java.sql.Types.TIMESTAMP);
       } else {
           Date date = (Date) parameter;
           Timestamp oracleDate = new Timestamp(date.getTime());
           setter.setObject(oracleDate);
       }
   }
 
   public Object getResult(ResultGetter getter) throws SQLException {
       Timestamp value = null;
       
       if (getter.wasNull()) {
           return null;           
       } else
       {
       if (getter.getTimestamp()==null)
       {
       return null;
       } else
       {
       value = getter.getTimestamp();
       }
       }
       return new Date(value.getTime());
 
   }
 
   public Object valueOf(String s) {
       return s;
   }
 
}

[ April 27, 2007: Message edited by: Donald Fung ]