I was trying to select some data from my Pedido class:
ICriteria criteria = NHibernateSessionManager.Instance.GetSession().CreateCriteria(typeof(Pedido));

criteria.Add(Expression.Not(Expression.Eq("CodAp", 0)))
.AddOrder(Order.Asc("CodAp"));

IPedidoDao pedidoDao = (new NHibernateDaoFactory()).GetPedidoDao();
List<Pedido> pedidos = pedidoDao.GetByCriteria(criteria);

and I received this error:

{"could not update: [ADFinance.Faturamento.Pedido#3173]"}
{"ORA-02291: restrição de integridade (ADSYSTEM.FK_PO_PEDIDO_MD_PRODUTO) violada - chave mãe não localizada\n"}

but I'm not trying to update anything...
As you can see in the mapping files I have a many-to-one relationship between Pedido and Produto, but the column in the Pedido class cod_produto can be null. Is that the problem?

Hibernate version: 1.0.2

Mapping documents:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="ADFinance.Faturamento.Pedido, ADFinance" table="T_ADF_PO_Pedido">
<id name="ID" column="cod_po" unsaved-value="0">
<generator class="native">
<param name="sequence">S_T_ADF_PO_Pedido</param>
</generator>
</id>

<property name="StatusFaturamento" column="cod_status_faturamento" />
<property name="TipoPedido" column="cod_tipo_pedido" />
<property name="CodPoOrigem" column="cod_po_origem" />
<property name="CodAp" column="cod_ap" />
<property name="CodCliente" column="cod_cliente" />
<property name="ValorComissao" column="valor_comissao" />
<property name="PorcentagemComissao" column="porcentagem_comissao" />
<property name="CodProduto" column="cod_produto" />
<property name="PeriodoVeiculacao" column="periodo_veiculacao" />

<many-to-one name="Praca" column="cod_praca" class="ADFinance.Comum.Praca, ADFinance" />
<many-to-one name="Meio" column="cod_meio" class="ADFinance.Comum.Meio, ADFinance" />
<many-to-one name="Campanha" column="cod_campanha" class="ADFinance.Comum.Campanha, ADFinance" />
<many-to-one name="Representante" column="cod_representante" class="ADFinance.Comum.Representante, ADFinance" />
<many-to-one name="Veiculo" column="cod_veiculo" class="ADFinance.Comum.Veiculo, ADFinance" />
<!--
<bag name="Itens" lazy="true" table="T_ADF_CP_PO_Item" inverse="false"
access="NHibernate.Generics.GenericAccessor, NHibernate.Generics" >
<key column="cod_po" />
<one-to-many class="ADFinance.Faturamento.ItemPedido, ADFinance" />
</bag>-->
</class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="ADFinance.Comum.Produto, ADFinance" table="T_ADF_MD_PROD">
<id name="ID" column="cod_produto" unsaved-value="0">
<generator class="native">
<param name="sequence">S_T_ADF_MD_PROD</param>
</generator>
</id>

<property name="CodProdutoCliente" column="cod_prod_cliente" />
<property name="NomeProduto" column="nome_produto" />

<many-to-one name="Cliente" class="ADFinance.Comum.Cliente, ADFinance" column="cod_cliente" />
</class>

</hibernate-mapping>

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

Full stack trace of any exception that occurs:

at NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Boolean[] includeProperty, Object oldVersion, Object obj, SqlString sqlUpdateString, ISessionImplementor session)
at NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Object[] oldFields, Object oldVersion, Object obj, ISessionImplementor session)
at NHibernate.Impl.ScheduledUpdate.Execute()
at NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
at NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
at NHibernate.Impl.SessionImpl.Execute()
at NHibernate.Impl.SessionImpl.AutoFlushIfRequired(ISet querySpaces)
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria)
at NHibernate.Impl.CriteriaImpl.List()
at ADFinance.Data.GenericNHibernateDao`2.GetByCriteria(ICriteria criteria) in C:\Documents and Settings\Thiago\Meus documentos\GOLIVE\AD\Financeiro\ADFinance\ADFinance.Data\GenericNHibernateDao.cs:line 68
at FIFAT00101.ComboAps() in c:\Documents and Settings\Thiago\Meus documentos\GOLIVE\AD\Financeiro\ADFinance\Finance\FIFAT00101.aspx.cs:line 105
at FIFAT00101.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\Thiago\Meus documentos\GOLIVE\AD\Financeiro\ADFinance\Finance\FIFAT00101.aspx.cs:line 33
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Name and version of the database you are using: Oracle 8i

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
{"could not update: [ADFinance.Faturamento.Pedido#3173]"}
{"ORA-02291: restrição de integridade (ADSYSTEM.FK_PO_PEDIDO_MD_PRODUTO) violada - chave mãe não localizada\n"}

can anyone help with this??

Whith default Session.FlushMode, NHibernate saves all known changes before executing query - to avoid getting stale data as result.

Now, as the Prudoto is mapped as

<property name="CodProduto" column="cod_produto" />

NHibernate has no hint for executing saves/updates in correct order.

Maybe You should write it as

<many-to-one name="CodProduto" class="ADFinance.Comum.Produto, ADFinance" column="cod_produto"/>

Gert

What about the enum cases? Because I can't map an enum as a many-to-one, I have to map it as a property.

And I haven't made any changes at all, I just binded de results from the getbycriteria method to a gridview.

If it is a enum, you:
a) do not have foreign key in database, so no problems during save.
b) Related database table contains all possible values (Probably including the 0 for unspecified enum value), so again no problems.

But as You map did specify class for produto, I did not think about this possibility.



I ahve no experience with gridview and NHIbernate, but maybe the gridview is creating a new instance of object? (To be shown as empty or new item)

Gertt