NHibernate problemer

jeg har et "hello world" eksempel som jeg kan poste

Det ville være dejligt :)
Specielt hvis du kunne knytte et par kommentarer til hvor configurationsfilerne placeres osv.

SQLServer (så du skal rette en lille smule)

opret tabel:

CREATE TABLE T1 (F1 INTEGER PRIMARY KEY, F2 VARCHAR(50))
GO
INSERT INTO T1 VALUES(1, 'A')
GO
INSERT INTO T1 VALUES(2, 'BB')
GO
INSERT INTO T1 VALUES(3, 'CCC')
GO

min t1mapping.xml

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
    <class name="Test.Hibernate.T1, Test, Version=1.0.2100.41493, Culture=neutral, PublicKeyToken=null" table="T1">
        <id name="F1" column="F1">
            <generator class="assigned"/>
        </id>
        <property name="F2">
            <column name="F2"/>
        </property>
    </class>
</hibernate-mapping>

refererer til T1 klassen og jeg bruger en primær nøgle som jeg selv styrer

Done :)

selve koden:

using System;
using System.Collections;

using NHibernate;
using NHibernate.Cfg;

using log4net.Config;

namespace Test.Hibernate
{
    public class T1
    {
        private int f1;
        private string f2;
        public int F1
        {
            get
            {
                return f1;
            }
            set
            {
                f1 = value;
            }
        }
        public string F2
        {
            get
            {
                return f2;
            }
            set
            {
                f2 = value;
            }
        }
    }
    public class TestClass
    {
        public static void SelectOne()
        {
            Configuration cfg = new Configuration();
            cfg.AddXmlFile("t1mapping.xml");
            ISessionFactory sf = cfg.BuildSessionFactory();
            ISession s = sf.OpenSession();
            T1 r = (T1)s.Load(typeof(T1), 2);
            Console.WriteLine(r.F1 + " " + r.F2);
            s.Close();
        }
        public static void SelectAll()
        {
            Configuration cfg = new Configuration();
            cfg.AddXmlFile("t1mapping.xml");
            ISessionFactory sf = cfg.BuildSessionFactory();
            ISession s = sf.OpenSession();
            IList all = s.Find("FROM T1 AS t1");
            for(int i = 0; i < all.Count; i++) {
                T1 r = (T1)all[i];
                Console.WriteLine(r.F1 + " " + r.F2);
            }
            s.Close();
        }
        public static void Main(string[] args)
        {
            XmlConfigurator.Configure();
            SelectOne(); 
            SelectAll();
        }
    }
}

bemærk at jeg loader t1mapping.xml manuelt

og det aller vigtigste test.exe.config (som skal ligge i samme dir som test.exe)

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
        <section name="nhibernate" type="System.Configuration.NameValueSectionHandler,System,Version=1.0.5000.0,Culture=neutral,PublicKeyToken=b77a5c561934e089"/>
        <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net"/>
    </configSections>
    <nhibernate>
        <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
        <add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver"/>
        <add key="hibernate.connection.connection_string" value="Server=ARNEPC3;Integrated Security=SSPI;database=Test"/>
        <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
    </nhibernate>
    <log4net>
        <appender name="console" type="log4net.Appender.ConsoleAppender,log4net">
            <layout type="log4net.Layout.PatternLayout,log4net">
                <param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
            </layout>
        </appender>
        <root>
            <priority value="DEBUG"/>
            <appender-ref ref="console" />
        </root>
        <logger name="NHibernate">
            <priority value="WARN"/>
        </logger>
    </log4net>
</configuration>

her defineres både NHibernate og log4net (som NHibernate bruger)

bl.a. skal database connection konfigureres her

bemærk at NHibernate er et stort område - det her dækker en halv procent af
funcktionaliteten eller deromkring, men man skal jo starte et sted

Giver mig følgende:

2007-01-13 16:31:14,296 [1980] ERROR NHibernate.Cfg.Configuration - Could not co
mpile the mapping document
NHibernate.MappingException: persistent class Test.Hibernate.T1, Test, Version=1
.0.2100.41493, Culture=neutral, PublicKeyToken=null not found ---> System.TypeLo
adException: Could not load type 'Test.Hibernate.T1, Test, Version=1.0.2100.4149
3, Culture=neutral, PublicKeyToken=null', check that type and assembly names are
correct
  at NHibernate.Util.ReflectHelper.ClassForName(String name)
  at NHibernate.Cfg.Binder.ClassForFullNameChecked(String fullName, String erro
rMessage)
  --- End of inner exception stack trace ---
  at NHibernate.Cfg.Binder.ClassForFullNameChecked(String fullName, String erro
rMessage)
  at NHibernate.Cfg.Binder.BindClass(XmlNode node, PersistentClass model, Mappi
ngs mapping)
  at NHibernate.Cfg.Binder.BindRootClass(XmlNode node, RootClass model, Mapping
s mappings)
  at NHibernate.Cfg.Binder.BindRoot(XmlDocument doc, Mappings model)
  at NHibernate.Cfg.Configuration.AddValidatedDocument(XmlDocument doc)
