These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 
  Previous topic | Next topic 
Author Message
Jensegutt
 Post subject: Column appears more than once in the result column list
PostPosted: Tue Jan 02, 2007 8:34 am 
Newbie

Joined: Tue Jan 17, 2006 5:00 am
Posts: 16
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:NHibernate1.2.0Beta 2

Mapping documents:

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

Full stack trace of any exception that occurs:

Name and version of the database you are using: SQL Server 2005

The generated SQL (show_sql=true):

I get this error when generating inserts for this mapping file on the "Kundenr" column, but selects works allright and only has the "Kundenr" field once.

Any idea what the problem might be?

Code:
<?xml version="1.0" encoding="utf-8" ?>

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"   namespace="Blomqvist"   assembly ="Blomqvist" >
   <class
    name = "Nett_User"   
    proxy= "Nett_User"   
    dynamic-update="true"
    dynamic-insert="true"
    table= "[dbo].[Nett_User]"  >
   
      <id name="Nettuserid" 
      column="Nettuserid" 
      type="System.Int32"     >
      <generator class="Blomqvist.HibernateGenerator, Blomqvist" />
    </id>

    <version
      name="Hbversion"                               
      column="Hbversion"                           
      type="System.Int32"                                 
      unsaved-value="null"   
    />

    <property name="Kundenr"  ></property>
    <property name="Password" column="Password" type="System.String" length="50"   access="field.camelcase-underscore" ></property>
    <property name="Username" column="Username" type="System.String" length="100"  access="field.camelcase-underscore" ></property>
    <property name="CreationDate" ></property>
    <property name="SecurityQuestion" ></property>
    <property name="SecurityAnswer" ></property>
    <property name="IsApproved" access="field.camelcase-underscore"></property>
    <property name="IsOnline" access="field.camelcase-underscore" ></property>
    <property name="IsLockedOut" access="field.camelcase-underscore" ></property>
    <property name="IsSubscriber" access="field.camelcase-underscore" ></property>
    <property name="LastActivityDate" ></property>
    <property name="LastLoginDate" ></property>
    <property name="LastPasswordChangedDate" ></property>
    <property name="LastLockedoutDate" ></property>
    <property name="FailedPasswordAttemptCount" ></property>
    <property name="FailedPasswordAttemptWindowStart" ></property>
    <property name="FailedPasswordAnswerAttemptCount" ></property>
    <property name="FailedPasswordAnswerAttemptWindowStart" ></property>
    <property name="Comment" ></property>

    <many-to-one
      name = "Kunde"   
      class = "Kunde"   
      cascade = "save-update"   
      fetch="select"
      update = "true"  >
      <column name="Kundenr" />
    </many-to-one>

    <bag
      name="Nett_UserInRole" 
      cascade="all-delete-orphan" 
      lazy="true"  inverse="true" >
         <key>
            <column name= "Nettuserid" />
         </key>
         <one-to-many class="Nett_UserInRole" />
      </bag>

    <bag
      name="Kreditkort" 
      cascade="all-delete-orphan" 
      lazy="true"  inverse="true"
      generic="true" >
      <key>
        <column name= "Kundenr" />
      </key>
      <one-to-many class="NettKreditkort" />
    </bag>
 
  </class>
</hibernate-mapping>



