weird behavior Hibernate/Mysql in Linux to Windows

**dr_pompeii** · Apr 4th, 2007, 12:58 PM

Hi guys

i have a project with hibernate 3.x and mysql 5.0.27

in linux works normal,no problem, but in windows i recieve this error

Code:

fechaentrega: Wed Apr 04 12:49:55 COT 2007
 

abr 04 12:49:55 WARN  ate.util.JDBCExceptionReporter logExceptions             SQL Error: 1364, SQLState: HY000
abr 04 12:49:55 ERROR ate.util.JDBCExceptionReporter logExceptions             Field 'fechavencimiento' doesn't have a default value
abr 04 12:49:55 ERROR .AbstractFlushingEventListener performExecutions         Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

this part is weird

abr 04 12:49:55 WARN ate.util.JDBCExceptionReporter logExceptions SQL Error: 1364, SQLState: HY000
abr 04 12:49:55 ERROR ate.util.JDBCExceptionReporter logExceptions Field 'fechavencimiento' doesn't have a default value

the weird is that i have 2 subclasses and when i call some controller or action it must work with the subclass typeA for instance but the variable fechavencimiento (date), belongs to the other subclass typeB, so i am not using this for nothing

if i use some tool or a simple reporty in mysql in linux
and if i want to see the row rsult created by default
i can see that the value for the variable (that only belong to the sibling subclass) is (err) , why?

how i can resolve this

thanks for advanced

**karldmoore** · Apr 4th, 2007, 01:27 PM

Is the value indeed null and the column doesn't have a default? I don't know if the two platforms do deal with this differently.

**dr_pompeii** · Apr 4th, 2007, 05:26 PM

hi karl,

well first see this

Code:

idCabeceraCompra     tipo         numdoc       fechaemision     fechacontrolinterno     idEmpresa     idProveedor     fechavencimiento     valorventa     igv     totalfactura     numdocrefguiaremision     numdocreffactura     fechaentrega    
 -------------------  -----------  -----------  ---------------  ----------------------  ------------  --------------  -------------------  -------------  ------  ---------------  ------------------------  -------------------  --------------- 
 1000011              CABCOMGUIA   5456465      4/04/2007        4/04/2007               00200001      100001          (err)                0              0       0                                          45465456465          4/04/2007       
 10000145465456465    CABCOMFACTU  45465456465  4/04/2007        4/04/2007               00200001      100001          4/04/2007            40             0,19    47,6             5456465                                        (null)

see that the field fechavencimiento for the fisrt row is (err) , in linux/mysql i dont have problem, but in mysql windows, i recieve the errors that you seen

and see that for the second row value for fechaentrega is null

and note that each variable is unqiue or belong to each subclass, so
fechavencimiento for the fisrt row should be null and not (err)

here the photo about diagram class
and here the mapping file

