EDIT: So, the message is 'Object reference not set to an instance of an
object.'
This message is generated in NHDataCore.cs by the part:
public ISession OpenSession()
{
return FCurrentSession ?? (FCurrentSession =
FSessionFactory.OpenSession());
}
I actually don't know why.
<https://lh3.googleusercontent.com/-ScUtbrU0B8Y/WY8qcJCshvI/AAAAAAAAADE/I1H50YQr04Ez8EdcAnOSbPVmD3GqBIKjgCLcBGAs/s1600/NH.PNG>
Op zaterdag 12 augustus 2017 11:05:48 UTC+2 schreef Oskar Berggren:
>
> 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]
> <javascript:>>:
>
>> 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-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.
>>
>>
>> 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] <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.
>>
>
>
--
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.
