The sql query is inserting null in field "csoc_codigolinea", which is a required field.

I have completely populated the object I want to save!.


Hibernate version:
Hibernate 2.1.8

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1

http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->

<class
name="co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCredito"
table="solicitudcredito_soc"
>
<meta attribute="implements" inherit="false">net.sf.hibernate.Lifecycle</meta>
<meta attribute="implements" inherit="false">net.sf.hibernate.Validatable</meta>
<meta attribute="implement-equals" inherit="false">true</meta>

<composite-id name="comp_id" class="co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCreditoPK">
<key-property
name="codigoEmpresa"
column="nsoc_codigoempresa"
type="java.lang.Integer"
length="2"
/>
<key-property
name="codigoOficina"
column="nsoc_codigooficina"
type="java.lang.Integer"
length="2"
/>
<key-property
name="numeroSolicitud"
column="nsoc_numerosolicitud"
type="java.lang.Integer"
length="9"
/>
</composite-id>

<property
name="fechaSolicitud"
type="java.sql.Timestamp"
column="dsoc_fechasolicitud"
not-null="true"
length="23"
/>
<property
name="fechaRadicacion"
type="java.sql.Timestamp"
column="dsoc_fecharadicacion"
not-null="true"
length="23"
/>
<property
name="valor"
type="java.math.BigDecimal"
column="msoc_valor"
not-null="true"
length="19"
/>
<property
name="numeroPlazo"
type="int"
column="nsoc_numeroplazo"
not-null="true"
length="3"
/>
<property
name="tipoGarantia"
type="java.lang.String"
column="csoc_tipogarantia"
not-null="true"
length="1"
/>
<property
name="observacion"
type="java.lang.String"
column="csoc_observacion"
length="2147483647"
/>
<property
name="estado"
type="java.lang.String"
column="csoc_estado"
not-null="true"
length="1"
/>

<!-- Associations -->
<!-- derived association(s) for compound key -->
<!-- bi-directional many-to-one association to Oficina -->
<many-to-one
name="oficina"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Oficina"
update="false"
insert="false"
>
<column name="nsoc_codigoempresa" />
<column name="nsoc_codigooficina" />
</many-to-one>

<!-- bi-directional many-to-one association to Empresa -->
<many-to-one
name="empresa"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Empresa"
update="false"
insert="false"
>
<column name="nsoc_codigoempresa" />
</many-to-one>

<!-- end of derived association(s) -->

<!-- bi-directional many-to-one association to Moneda -->
<many-to-one
name="moneda"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Moneda"
not-null="true"
>
<column name="csoc_codigomoneda" />
</many-to-one>
<property
name="codigoPrograma"
column="csoc_codigoprograma"
type="java.lang.String"
length="5"
not-null="true"
/>
<!-- bi-directional many-to-one association to Convenio -->
<many-to-one
name="convenio"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Convenio"
not-null="true"
insert="false"
update="false"
>
<column name="nsoc_codigoempresa" />
<column name="csoc_codigoconvenio" />
</many-to-one>
<!-- bi-directional many-to-one association to LineaCredito -->
<many-to-one
name="lineaCredito"
class="co.com.unionsoluciones.sofia.cartera.model.bo.LineaCredito"
not-null="true"
insert="false"
update="false"
>
<column name="nsoc_codigoempresa" />
<column name="csoc_codigolinea" />
</many-to-one>
<!-- bi-directional many-to-one association to DestinoCredito -->
<many-to-one
name="destinoCredito"
class="co.com.unionsoluciones.sofia.cartera.model.bo.DestinoCredito"
not-null="true"
>
<column name="csoc_codigodestino" />
</many-to-one>
<!-- bi-directional many-to-one association to SectorEmpresa -->
<many-to-one
name="sectorEmpresa"
class="co.com.unionsoluciones.sofia.cartera.model.bo.SectorEmpresa"
not-null="true"
>
<column name="csoc_codigosector" />
</many-to-one>
<!-- bi-directional many-to-one association to AsesorCredito -->
<many-to-one
name="asesorCredito"
class="co.com.unionsoluciones.sofia.cartera.model.bo.AsesorCredito"
not-null="true"
insert="false"
update="false"
>
<column name="nsoc_codigoempresa" />
<column name="csoc_tipodocumentoasesor" />
<column name="msoc_identificacionasesor" />
</many-to-one>
<!-- bi-directional many-to-one association to PlazoSolicitud -->
<many-to-one
name="plazoSolicitud"
class="co.com.unionsoluciones.sofia.cartera.model.bo.PlazoSolicitud"
not-null="true"
>
<column name="csoc_codigoplazo" />
</many-to-one>
<!-- bi-directional one-to-many association to PersonaSolicitud -->
<set
name="personaSolicituds"
lazy="true"
inverse="true"
cascade="save-update"