Code:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping
>
    <class
        name="com.lagranjita.modelo.entidades.CabeceraCompra"
        table="CabeceraCompra"
        discriminator-value="CABCOM"
    >

        <id
            name="idCabeceraCompra"
            column="idCabeceraCompra"
            type="java.lang.String"
            length="30"
        >
            <generator class="assigned">
              <!--  
                  To add non XDoclet generator parameters, create a file named 
                  hibernate-generator-params-CabeceraCompra.xml 
                  containing the additional parameters and place it in your merge dir. 
              --> 
            </generator>
        </id>

        <discriminator
            column="tipo"
            type="string"
        />

        <property
            name="numdoc"
            type="java.lang.String"
            update="true"
            insert="true"
            column="numdoc"
            length="12"
            not-null="true"
        />

        <property
            name="fechaemision"
            type="date"
            update="true"
            insert="true"
            column="fechaemision"
            not-null="true"
        />

        <property
            name="fechacontrolinterno"
            type="date"
            update="true"
            insert="true"
            column="fechacontrolinterno"
            not-null="true"
        />

        <many-to-one
            name="idEmpresa"
            class="com.lagranjita.modelo.entidades.Empresa"
            cascade="none"
            outer-join="auto"
            update="true"
            insert="true"
            column="idEmpresa"
            not-null="true"
        />

        <many-to-one
            name="idProveedor"
            class="com.lagranjita.modelo.entidades.Proveedor"
            cascade="none"
            outer-join="auto"
            update="true"
            insert="true"
            column="idProveedor"
            not-null="true"
        />

        <set
            name="detalleCompraGuiaRemisiones"
            lazy="true"
            inverse="true"
            cascade="none"
            sort="unsorted"
            order-by="idDetalleCompraGuiaRemision"
        >

            <key
                column="idCabeceraCompra"
            >
            </key>

            <one-to-many
                  class="com.lagranjita.modelo.entidades.DetalleCompraGuiaRemision"
            />

        </set>

        <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-CabeceraCompra.xml
            containing the additional properties and place it in your merge dir.
        -->
        <subclass
            name="com.lagranjita.modelo.entidades.FacturaCompra"
            discriminator-value="CABCOMFACTU"
        >

        <property
            name="fechavencimiento"
            type="date"
            update="true"
            insert="true"
            column="fechavencimiento"
            not-null="true"
        />

        <property
            name="valorventa"
            type="java.math.BigDecimal"
            update="true"
            insert="true"
            column="valorventa"
            length="6"
            not-null="true"
        />

        <property
            name="igv"
            type="java.math.BigDecimal"
            update="true"
            insert="true"
            column="igv"
            length="6"
            not-null="true"
        />

        <property
            name="totalfactura"
            type="java.math.BigDecimal"
            update="true"
            insert="true"
            column="totalfactura"
            length="6"
            not-null="true"
        />

        <property
            name="numdocrefguiaremision"
            type="java.lang.String"
            update="true"
            insert="true"
            column="numdocrefguiaremision"
            length="12"
            not-null="true"
        />

        <one-to-one
            name="idCuentaProveedores"
            class="com.lagranjita.modelo.entidades.CuentaProveedores"
            cascade="none"
            outer-join="auto"
            constrained="false"
            property-ref="facturaCompra"
        />

	    <!--
            	To add non XDoclet property mappings, create a file named
                hibernate-properties-FacturaCompra.xml
		containing the additional properties and place it in your merge dir.
	    -->

        </subclass>
        <subclass
            name="com.lagranjita.modelo.entidades.GuiaRemisionCompra"
            discriminator-value="CABCOMGUIA"
        >

        <property
            name="numdocreffactura"
            type="java.lang.String"
            update="true"
            insert="true"
            column="numdocreffactura"
            length="12"
            not-null="true"
        />

        <property
            name="fechaentrega"
            type="date"
            update="true"
            insert="true"
            column="fechaentrega"
            not-null="false"
        />

	    <!--
            	To add non XDoclet property mappings, create a file named
                hibernate-properties-GuiaRemisionCompra.xml
		containing the additional properties and place it in your merge dir.
	    -->

        </subclass>

    </class>

        <query name="myqueryamountfactura"><![CDATA[
            select count(*) from CabeceraCompra where tipo='CABCOMFACTU' 
        ]]></query>

</hibernate-mapping>

and to end how i create the object with defaults values
i dont think that i forgot some detail, pls ckeck it out

Code:

/**
 * <p>Metodo que sirve para retornar un objeto por default que representa la Cabecera de Guia de Remision</p>
 * @param id del Proveedor, lo uso para crear la PK
 * @return el objecto default
 * @throws MyGlobalException en caso de falla externa lo lanzo globalmente
 */
