These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: Incorrect syntax near ';' Exception
PostPosted: Tue Apr 10, 2007 3:00 pm 
Newbie

Joined: Tue Apr 10, 2007 2:54 pm
Posts: 2
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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 3:52 pm 
Newbie

Joined: Tue Apr 10, 2007 2:54 pm
Posts: 2
My HQL was wrong and had a ; at the end :) Sorry for posting without first verifying all avenues.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.