>
<key>
<column name="npes_codigoempresa" />
<column name="npes_codigooficina" />
<column name="npes_numerosolicitud" />
</key>
<one-to-many
class="co.com.unionsoluciones.sofia.cartera.model.bo.PersonaSolicitud"
/>
</set>
<!-- bi-directional one-to-many association to GarantiaSolicitud -->
<set
name="garantiaSolicituds"
lazy="true"
inverse="true"
cascade="save-update"
>
<key>
<column name="ngas_codigoempresa" />
<column name="ngas_codigooficina" />
<column name="ngas_numerosolicitud" />
</key>
<one-to-many
class="co.com.unionsoluciones.sofia.cartera.model.bo.GarantiaSolicitud"
/>
</set>
<!-- bi-directional one-to-many association to DocumentoAnexo -->
<set
name="documentoAnexos"
lazy="true"
inverse="true"
cascade="save-update"
>
<key>
<column name="ndoa_codigoempresa" />
<column name="ndoa_codigooficina" />
<column name="ndoa_numerosolicitud" />
</key>
<one-to-many
class="co.com.unionsoluciones.sofia.cartera.model.bo.DocumentoAnexo"
/>
</set>

</class>
</hibernate-mapping>



Code between sessionFactory.openSession() and session.close():

this.getHibernateTemplate().save(objeto);

[Using HibernateDaoSupport from Spring]

Full stack trace of any exception that occurs:

INFO: Entrando a registrar solicitud
Hibernate: insert into solicitudcredito_soc (dsoc_fechasolicitud, dsoc_fecharadicacion, msoc_valor, nsoc_numeroplazo, csoc_tipogarantia, csoc_observacion, csoc_estado, csoc_codigomoneda, csoc_codigoprograma, csoc_codigodestino, csoc_codigosector, csoc_codigoplazo, nsoc_codigoempresa, nsoc_codigooficina, nsoc_numerosolicitud) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
30-Aug-2005 20:07:51 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 515, SQLState: HY000
30-Aug-2005 20:07:51 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls. INSERT fails.
30-Aug-2005 20:07:51 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 3621, SQLState: HY000
30-Aug-2005 20:07:51 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The statement has been terminated.
30-Aug-2005 20:07:51 net.sf.hibernate.impl.SessionImpl execute
SEVERE: Could not synchronize database state with session
org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls. INSERT fails.]; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls. INSERT fails.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls. INSERT fails.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
at org.springframework.orm.hibernate.HibernateTemplate$22.doInHibernate(HibernateTemplate.java:595)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
at org.springframework.orm.hibernate.HibernateTemplate.flush(HibernateTemplate.java:593)
at co.com.unionsoluciones.sofia.cartera.model.dao.hibernate.SolicitudCreditoDaoHibernateImpl.guardarSolicitudCredito(SolicitudCreditoDaoHibernateImpl.java:37)
at co.com.unionsoluciones.sofia.cartera.model.service.impl.ServicioCreditoImpl.registrarSolicitud(ServicioCreditoImpl.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:163)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy1.registrarSolicitud(Unknown Source)
at co.com.unionsoluciones.sofia.cartera.model.TestServicioCredito.testRegistrarSolicitud(TestServicioCredito.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
30-Aug-2005 20:07:51 co.com.unionsoluciones.sofia.cartera.model.service.impl.ServicioCreditoImpl registrarSolicitud
SEVERE: SolicitudCredito co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCredito@6c08b2[comp_id=co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCreditoPK@c74fe[codigoEmpresa=1,codigoOficina=1,numeroSolicitud=1]] ya existe
org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls. INSERT fails.]; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls. INSERT fails.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls. INSERT fails.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
at org.springframework.orm.hibernate.HibernateTemplate$22.doInHibernate(HibernateTemplate.java:595)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
at org.springframework.orm.hibernate.HibernateTemplate.flush(HibernateTemplate.java:593)
at co.com.unionsoluciones.sofia.cartera.model.dao.hibernate.SolicitudCreditoDaoHibernateImpl.guardarSolicitudCredito(SolicitudCreditoDaoHibernateImpl.java:37)
at co.com.unionsoluciones.sofia.cartera.model.service.impl.ServicioCreditoImpl.registrarSolicitud(ServicioCreditoImpl.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:163)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy1.registrarSolicitud(Unknown Source)
at co.com.unionsoluciones.sofia.cartera.model.TestServicioCredito.testRegistrarSolicitud(TestServicioCredito.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

Name and version of the database you are using:
MS SQL SERVER 2000

The generated SQL (show_sql=true):
Hibernate: insert into solicitudcredito_soc (dsoc_fechasolicitud, dsoc_fecharadicacion, msoc_valor, nsoc_numeroplazo, csoc_tipogarantia, csoc_observacion, csoc_estado, csoc_codigomoneda, csoc_codigoprograma, csoc_codigodestino, csoc_codigosector, csoc_codigoplazo, nsoc_codigoempresa, nsoc_codigooficina, nsoc_numerosolicitud) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)


======================================

Please Help! I'm in a hurry.......

I have temporally set a default value for field "csoc_codigolinea", and now the field "msoc_identificacionasesor" is causing the same problem.



It seems to be a problem with the "many-to-one" associations that reference a composite PK.

Is there anything special I have to do in order to map many-to-one relationships with composite PK's?

Probably I'm missing something very obvious here, please help!.

The reported null values are the ones defined by tags of type "column" inside my "many-to-one" associations, for instance.... csoc_codigoconvenio is reported null..... see mapping below

I'm still struggling with this, I think it might be an error in the mapping file (which was generated with middlegen).

Any Ideas?

My insert wasn't including the required fields due to these lines in my mapping file:

now, inside my many-to-one I have set



this will allow the insert statement to include the fields that were being reported null.

Now, I am getting this exception:

net.sf.hibernate.MappingException: Repeated column in mapping for class co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCredito should be mapped with insert="false" update="false".

The problem might be that as you can see on the full mapping, the field "nsoc_codigoempresa" is part of almost all my PK's.....


Is there any way to get rid of this error?

How can I fix my mapping in order to deal with this legacy database, plagued with composite ID's. Unfortunately almost all my tables are related to empresa!

Please help.!

- you have to use <key-many-to-one> in composite key for complex schema

- don't use update=false or insert=false and you haven't to any column in mapping twice

- you have composite id class and key property for any class (SolicitudCredito)

etc ...

move to hibernate 3 - it is much better

regards

Thanks a lot snpesnpe, I really appreciate your help.


I will try this and see if the prolem is fixed.



the problem is that when I use update/insert=true, I get a BadMappingException telling me that there's a repeated column and I should use insert/update=false. I'm not sure if I am missunderstanding you at this point.....





unfortuntately I'm working with a legacy DB, which impose a composite PK for almost all my entities....





I'd really like to try to move to Hibernate 3, but unfortunately as far as I understand middlegen doesn't generate mappings for version 3. We would like to generate the mapping from the legacy database...do you know anyway to try and move my middlegen-generated v2 mappings to v3?


