Data type to access a datetime field in database AGAIN. Please help!

[Jose Fresnadillo]

Hi, I'm trying to access a datatime field in a SQL-SERVER 7.0 with a EJB CMP but I don't know which java type I have to use in the bean to map this field.  I've tried with a java.util.Date type but I get the following error when i try to change the value of the data field:   javax.ejb.EJBException: Error saving state: [Microsoft] [ODBC SQL Server Driver] Datatime field overflow     at Persona_EntityBeanWrapper0.saveState(Persona_EntityBeanWrapper0.java:3092)     at Persona_EntityBeanWrapper0.setPer_fecha_nac(Persona_EntityBeanWrapper0.java:2964)     at NewCmp.doGet(NewCmp.java:51)     at javax.servlet.http.HttpServlet.service(HttpServlet.java)     at javax.servlet.http.HttpServlet.service(HttpServlet.java)     at javax.servlet.http.HttpServlet.service(HttpServlet.java)     at com.evermind.server.http.d1.si(JAX)     at com.evermind.server.http.d1.forward(JAX)     at com.evermind.server.http.ed.sp(JAX)     at com.evermind.server.http.ed.so(JAX)     at com.evermind.util.f.run(JAX)   I have the following type mapping in the database-schema definition for sql-server:      <type-mapping type="java.util.Date" name="datetime" />   but it still doesn't work.    This is what I'm doing:    .  .  .  java.util.Date d = new java.util.Date(2004, 11, 27);   Context context = new InitialContext();        Object homeObject = context.lookup("java:comp/env/Table1"); Table1Home home = (Table1Home)PortableRemoteObject.narrow(homeObject, Table1Home.class);        Table1 e = home.findByPrimaryKey("1234"); --> this works  e.setA(d);       ----> this is the line where i get the error.   The code for setA is the following:   public void setA(java.util.Date newValue) {     this.a = newValue;    }     Thanks.