public GuiaRemisionCompra generargetGuiaRemisionCompraIdGeneradoADO(String idProveedor)
	throws MyGlobalException{
		GuiaRemisionCompra guiaRemisionCompra = new GuiaRemisionCompra();
		try{
guiaRemisionCompra.setIdCabeceraCompra(idProveedor.concat(getNextGuiaRemisionCompra(idProveedor)));
			
			Empresa empresa = (Empresa) getHibernateTemplate().get(Empresa.class, "00200001" );
			empresa.getCabecerascompras().add(guiaRemisionCompra);
			guiaRemisionCompra.setIdEmpresa(empresa);
			
			Proveedor proveedor = (Proveedor) getHibernateTemplate().get(Proveedor.class,idProveedor);
			proveedor.getCabecerascompras().add(guiaRemisionCompra);
			guiaRemisionCompra.setIdProveedor(proveedor);
			
			guiaRemisionCompra.setNumdoc("");
			guiaRemisionCompra.setNumdocreffactura("");
			guiaRemisionCompra.setFechaemision(new Date());			
			guiaRemisionCompra.setFechaentrega(new Date());			
			guiaRemisionCompra.setFechacontrolinterno(new Date()); //internal control
			
			logger.info("generargetGuiaRemisionCompraIdGeneradoADO B4 to send : guiaRemisionCompra: "+
					guiaRemisionCompra.toString());
			getHibernateTemplate().save(guiaRemisionCompra);
			getHibernateTemplate().initialize(guiaRemisionCompra);
			getHibernateTemplate().initialize(guiaRemisionCompra.getIdEmpresa());
			getHibernateTemplate().initialize(guiaRemisionCompra.getIdProveedor());
			
		}
		catch(DataAccessException dae){	
			logger.info("generargetGuiaRemisionCompraIdGeneradoADO DataAccessException: "+dae.getMessage());
			dae.printStackTrace();
			throw new MyGlobalException();
		}
		return guiaRemisionCompra;
	}

thanks so much for advanced

**karldmoore** · Apr 5th, 2007, 06:33 AM

If nulls are a valid value, have you checked the actual DDL for the table to ensure that nulls are ok? Maybe the different OS's don't check this in the same way? You are also setting not-null="true" in the HBM file.

**dr_pompeii** · Apr 5th, 2007, 07:40 AM

hi karl

thanks for the reply

If nulls are a valid value, have you checked the actual DDL for the table to ensure that nulls are ok?

well, how can i do this?

Code:

Maybe the different OS's don't check this in the same way?

would be, but is it a problem of the DB provider or OS?
dont take how offense.

You are also setting not-null="true" in the HBM file.

yes you right
of course 3 classes,
one father/superclass 2 subclasses
(but they represent one row in the db right?, so here enter the work of the discriminator)

so when i create the object subclass typeA it must has how null the variables that only belong to the subclass TypeB in this case fechavencimiento, and this doesnt happens, instead we see (err)

now by the other hand when i create a Object subclass of typeB the value that belongs only to the TypeA in this case fechaentrega show the value of null, and that's right

i cant explain this weird case, by logic this error not must happen

ideas are welcome friend, maybe the dll can show some detail

regards

**dr_pompeii** · Apr 5th, 2007, 08:16 AM

hi karl

fixed, but i have a huge doubt about this behaviour, i need really a explanation

Code:

 idCabeceraCompra     tipo         numdoc        fechaemision     fechacontrolinterno     idEmpresa     idProveedor     fechavencimiento     valorventa     igv     totalfactura     numdocrefguiaremision     numdocreffactura     fechaentrega 
 -------------------  -----------  ------------  ---------------  ----------------------  ------------  --------------  -------------------  -------------  ------  ---------------  ------------------------  -------------------  --------------- 
 1000041              CABCOMGUIA   56456456      5/04/2007        5/04/2007               00200001      100004          (null)               0              0       0                                          456456546546         5/04/2007       
 100004456456546546   CABCOMFACTU  456456546546  5/04/2007        5/04/2007               00200001      100004          5/04/2007            45             0,19    53,55            56456456                                       (null)

now both types of dates are null,
the trick was work with not-false="false" for each variable that belong to each subclass