Thannks......

update/insert=false tell hibernate that don't update/insert this column - do you want this ?

if you have composite class SolicitudCreditoPK then you haven't to have properties in composite key mapping (properties are in SolicitudCreditoPK)

new middlegen (CVS) work with hibernate3, but it isn't important - you need change DOCTYPE
in mapping file to hibernate3 dtd, only - see example in documentation - it is compatible with hibernate3

Snpesnpe thanks for your kind help.



No, I dont want this, and in fact this was causing the problem, so I changed my mapping not using insert/update=false. That way, I got rid of this error:

Cannot insert the value NULL into column 'csoc_codigolinea', table 'cartera.dbo.solicitudcredito_soc'; column does not allow nulls.

Then, not using insert/update=false, I get this error

Repeated column in mapping for class co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCredito should be mapped with insert="false" update="false": nsoc_codigoempresa

Although Im using a class for my composite PK, not having the properties in composite key mapping causes an Invalid Mapping Exception.


On the other hand, considering migration to Hibernate 3, I think it will not help unless I change my mapping. Am I wrong with this?


Thnaks....

Julian,
You have map same column/columns twice (I think one in key and second in PK class)
don't map column twice and remove insert/update=false

Thanks....
I dont have a mapping hbm file for the composite key class SolicitudPK. I guess the prolem is that one of the fields of the primary key, is also referenced later in the mapping file, since it also belongs to another entity to which Solicitud is associated.

This is the original mapping:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1

http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->

<class
name="co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCredito"
table="solicitudcredito_soc"
>
<meta attribute="implements" inherit="false">net.sf.hibernate.Lifecycle</meta>
<meta attribute="implements" inherit="false">net.sf.hibernate.Validatable</meta>
<meta attribute="implement-equals" inherit="false">true</meta>

<composite-id name="comp_id" class="co.com.unionsoluciones.sofia.cartera.model.bo.SolicitudCreditoPK">
<key-property
name="codigoEmpresa"
column="nsoc_codigoempresa"
type="java.lang.Integer"
length="2"
/>
<key-property
name="codigoOficina"
column="nsoc_codigooficina"
type="java.lang.Integer"
length="2"
/>
<key-property
name="numeroSolicitud"
column="nsoc_numerosolicitud"
type="java.lang.Integer"
length="9"
/>
</composite-id>

<property
name="fechaSolicitud"
type="java.sql.Timestamp"
column="dsoc_fechasolicitud"
not-null="true"
length="23"
/>
<property
name="fechaRadicacion"
type="java.sql.Timestamp"
column="dsoc_fecharadicacion"
not-null="true"
length="23"
/>
<property
name="valor"
type="java.math.BigDecimal"
column="msoc_valor"
not-null="true"
length="19"
/>
<property
name="numeroPlazo"
type="int"
column="nsoc_numeroplazo"
not-null="true"
length="3"
/>
<property
name="tipoGarantia"
type="java.lang.String"
column="csoc_tipogarantia"
not-null="true"
length="1"
/>
<property
name="observacion"
type="java.lang.String"
column="csoc_observacion"
length="2147483647"
/>
<property
name="estado"
type="java.lang.String"
column="csoc_estado"
not-null="true"
length="1"
/>

<!-- Associations -->
<!-- derived association(s) for compound key -->
<!-- bi-directional many-to-one association to Oficina -->
<many-to-one
name="oficina"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Oficina"
update="false"
insert="false"
>
<column name="nsoc_codigoempresa" />
<column name="nsoc_codigooficina" />
</many-to-one>

<!-- bi-directional many-to-one association to Empresa -->
<many-to-one
name="empresa"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Empresa"
update="false"
insert="false"
>
<column name="nsoc_codigoempresa" />
</many-to-one>

<!-- end of derived association(s) -->

