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.

Reply via email to