I had a quite old Castle dll files in my project and decided to
upgrade them to the newest version.
ActiveRecord and NHibernate were among them. When I launched the
project some HQL queries
run fine but some of them stopped working and threw exception. All
exceptions have the same reason. I run the generated SQL query in a
MySql client app and it brought up the same error (Unknown column
xxxxx in 'on clause'). It's strange because before upgrading the dll
files everything worked fine. It seems that nhibernate has changed the
way it generates SQL statements from HQL
Has anyone come across above issue and knows a workaround?
ActiveRecordException
Message:
Could not perform ExecuteQuery for PMiejsce
StackTrace:
.
.
.
.
<b>Inner exception:</b>
ADOException
Message:
could not execute query
.
.
.
.
<b>Inner exception:</b>
MySqlException
Message:
Unknown column 'pparking0_.AddressId' in 'on clause'
StackTrace:
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32&
affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId,
Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
behavior)
at
MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean
autoDiscoverTypes, Boolean callable, RowSelection selection,
ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session,
QueryParameters queryParameters, Boolean returnProxies)
at
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor
session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
QueryParameters queryParameters)
--
You received this message because you are subscribed to the Google Groups
"Castle Project Users" 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/castle-project-users?hl=en.