Debug level Hibernate log excerpt:
Code:
2007-01-02 13:08:08,383 [1] ERROR NHibernate.Util.ADOExceptionReporter [(null)] &lt;(null)&gt; - Column name 'Kundenr' appears more than once in the result column list.
2007-01-02 13:08:08,533 [1] ERROR NHibernate.Impl.SessionImpl [(null)] &lt;(null)&gt; - could not synchronize database state with session
NHibernate.ADOException: could not insert: [Blomqvist.Nett_User#849][SQL: INSERT INTO [dbo].[Nett_User] (Hbversion, Kundenr, Username, CreationDate, IsApproved, IsOnline, IsLockedOut, IsSubscriber, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart, Kundenr, Nettuserid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> System.Data.SqlClient.SqlException: Column name 'Kundenr' appears more than once in the result column list.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\BatcherImpl.cs:line 175
   at NHibernate.Impl.NonBatchingBatcher.AddToBatch(IExpectation expectation) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\NonBatchingBatcher.cs:line 36
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2871
   --- End of inner exception stack trace ---
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2888
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2525
   at NHibernate.Impl.ScheduledInsertion.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\ScheduledInsertion.cs:line 39
   at NHibernate.Impl.SessionImpl.Execute(IExecutable executable) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3299
   at NHibernate.Impl.SessionImpl.ExecuteAll(IList list) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3278
   at NHibernate.Impl.SessionImpl.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3220
2007-01-02 13:08:09,402 [1] ERROR NHibernate.Util.ADOExceptionReporter [(null)] &lt;(null)&gt; - Column name 'Kundenr' appears more than once in the result column list.
2007-01-02 13:08:09,422 [1] ERROR NHibernate.Impl.SessionImpl [(null)] &lt;(null)&gt; - could not synchronize database state with session
NHibernate.ADOException: could not insert: [Blomqvist.Nett_User#849][SQL: INSERT INTO [dbo].[Nett_User] (Hbversion, Kundenr, Username, CreationDate, IsApproved, IsOnline, IsLockedOut, IsSubscriber, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart, Kundenr, Nettuserid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> System.Data.SqlClient.SqlException: Column name 'Kundenr' appears more than once in the result column list.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\BatcherImpl.cs:line 175
   at NHibernate.Impl.NonBatchingBatcher.AddToBatch(IExpectation expectation) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\NonBatchingBatcher.cs:line 36
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2871
   --- End of inner exception stack trace ---
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2888
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2525
   at NHibernate.Impl.ScheduledInsertion.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\ScheduledInsertion.cs:line 39
   at NHibernate.Impl.SessionImpl.Execute(IExecutable executable) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3299
   at NHibernate.Impl.SessionImpl.ExecuteAll(IList list) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3278
   at NHibernate.Impl.SessionImpl.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3220
2007-01-02 13:08:09,601 [1] ERROR NHibernate.Util.ADOExceptionReporter [(null)] &lt;(null)&gt; - Column name 'Kundenr' appears more than once in the result column list.
2007-01-02 13:08:09,611 [1] ERROR NHibernate.Impl.SessionImpl [(null)] &lt;(null)&gt; - could not synchronize database state with session
NHibernate.ADOException: could not insert: [Blomqvist.Nett_User#849][SQL: INSERT INTO [dbo].[Nett_User] (Hbversion, Kundenr, Username, CreationDate, IsApproved, IsOnline, IsLockedOut, IsSubscriber, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart, Kundenr, Nettuserid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> System.Data.SqlClient.SqlException: Column name 'Kundenr' appears more than once in the result column list.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\BatcherImpl.cs:line 175
   at NHibernate.Impl.NonBatchingBatcher.AddToBatch(IExpectation expectation) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\NonBatchingBatcher.cs:line 36
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2871
   --- End of inner exception stack trace ---
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2888
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2525
   at NHibernate.Impl.ScheduledInsertion.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\ScheduledInsertion.cs:line 39
   at NHibernate.Impl.SessionImpl.Execute(IExecutable executable) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3299
   at NHibernate.Impl.SessionImpl.ExecuteAll(IList list) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3278
   at NHibernate.Impl.SessionImpl.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3220
2007-01-02 13:08:09,731 [1] ERROR NHibernate.Util.ADOExceptionReporter [(null)] &lt;(null)&gt; - Column name 'Kundenr' appears more than once in the result column list.
2007-01-02 13:08:09,741 [1] ERROR NHibernate.Impl.SessionImpl [(null)] &lt;(null)&gt; - could not synchronize database state with session
NHibernate.ADOException: could not insert: [Blomqvist.Nett_User#849][SQL: INSERT INTO [dbo].[Nett_User] (Hbversion, Kundenr, Username, CreationDate, IsApproved, IsOnline, IsLockedOut, IsSubscriber, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart, Kundenr, Nettuserid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> System.Data.SqlClient.SqlException: Column name 'Kundenr' appears more than once in the result column list.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\BatcherImpl.cs:line 175
   at NHibernate.Impl.NonBatchingBatcher.AddToBatch(IExpectation expectation) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\NonBatchingBatcher.cs:line 36
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2871
   --- End of inner exception stack trace ---
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2888
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 2525
   at NHibernate.Impl.ScheduledInsertion.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\ScheduledInsertion.cs:line 39
   at NHibernate.Impl.SessionImpl.Execute(IExecutable executable) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3299
   at NHibernate.Impl.SessionImpl.ExecuteAll(IList list) in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3278
   at NHibernate.Impl.SessionImpl.Execute() in C:\Projects\Extern\Blomqvist\Andhoy\NHibernate\1200\src\NHibernate\Impl\SessionImpl.cs:line 3220
2007-01-02 13:17:40,745 [1] INFO  NHibernate.Cfg.Environment [(null)] &lt;(null)&gt; - NHibernate 1.2.0.2002 (1.2.0.2002)
2007-01-02 13:17:40,815 [1] INFO  NHibernate.Cfg.Environment [(null)] &lt;(null)&gt; - nhibernate section not found in application configuration file
2007-01-02 13:17:40,815 [1] INFO  NHibernate.Cfg.Environment [(null)] &lt;(null)&gt; - Bytecode provider name : lcg
2007-01-02 13:17:40,825 [1] INFO  NHibernate.Cfg.Environment [(null)] &lt;(null)&gt; - Using reflection optimizer
2007-01-02 13:17:41,215 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - connection.provider=NHibernate.Connection.DriverConnectionProvider
2007-01-02 13:17:41,215 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - connection.driver_class=NHibernate.Driver.SqlClientDriver
2007-01-02 13:17:41,215 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - connection.connection_string=data source=172.18.0.10; initial catalog=blomqvist; user id=blomqvist; password=blomqvist;Connection Timeout=15;persist security info=True; Application Name=Nettauksjon;
2007-01-02 13:17:41,215 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - connection.isolation=Snapshot
2007-01-02 13:17:41,225 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - dialect=NHibernate.Dialect.MsSql2005Dialect
2007-01-02 13:17:41,225 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - show_sql=true
2007-01-02 13:17:41,225 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - prepare_sql=false
2007-01-02 13:17:41,225 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - hibernate.max_fetch_depth=1
2007-01-02 13:17:41,225 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - isolation=Snapshot
2007-01-02 13:17:41,225 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - query.substitutions=true 1, false 0
2007-01-02 13:17:41,235 [1] DEBUG NHibernate.Cfg.Configuration [(null)] &lt;(null)&gt; - nhibernator<-Blomqvist



Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html
Top
 Profile  
 
xasp
 Post subject:
PostPosted: Tue Jan 02, 2007 10:34 am 
Regular
Regular

Joined: Thu Nov 23, 2006 10:29 am
Posts: 106
Location: Belgium
Hi,

You have a property named Kundenr and your many-to-one defines the same column. I bet this is causing your error.
If you intended to define a one-to-one relationship you should consult chapter 5.1.11 in the NHibernate reference (I can't help you with one-to-one relationships because I never use them myself).

Please rate this post if it helped.
X.
Top
 Profile  
 
Jensegutt
 Post subject:
PostPosted: Tue Jan 02, 2007 11:57 am 
Newbie

Joined: Tue Jan 17, 2006 5:00 am
Posts: 16
I know that that's the "problem" I've tried to remove both and then it the insert worked, but I just got a problem elsewhere.

I also have the same kind of mappings elsewhere in my solution where a mapping like this works OK.
Top
 Profile  
 
xasp
 Post subject:
PostPosted: Tue Jan 02, 2007 12:08 pm 
Regular
Regular

Joined: Thu Nov 23, 2006 10:29 am
Posts: 106
Location: Belgium
Why do you define Kundenr twice ?
You could just leave one (the association), and it would work.

You mention that there's another part in your code where it works. I doubt that. Look closely, there is definitely a difference.

X.
Top
 Profile  
 
vinodhts
 Post subject:
PostPosted: Tue Jan 02, 2007 2:09 pm 
Beginner
Beginner

Joined: Thu Aug 31, 2006 2:31 pm
Posts: 25
Location: USA
Hi ,
You should change the update to be false.
<many-to-one
name = "Kunde"
class = "Kunde"
cascade = "save-update"
fetch="select"
update = "true" >
<column name="Kundenr" />
</many-to-one>

<many-to-one
name = "Kunde"
class = "Kunde"
update="false" insert="false" fetch="select">

and set the cascade operations in the inverse side of relationship..
thanks,
vinod

_________________
I am using a shitty e-mail filtering system that caused a lot of bounces for the admin of this forum. I need to turn on my brain next time and update my e-mail address.

Top
 Profile  
 
Jensegutt
 Post subject:
PostPosted: Wed Jan 03, 2007 8:17 am 
Newbie

Joined: Tue Jan 17, 2006 5:00 am
Posts: 16
Thanks, that solved my problem - even though I don't quite understand why this should be "as designed" ... :-)
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.