the same case for the dates that belongs to each subclasses, is the same for these variables numdocrefguiaremision and numdocreffactura and they has not-null="true"

and instead in the report i can see , well, nothing, and not a (error), how i would expect

Code:

numdocrefguiaremision     numdocreffactura
------------------------  -------------------
                          456456546546 
56456456

why?, it seems that the type of variable is important

see these variables too "valorventa igv totalfactura"
that has values and only belongs to the typeB or CABCOMFACTU (discriminator)
and instead to see null or empty in the first row TypeA that has no the 3 variables i see, the values of 0

is normal this behaviour?

maybe you can clear my doubts

regards

**karldmoore** · Apr 5th, 2007, 12:21 PM

I'm not a MySQL expert, so I'd just have a read of the reference manual to see if there is anything in there.

If no DEFAULT value is specified for a column, MySQL automatically assigns one, as follows. If the column may take NULL as a value, the default value is NULL. If the column is declared as NOT NULL, the default value depends on the column type

http://sql-info.de/en/mysql/gotchas.html#1_1
http://www.databasejournal.com/featu...le.php/3519116

**dr_pompeii** · Apr 5th, 2007, 12:56 PM

thanks for the reply

i thought after i fixed the (err) problem, in mysql in windows it would work normal
but not

, grrrr

now i recieve these errors

excepción
org.springframework.web.util.NestedServletExceptio n: Request processing failed; nested exception is org.springframework.webflow.engine.ActionExecution Exception: Exception thrown executing [AnnotatedAction@b81eaa targetAction = com.lagranjita.swf.actions.TransaccionCompletaGuia RemisionContadoAction@1e565bd, attributes = map['method' -> 'setupForm']] in state 'transaccioncompletacomprafactura-uno' of flow 'transaccioncompletacomprafacturapagocontado-flow' -- action execution attributes were 'map['method' -> 'setupForm']'; nested exception is org.springframework.orm.hibernate3.HibernateJdbcEx ception: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:408)
org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:350)
javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)

causa raíz
org.springframework.webflow.engine.ActionExecution Exception: Exception thrown executing [AnnotatedAction@b81eaa targetAction = com.lagranjita.swf.actions.TransaccionCompletaGuia RemisionContadoAction@1e565bd, attributes = map['method' -> 'setupForm']] in state 'transaccioncompletacomprafactura-uno' of flow 'transaccioncompletacomprafacturapagocontado-flow' -- action execution attributes were 'map['method' -> 'setupForm']'; nested exception is org.springframework.orm.hibernate3.HibernateJdbcEx ception: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
org.springframework.webflow.engine.ActionExecutor. execute(ActionExecutor.java:68)
org.springframework.webflow.engine.ActionList.exec ute(ActionList.java:160)
org.springframework.webflow.engine.ViewState.refre sh(ViewState.java:114)
org.springframework.webflow.engine.impl.FlowExecut ionImpl.refresh(FlowExecutionImpl.java:238)
org.springframework.webflow.executor.FlowExecutorI mpl.refresh(FlowExecutorImpl.java:259)
org.springframework.webflow.executor.support.FlowR equestHandler.handleFlowRequest(FlowRequestHandler .java:122)
org.springframework.webflow.executor.mvc.FlowContr oller.handleRequestInternal(FlowController.java:17 0)
org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(AbstractController.java:153)
org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java:45)
org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:820)
org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:755)
org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:396)
org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:350)
javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)

