It Works!!! ^_^
Thank you very much José F. Romaniello

On Mar 21, 8:05 am, José F. Romaniello <[email protected]> wrote:
> Generator class should be equals to identity rather than increment.
>
> 2011/3/20, SO King Fai <[email protected]>:
>
>
>
> > I am a very newbie on NH. I am going throw the tutorial "Your first
> > NHibernate based application" and try to modify it to my own code
> > standard.
> > Such as try to connect to MSSQL instead of MSSQL CE,
> > Change Database Entity
> > Change the PK to Auto-Increment
>
> > The result is that I can select record from Database successfully.
> > However, I have got the Following Error when try to commit the new
> > record
> > But if i use Debug mode... I found that the NH already can get the new
> > EnterpriseID of the inserted record to my local object.
>
> > I have tried to Google my problem but seems strongly related result
> > for me.....
>
> > Can anyone point out what is the problem???
> > Thank you very much
>
> > =====The Following is the Detailed Error and Other related
> > Information====
> > NHibernate.Exceptions.GenericADOException was unhandled
> >   Message="could not execute batch command.[SQL: SQL not available]"
> >   Source="NHibernate"
> >   SqlString="SQL not available"
> >   StackTrace:
> >        at
> > NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand
> > ps) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet
> > \SqlClientBatchingBatcher.cs:line 95
> >        at
> > NHibernate.AdoNet.AbstractBatcher.ExecuteBatchWithTiming(IDbCommand
> > ps) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet
> > \AbstractBatcher.cs:line 431
> >        at NHibernate.AdoNet.AbstractBatcher.ExecuteBatch() in d:\CSharp
> > \NH\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:line 416
> >        at NHibernate.Engine.ActionQueue.ExecuteActions(IList list) in
> > d:\CSharp\NH\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:line
> > 129
> >        at NHibernate.Engine.ActionQueue.ExecuteActions() in d:\CSharp
> > \NH\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:line 169
> >        at
> > NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource
> > session) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Event\Default
> > \AbstractFlushingEventListener.cs:line 249
> >        at
> > NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent
> > event) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Event\Default
> > \DefaultFlushEventListener.cs:line 19
> >        at NHibernate.Impl.SessionImpl.Flush() in d:\CSharp\NH\NH
> > \nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 1472
> >        at NHibernate.Transaction.AdoTransaction.Commit() in d:\CSharp
> > \NH\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:line
> > 187
> >        at TryNHibernate.Form1.button1_Click(Object sender, EventArgs
> > e) in C:\Users\Felix\Documents\Visual Studio 2008\Projects
> > \TryNHibernate\TryNHibernate\Form1.cs:line 41
> >        at System.Windows.Forms.Control.OnClick(EventArgs e)
> >        at System.Windows.Forms.Button.OnClick(EventArgs e)
> >        at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
> >        at System.Windows.Forms.Control.WmMouseUp(Message& m,
> > MouseButtons button, Int32 clicks)
> >        at System.Windows.Forms.Control.WndProc(Message& m)
> >        at System.Windows.Forms.ButtonBase.WndProc(Message& m)
> >        at System.Windows.Forms.Button.WndProc(Message& m)
> >        at
> > System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> >        at
> > System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> >        at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr
> > hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
> >        at
> > System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
> >        at
> > System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
> > dwComponentID, Int32 reason, Int32 pvLoopData)
> >        at
> > System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
> > reason, ApplicationContext context)
> >        at
> > System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
> > reason, ApplicationContext context)
> >        at System.Windows.Forms.Application.Run(Form mainForm)
> >        at TryNHibernate.Program.Main() in C:\Users\Felix\Documents
> > \Visual Studio 2008\Projects\TryNHibernate\TryNHibernate
> > \Program.cs:line 18
> >        at System.AppDomain._nExecuteAssembly(Assembly assembly,
> > String[] args)
> >        at System.AppDomain.ExecuteAssembly(String assemblyFile,
> > Evidence assemblySecurity, String[] args)
> >        at
> > Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
> >        at System.Threading.ThreadHelper.ThreadStart_Context(Object
> > state)
> >        at System.Threading.ExecutionContext.Run(ExecutionContext
> > executionContext, ContextCallback callback, Object state)
> >        at System.Threading.ThreadHelper.ThreadStart()
> >   InnerException: System.Data.SqlClient.SqlException
> >        Message="Cannot insert explicit value for identity column in
> > table 'Enterprise' when IDENTITY_INSERT is set to OFF."
> >        Source=".Net SqlClient Data Provider"
> >        ErrorCode=-2146232060
> >        Class=16
> >        LineNumber=1
> >        Number=544
> >        Procedure=""
> >        Server="FELIX-WIN7PC\\SQLEXPRESS"
> >        State=1
> >        StackTrace:
> >             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
> > System.Data.SqlClient.SqlCommand.ExecuteBatchRPCCommand()
> >             at System.Data.SqlClient.SqlCommandSet.ExecuteNonQuery()
> >             at
> > NHibernate.AdoNet.SqlClientSqlCommandSet.ExecuteNonQuery() in d:\CSharp
> > \NH\NH\nhibernate\src\NHibernate\AdoNet\SqlClientSqlCommandSet.cs:line
> > 117
> >             at
> > NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand
> > ps) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet
> > \SqlClientBatchingBatcher.cs:line 91
> >        InnerException:
>
> > The Following is the Code of the Application around the error:
> >                    Enterprise product = new Enterprise { enterpriseid = 10L,
> > enterprisename = "name", loginname = "user", password = "user" };
> >                    using (ISession session = NHibernateHelper.OpenSession())
> >                    using (ITransaction transaction = 
> > session.BeginTransaction())
> >                    {
> >                            session.Save(product);
> >                            transaction.Commit();
> >                    }
>
> >                    using (ISession session = _sessionFactory.OpenSession())
> >                    {
> >                            Enterprise fromDb = session.Get<Enterprise>(0L);
> >                            // Test that the product was successfully 
> > inserted
> >                            Assert.IsNotNull(fromDb);
> >                            MessageBox.Show(fromDb.enterprisename);
> >                    }
>
> > It is the Mapping XML
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
> >                    assembly="TryNHibernate"
> >                    namespace="TryNHibernate.Domain">
>
> >   <class name="Enterprise">
> >     <id name="enterpriseid">
> >       <generator class="increment" />
> >     </id>
> >     <property name="enterprisename" />
> >     <property name="loginname" />
> >     <property name="password" />
> >   </class>
>
> >   <!-- more mapping info here -->
>
> > </hibernate-mapping>
>
> > Database Definition:
> > Table Enterprise
> > Numeric(10, 0) EnterpriseID Identity (0,1) PK
> > nvarchar(MAX) EnterpriseName
> > nvarchar(MAX) LoginName
> > nvarchar(MAX) password
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "nhusers" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > For more options, visit this group at
> >http://groups.google.com/group/nhusers?hl=en.
>
> --
> Enviado desde mi dispositivo móvil

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to