I am attempting to run the Quick Start sample and I am attempting to create a user in the database. When I commit the transaction I get the following error.

Unhandled Exception: NHibernate.ADOException: could not synchronize database state with session ---> FirebirdSql.Data.Fi
rebird.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 40
Password

at FirebirdSql.Data.Firebird.FbCommand.Prepare()
at NHibernate.Impl.BatcherImpl.Prepare(IDbCommand command)
at NHibernate.Impl.NonBatchingBatcher.AddToBatch(Int32 expectedRowCount)
at NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, SqlString sql, Object o
bj, ISessionImplementor session)
at NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)
at NHibernate.Impl.ScheduledInsertion.Execute()
at NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
at NHibernate.Impl.SessionImpl.Execute()
--- End of inner exception stack trace ---
at NHibernate.Impl.SessionImpl.Execute()
at NHibernate.Impl.SessionImpl.Flush()
at NHibernate.Transaction.AdoTransaction.Commit()
at Chap08_ORApplication.Program.SampleDB() in c:\cygwin\home\cgross\desktop\projects\oop-using-net-patterns\src\Chap0
8.ORApplication\Program.cs:line 35
at Chap08_ORApplication.Program.Main(String[] args) in c:\cygwin\home\cgross\desktop\projects\oop-using-net-patterns\
src\Chap08.ORApplication\Program.cs:line 39

I have tried to figure this error out and I am stuck. Could somebody please help me? Thanks

Christian Gross

I figured out the error. It seems in Firebird when you use a keyword in a SQL command then you will get a similar error. The problem is the field PASSWORD, which is reserved. There is a knowledge base article http://www.ibphoenix.com/main.nfs?a=ibp ... E;ID='283'

Christian