<!-- bi-directional many-to-one association to Moneda -->
<many-to-one
name="moneda"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Moneda"
not-null="true"
>
<column name="csoc_codigomoneda" />
</many-to-one>
<property
name="codigoPrograma"
column="csoc_codigoprograma"
type="java.lang.String"
length="5"
not-null="true"
/>
<!-- bi-directional many-to-one association to Convenio -->
<many-to-one
name="convenio"
class="co.com.unionsoluciones.sofia.cartera.model.bo.Convenio"
not-null="true"
insert="false"
update="false"
>
<column name="nsoc_codigoempresa" />
<column name="csoc_codigoconvenio" />
</many-to-one>
<!-- bi-directional many-to-one association to LineaCredito -->
<many-to-one
name="lineaCredito"
class="co.com.unionsoluciones.sofia.cartera.model.bo.LineaCredito"
not-null="true"
insert="false"
update="false"
>
<column name="nsoc_codigoempresa" />
<column name="csoc_codigolinea" />
</many-to-one>
<!-- bi-directional many-to-one association to DestinoCredito -->
<many-to-one
name="destinoCredito"
class="co.com.unionsoluciones.sofia.cartera.model.bo.DestinoCredito"
not-null="true"
>
<column name="csoc_codigodestino" />
</many-to-one>
<!-- bi-directional many-to-one association to SectorEmpresa -->
<many-to-one
name="sectorEmpresa"
class="co.com.unionsoluciones.sofia.cartera.model.bo.SectorEmpresa"
not-null="true"
>
<column name="csoc_codigosector" />
</many-to-one>
<!-- bi-directional many-to-one association to AsesorCredito -->
<many-to-one
name="asesorCredito"
class="co.com.unionsoluciones.sofia.cartera.model.bo.AsesorCredito"
not-null="true"
insert="false"
update="false"
>
<column name="nsoc_codigoempresa" />
<column name="csoc_tipodocumentoasesor" />
<column name="msoc_identificacionasesor" />
</many-to-one>
<!-- bi-directional many-to-one association to PlazoSolicitud -->
<many-to-one
name="plazoSolicitud"
class="co.com.unionsoluciones.sofia.cartera.model.bo.PlazoSolicitud"
not-null="true"
>
<column name="csoc_codigoplazo" />
</many-to-one>
<!-- bi-directional one-to-many association to PersonaSolicitud -->
<set
name="personaSolicituds"
lazy="true"
inverse="true"
cascade="none"

>
<key>
<column name="npes_codigoempresa" />
<column name="npes_codigooficina" />
<column name="npes_numerosolicitud" />
</key>
<one-to-many
class="co.com.unionsoluciones.sofia.cartera.model.bo.PersonaSolicitud"
/>
</set>
<!-- bi-directional one-to-many association to GarantiaSolicitud -->
<set
name="garantiaSolicituds"
lazy="true"
inverse="true"
cascade="none"
>
<key>
<column name="ngas_codigoempresa" />
<column name="ngas_codigooficina" />
<column name="ngas_numerosolicitud" />
</key>
<one-to-many
class="co.com.unionsoluciones.sofia.cartera.model.bo.GarantiaSolicitud"
/>
</set>
<!-- bi-directional one-to-many association to DocumentoAnexo -->
<set
name="documentoAnexos"
lazy="true"
inverse="true"
cascade="none"
>
<key>
<column name="ndoa_codigoempresa" />
<column name="ndoa_codigooficina" />
<column name="ndoa_numerosolicitud" />
</key>
<one-to-many
class="co.com.unionsoluciones.sofia.cartera.model.bo.DocumentoAnexo"
/>
</set>

</class>
</hibernate-mapping>


I will appreciate any help.....

The mapping above includes the insert/update=false, just as generated by Middlegen. I already changed them to insert/update=false, but then I get the invalid mapping exception.

I can't check all your classes, but this is example mapping with more composite ids and collections
It work fine with hibernate 3 (it was fine with hibernate 2 before - i change doctype declaration only)

see speacially rob_dokrso

rob_dokr


rob_dokrs



rob_dokrso

This is very helpful, I'll take a look and see if it works.....
Thanks