2007-01-13 16:31:14,343 [1980] ERROR NHibernate.Cfg.Configuration - Could not co
nfigure datastore from file: t1mapping.xml
NHibernate.MappingException: persistent class Test.Hibernate.T1, Test, Version=1
.0.2100.41493, Culture=neutral, PublicKeyToken=null not found ---> System.TypeLo
adException: Could not load type 'Test.Hibernate.T1, Test, Version=1.0.2100.4149
3, Culture=neutral, PublicKeyToken=null', check that type and assembly names are
correct
  at NHibernate.Util.ReflectHelper.ClassForName(String name)
  at NHibernate.Cfg.Binder.ClassForFullNameChecked(String fullName, String erro
rMessage)
  --- End of inner exception stack trace ---
  at NHibernate.Cfg.Binder.ClassForFullNameChecked(String fullName, String erro
rMessage)
  at NHibernate.Cfg.Binder.BindClass(XmlNode node, PersistentClass model, Mappi
ngs mapping)
  at NHibernate.Cfg.Binder.BindRootClass(XmlNode node, RootClass model, Mapping
s mappings)
  at NHibernate.Cfg.Binder.BindRoot(XmlDocument doc, Mappings model)
  at NHibernate.Cfg.Configuration.AddValidatedDocument(XmlDocument doc)
  at NHibernate.Cfg.Configuration.AddXmlReader(XmlTextReader hbmReader)
  at NHibernate.Cfg.Configuration.AddXmlFile(String xmlFile)

filen t1mapping.xml findes i debug-output bib.

test namespace på klassen og version

version på assembly altså

version på NHibernate.dll ?

nej den dll som indeholder T1 klassen (Test.dll i mit eksempel)

<class name="Test.Hibernate.T1, Test, Version=1.0.2100.41493, Culture=neutral, PublicKeyToken=null" table="T1">

klassenavn med namespace
dll navn
dll version
-
-
tabel i databasen

Jeg har lagt det hele ind i en ConsoleApplication - også T1-klassen.

jeg kan ikke huske om den version egentligt er nødvenig, men den er et mit eksempel
(det er lang tid siden at jeg lavede det så jeg kan ikke huske præcist hvorfor)

erstat dll med "dll eller exe" i alt ovenfor

Ok. Jeg har nu denne linje i konfigurationen:
<class name="Test.Hibernate.T1, ConsoleApplication1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" table="T1">

Hvilket giver mig en anden stacktrace, nemlig:

NHibernate.HibernateException: Could not create the driver from NHibernate.Drive
r.NpgsqlDriver. ---> System.Reflection.TargetInvocationException: Exception has
been thrown by the target of an invocation. ---> NHibernate.HibernateException:
The IDbCommand and IDbConnection implementation in the assembly Npgsql could not
be found.  Please ensure that the assembly Npgsql is in the Global Assembly Cac
he or in a location that NHibernate can use System.Type.GetType(string) to load
the types from.
  at NHibernate.Driver.ReflectionBasedDriver..ctor(String driverAssemblyName, S
tring connectionTypeName, String commandTypeName)
  at NHibernate.Driver.NpgsqlDriver..ctor()
  --- End of inner exception stack trace ---
  at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOn
ly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& b
NeedSecurityCheck)
  at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCach
e)
  at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisi
bilityChecks, Boolean fillCache)
  at System.Activator.CreateInstance(Type type, Boolean nonPublic)
  at System.Activator.CreateInstance(Type type)
  at NHibernate.Connection.ConnectionProvider.ConfigureDriver(IDictionary setti
ngs)
  --- End of inner exception stack trace ---
  at NHibernate.Connection.ConnectionProvider.ConfigureDriver(IDictionary setti
ngs)
  at NHibernate.Connection.ConnectionProvider.Configure(IDictionary settings)
  at NHibernate.Connection.ConnectionProviderFactory.NewConnectionProvider(IDic
tionary settings)
  at NHibernate.Cfg.SettingsFactory.BuildSettings(IDictionary properties)
  at NHibernate.Cfg.Configuration.BuildSettings()
  at NHibernate.Cfg.Configuration.BuildSessionFactory()
  at Test.Hibernate.TestClass.SelectOne() in C:\Documents and Settings\Administ
rator\My Documents\Visual Studio 2005\Projects\ConsoleApplication1\ConsoleApplic
ation1\Program.cs:line 44
  at Test.Hibernate.TestClass.Main(String[] args) in C:\Documents and Settings\
Administrator\My Documents\Visual Studio 2005\Projects\ConsoleApplication1\Conso
leApplication1\Program.cs:line 69

prøv og smid  Npgsql.dll i samme dir som din EXE

Puha, ja det gav en laaang stacktrace

Så virker det :)

Jeg takker.

Husk at smid et svar.

hmmm...

interface NHibernate.ISession
The main runtime interface between a Java application and Hibernate. This is the central API class abstracting the notion of a persistence service.

Find en fejl ;)

NHibernate er en .NET version af Hibernate til Java

og et svar

Er jeg klar over ;)