org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
org.hibernate.exception.SQLStateConverter.handledN onSpecificException(SQLStateConverter.java:103)
org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:91)
org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
org.hibernate.jdbc.AbstractBatcher.executeBatch(Ab stractBatcher.java:249)
org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:235)
org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:139)
org.hibernate.event.def.AbstractFlushingEventListe ner.performExecutions(AbstractFlushingEventListene r.java:298)
org.hibernate.event.def.DefaultFlushEventListener. onFlush(DefaultFlushEventListener.java:27)
org.hibernate.impl.SessionImpl.flush(SessionImpl.j ava:1000)
org.hibernate.impl.SessionImpl.managedFlush(Sessio nImpl.java:338)
org.hibernate.transaction.JDBCTransaction.commit(J DBCTransaction.java:106)
org.springframework.orm.hibernate3.HibernateTransa ctionManager.doCommit(HibernateTransactionManager. java:562)
org.springframework.transaction.support.AbstractPl atformTransactionManager.processCommit(AbstractPla tformTransactionManager.java:654)
org.springframework.transaction.support.AbstractPl atformTransactionManager.commit(AbstractPlatformTr ansactionManager.java:624)
org.springframework.transaction.interceptor.Transa ctionAspectSupport.commitTransactionAfterReturning (TransactionAspectSupport.java:307)
org.springframework.transaction.interceptor.Transa ctionInterceptor.invoke(TransactionInterceptor.jav a:117)
org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :176)
org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterceptor.intercept(Cglib2AopProxy. java:616)
com.lagranjita.modelo.bo.implementaciones.concreto s.ConcreteGuiaRemisionCompraImpl$$EnhancerByCGLIB$ $b526407.generargetGuiaRemisionCompraIdGeneradoBO( <generated>)
com.lagranjita.swf.actions.TransaccionCompletaGuia RemisionContadoAction.createFormObject(Unknown Source)
org.springframework.webflow.action.FormAction.init FormObject(FormAction.java:688)
org.springframework.webflow.action.FormAction.getF ormObject(FormAction.java:827)
org.springframework.webflow.action.FormAction.setu pForm(FormAction.java:532)
sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.webflow.util.DispatchMethodInv oker.invoke(DispatchMethodInvoker.java:105)
org.springframework.webflow.action.MultiAction.doE xecute(MultiAction.java:136)
org.springframework.webflow.action.AbstractAction. execute(AbstractAction.java:203)
org.springframework.webflow.engine.AnnotatedAction .execute(AnnotatedAction.java:142)
org.springframework.webflow.engine.ActionExecutor. execute(ActionExecutor.java:61)
org.springframework.webflow.engine.ActionList.exec ute(ActionList.java:160)
org.springframework.webflow.engine.ViewState.refre sh(ViewState.java:114)
org.springframework.webflow.engine.impl.FlowExecut ionImpl.refresh(FlowExecutionImpl.java:238)
org.springframework.webflow.executor.FlowExecutorI mpl.refresh(FlowExecutorImpl.java:259)
org.springframework.webflow.executor.support.FlowR equestHandler.handleFlowRequest(FlowRequestHandler .java:122)
org.springframework.webflow.executor.mvc.FlowContr oller.handleRequestInternal(FlowController.java:17 0)
org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(AbstractController.java:153)
org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java:45)
org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:820)
org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:755)
org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:396)
org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:350)
javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)

again, it works fine in linux but in the crap windows no

ideas karl???

thanks for advanced

**karldmoore** · Apr 5th, 2007, 12:58 PM

That stacktrace doesn't really tell you anything at all. Is that the complete stack? Increasing the log level is also a good idea.

**dr_pompeii** · Apr 5th, 2007, 02:13 PM

hi karl

my boss like hell, i hate windows

That stacktrace doesn't really tell you anything at all. Is that the complete stack? Increasing the log level is also a good idea.

yes, all , how i can increase that?

this is part of my log4j

Code:

#Spring Framework
og4j.logger.org.springframework=INFO
#Hibernate Framework
log4j.logger.org.hibernate=INFO
log4j.logger.org.hibernate.tool.hbm2ddl=INFO

what i must change or add?

thanks for advanced karl

Thread: weird behavior Hibernate/Mysql in Linux to Windows

Thread Tools

Display

weird behavior Hibernate/Mysql in Linux to Windows

Posting Permissions