Thanks. Maybe a stupid question but how can I do this? Like copy the query and then execute it in the database?
Op maandag 31 juli 2017 22:09:06 UTC+2 schreef saltcode: > > copy the query and try to execute it in the database, that will show you > why you are getting the exception > > On Mon, Jul 31, 2017 at 8:15 PM, Ganesh Gebhard <[email protected] > <javascript:>> wrote: > >> Hi, >> >> I'm having some trouble when adding a new table to my SQL database. I get >> the following error: >> >> NHibernate.Exceptions.GenericADOException occurred >> >> HResult=0x80131600 >> >> Message=could not execute query >> >> [ select dcsv0_.id as id3_, dcsv0_.fnaam as fnaam3_, dcsv0_.fvolgorde as >> fvolgorde3_, dcsv0_.ftype as ftype3_, dcsv0_.fglobal as fglobal3_, >> dcsv0_.fmachine as fmachine3_, dcsv0_.fparameter as fparameter3_ from DCSV >> dcsv0_ ] >> >> [SQL: select dcsv0_.id as id3_, dcsv0_.fnaam as fnaam3_, dcsv0_.fvolgorde >> as fvolgorde3_, dcsv0_.ftype as ftype3_, dcsv0_.fglobal as fglobal3_, >> dcsv0_.fmachine as fmachine3_, dcsv0_.fparameter as fparameter3_ from DCSV >> dcsv0_] >> >> Source=NHibernate >> >> StackTrace: >> >> at NHibernate.Loader.Loader.DoList(ISessionImplementor session, >> QueryParameters queryParameters, IResultTransformer forcedResultTransformer) >> >> at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor >> session, QueryParameters queryParameters) >> >> at NHibernate.Loader.Loader.List(ISessionImplementor session, >> QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) >> >> at NHibernate.Loader.Hql.QueryLoader.List(ISessionImplementor session, >> QueryParameters queryParameters) >> >> at >> NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor >> session, QueryParameters queryParameters) >> >> at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters >> queryParameters, ISessionImplementor session, IList results) >> >> at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, >> QueryParameters queryParameters, IList results) >> >> at NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression >> queryExpression, QueryParameters parameters) >> >> at NHibernate.Impl.AbstractQueryImpl2.List() >> >> at NHibernate.Linq.DefaultQueryProvider.ExecuteQuery(NhLinqExpression >> nhLinqExpression, IQuery query, NhLinqExpression nhQuery) >> >> at NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression) >> >> at NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression >> expression) >> >> at Remotion.Linq.QueryableBase`1.GetEnumerator() >> >> at NHDataCore.NHTable`1.<AsEnumerable>d__14.MoveNext() in >> E:\Documenten\Weighpack\New Database >> 3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\NHDataCore\NHDataCore\NHTable.cs:line >> >> 172 >> >> at OMS2.Model.CSVs.refresh() in E:\Documenten\Weighpack\New Database >> 3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\CSVs.cs:line >> >> 39 >> >> at OMS2.Model.CSVs..ctor(DataModel AModel) in >> E:\Documenten\Weighpack\New Database >> 3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\CSVs.cs:line >> >> 32 >> >> at OMS2.Model.DataModel.LoadAllData() in E:\Documenten\Weighpack\New >> Database >> 3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\DataModel.cs:line >> >> 156 >> >> at OMS2.Model.DataModel..ctor() in E:\Documenten\Weighpack\New >> Database >> 3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\DataModel.cs:line >> >> 128 >> >> at OMS2.MainWindow.InitializeOMS() in E:\Documenten\Weighpack\New >> Database >> 3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\MainWindow.xaml.cs:line >> >> 69 >> >> at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate >> callback, Object args, Int32 numArgs) >> >> at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object >> source, Delegate callback, Object args, Int32 numArgs, Delegate >> catchHandler) >> >> >> The code for adding the new table in the database is: >> >> >> using NHDataCore; >> >> using FluentNHibernate.Mapping; >> >> >> namespace OMS2.Model.Entities >> >> { >> >> public class DCSV : NHRow >> >> { >> >> [Indexed] >> >> >> public virtual string naam { get; set; } >> >> public virtual int volgorde { get; set; } >> >> public virtual string type { get; set; } >> >> public virtual string global { get; set; } >> >> public virtual string machine { get; set; } >> >> public virtual string parameter { get; set; } >> >> } >> >> >> public class DCSVMap : ClassMap<DCSV> >> >> { >> >> public DCSVMap() >> >> { >> >> Table("DCSV"); >> >> Cache.NonStrictReadWrite(); >> >> Id(x => x.id).GeneratedBy.Native(); >> >> Map(x => x.naam, "fnaam"); >> >> Map(x => x.volgorde, "fvolgorde"); >> >> Map(x => x.type, "ftype"); >> >> Map(x => x.global, "fglobal"); >> >> Map(x => x.machine, "fmachine"); >> >> Map(x => x.parameter, "fparameter"); >> >> } >> >> } >> >> } >> >> >> When I remove everything under public class DCSVMap : ClassMap<DCSV>, the >> code will run. But when I add it again, the previous error occurs. >> >> >> Can someone tell me what's wrong? Or do I need to give more specific >> details? >> >> >> Thanks a lot. >> >> >> Ganesh >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Best Regards > Apatira Lookman > +2348028400104 > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
