Hibernate version: 1.0.2.0
Mapping documents:
Code:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" assembly="INARI-Metier" namespace="Cnr.Inari.Metier.Entities" >
<class name="ValeurMesure" table="VALEUR_MESURE">
<id name="IdMesure" column="MES_ID" type="Int32">
<generator class="assigned"/>
</id>
<property column="VALEUR" type="Double" name="Valeur" not-null="true" />
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():Code:
Dim myValeurMesure As New ValeurMesure(500, 600.5)
BeginTransaction
myValeurMesure.Save
CommitTransaction
Full stack trace of any exception that occurs: Code:
NHibernat.ADOException
could not insert: [Cnr.Inari.Metier.Entities.ValeurMesure#500]
à NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, SqlString sql, Object obj, ISessionImplementor session)
à NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)
à NHibernate.Impl.ScheduledInsertion.Execute()
à NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
à NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
à NHibernate.Impl.SessionImpl.Execute()
à NHibernate.Impl.SessionImpl.Flush()
à Cnr.Inari.Metier.Factories.SessionHelper.CommitTransaction() dans C:\Devl\INARI\Source\INARI-Metier\Factories\SessionHelper.vb:ligne 234
à Cnr.Inari.Metier.Factories.Factory`1.Commit(Boolean pForce) dans C:\Devl\INARI\Source\INARI-Metier\Factories\Factory.vb:ligne 96
à Cnr.Inari.Metier.Factories.Factory`1.Save(Int32 retryCount) dans C:\Devl\INARI\Source\INARI-Metier\Factories\Factory.vb:ligne 150
Inner Exception :
Code:
System.Data.OracleClient.OracleException
ORA-00942: table or view does not exist
à System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
à System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
à System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
à System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
à NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd)
à NHibernate.Impl.NonBatchingBatcher.AddToBatch(Int32 expectedRowCount)
à NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, SqlString sql, Object obj, ISessionImplementor session)
Name and version of the database you are using:The generated SQL (show_sql=true):With SQLMonitor :
Code:
Timestamp: 14:57:23.786
INSERT INTO gen$inari.VALEUR_MESURE (VALEUR, MES_ID) VALUES (:p0, :p1)
:p0 = 600.5
:p1 = 500
Runtime error occurred: 942 (ORA-00942: table or view does not exist)
My table :
Code:
/*==============================================================*/
/* Table : VALEUR_MESURE */
/*==============================================================*/
create table VALEUR_MESURE (
MES_ID NUMBER(10) not null,
VALEUR NUMBER(9,3) not null,
constraint PK_VALEUR_MESURE primary key (MES_ID)
);
Hi
I'm a french NHibernate user
I'm facing this problem : I've created an object "ValeurMesure" as seen before. When i'm trying to insert it into my database, i got the error before, in spite of the fact that my table really exist...
If i copy past the commant shown un SQLmonitor in TOAD, it works !
Any idea about this ? Why NHibernat doesn't found my table ?
Thanks un advance
Yoan