GenereicAdoException will have an InnerException property, and that in turn may also have an InnerException and so on. These will often tell you what the problem is.
/Oskar 2017-08-11 1:44 GMT+01:00 Ganesh Gebhard <[email protected]>: > Sure. Everytime I want to add a new table, 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-3718907727c4 > a695ff28360f4d3e9ea946495840\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-3718907727c4 > a695ff28360f4d3e9ea946495840\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. > > > I can copy the query and try to execute it in the database, but I don't > know how to do that. > > Op donderdag 10 augustus 2017 23:55:27 UTC+2 schreef Gunnar Liljas: >> >> Is it an NHibernate issue? >> >> Can you be more specific? >> >> /g >> >> On 10 Aug 2017, at 20:03, Ganesh Gebhard <[email protected]> wrote: >> >> Hi, >> >> I tried to add a new table to the sql database, but it gives an error no >> matter what I do. >> >> So, what are the steps to add a new table to the sql database? >> >> Thanks in advance. >> >> -- >> 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. >> >> -- > 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. > -- 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.
