Hi All,

I am using NHibernate 1.2 and MySQL Driver 5.1

I had done MS SQL Server +NHibernate integration successfully.


Now,I am trying to integrate NHibernate with MYSql. I have followed all the steps still i am getting

"Could not create the driver from NHibernate.Driver.MySqlDataDriver."

My Hibernate.cfg.xml is below.

<?xml version='1.0' encoding='utf-8'?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">

<!-- an ISessionFactory instance -->
<session-factory>

<!-- properties -->
<property name="dialect">NHibernate.Dialect.MySQLDialect</property>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
<property name="connection.connection_string">Server=localhost;Database=database;User ID=username;Password=paswd;CharSet=win1250;</property>
<property name="show_sql">true</property>

<!-- mapping files -->
<mapping assembly="DB.Library" />

</session-factory>

</hibernate-configuration>


I have followed this link for NHibernate integration for MySql.

http://geekswithblogs.net/pariam/archiv ... 86352.aspx

stack trace :

at NHibernate.Connection.ConnectionProvider.ConfigureDriver(IDictionary settings)
at NHibernate.Connection.ConnectionProvider.Configure(IDictionary settings)
at NHibernate.Connection.ConnectionProviderFactory.NewConnectionProvider(IDictionary settings)
at NHibernate.Cfg.SettingsFactory.BuildSettings(IDictionary properties)
at NHibernate.Cfg.Configuration.BuildSettings()
at NHibernate.Cfg.Configuration.BuildSessionFactory()
at com.resecon.video.db.NHibernateHelper..cctor() in 17


Regards,
Jigar[/b]

Hi,

That it's the unique error that you get ? You can provide all inner exceptions ?

Below is the innerException.


InnerException :

{"Exception has been thrown by the target of an invocation."}

{"The IDbCommand and IDbConnection implementation in the assembly MySql.Data could not be found. Ensure that the assembly MySql.Data is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly."}

stacktrace :

" at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)\r\n at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)\r\n at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)\r\n at System.Activator.CreateInstance(Type type, Boolean nonPublic)\r\n at System.Activator.CreateInstance(Type type)\r\n at NHibernate.Connection.ConnectionProvider.ConfigureDriver(IDictionary settings)"

Regards,
Jigar

Make shure that you have at the output directory the assembly MySql.Data.dll.
You can download here:
http://dev.mysql.com/downloads/connector/net/

and if u already have MySql.Data.dll. Just go to your project references and select MySql.Data.dll, then go to the properties window and change the 'Copy Local' property to True.