Hi,
I recently upgraded to 1.2 of hibernate and now am receiving the following exception. This code was not changed between 1.0 and 1.2 and what's weird is that if you copy-paste the SQL that is output in the exception, the SQL itself is valid and returns a result. So I'm not really sure what the problem is. Any help you can provide is greatly appreciated.
Thanks.
- Chris
Code:
[SqlException (0x80131904): Incorrect syntax near ';'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +177
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +68
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2300
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +294
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1021
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +20
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +107
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +10
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9
NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) +32
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) +182
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +175
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +56
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +30
[ADOException: could not execute query
[ select cmsnewsite0_.item_id as item1_13_, cmsnewsite0_.title as title19_, cmsnewsite0_.subtitle as subtitle19_, cmsnewsite0_.summary as summary19_, cmsnewsite0_1_.content_type as content2_13_, cmsnewsite0_1_.created as created13_, cmsnewsite0_1_.resource as resource13_, cmsnewsite0_1_.culture as culture13_, cmsnewsite0_1_.content as content13_, cmsnewsite0_1_.approved as approved13_, cmsnewsite0_1_.access_level as access8_13_ from dbo.CMS_Item_News cmsnewsite0_ inner join dbo.CMS_Items cmsnewsite0_1_ on cmsnewsite0_.item_id=cmsnewsite0_1_.item_id where (cmsnewsite0_1_.culture=? ) order by cmsnewsite0_1_.created desc; ]
Name: culture - Value: en-US
[SQL: select cmsnewsite0_.item_id as item1_13_, cmsnewsite0_.title as title19_, cmsnewsite0_.subtitle as subtitle19_, cmsnewsite0_.summary as summary19_, cmsnewsite0_1_.content_type as content2_13_, cmsnewsite0_1_.created as created13_, cmsnewsite0_1_.resource as resource13_, cmsnewsite0_1_.culture as culture13_, cmsnewsite0_1_.content as content13_, cmsnewsite0_1_.approved as approved13_, cmsnewsite0_1_.access_level as access8_13_ from dbo.CMS_Item_News cmsnewsite0_ inner join dbo.CMS_Items cmsnewsite0_1_ on cmsnewsite0_.item_id=cmsnewsite0_1_.item_id where (cmsnewsite0_1_.culture=? ) order by cmsnewsite0_1_.created desc;]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +110
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) +78
NHibernate.Hql.Classic.QueryTranslator.List(ISessionImplementor session, QueryParameters queryParameters) +21
NHibernate.Impl.SessionImpl.Find(String query, QueryParameters parameters, IList results) +208
NHibernate.Impl.SessionImpl.Find(String query, QueryParameters parameters) +46
NHibernate.Impl.QueryImpl.List() +114
MessageLabs.Domain.DAO.CmsNewsDao.GetLatestNews(Int32 max, String culture) in C:\Projects\development\MessageLabs\MessageLabs.Domain\DAO\CmsNewsDao.cs:26
MessageLabs.Services.News.GetLatestNews(Int32 max) in C:\Projects\development\MessageLabs\MessageLabs.Services\News.cs:22
_Default.Populate_News_Events() in c:\Projects\development\MessageLabs\MessageLabs.Website\Default.aspx.cs:48
_Default.Page_Load(Object sender, EventArgs e) in c:\Projects\development\MessageLabs\MessageLabs.Website\Default.aspx.cs:38
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3744