The version is 1.20 GA.
I was moving my database from MSSQL to MYSQL, while the generated SQL reminds me cannot find table "dbo.countries" where countries is one of my table.
I have no idea which schema name shall i put infront of my table name, since in MYSQL i cannot find this info. So i tried to change the NHibernate config file
Code:
<config>
<add key="hibernate.connection.driver_class" value="NHibernate.Driver.MySqlDataDriver"/>
<add key="hibernate.dialect" value="NHibernate.Dialect.MySQLDialect"/>
<add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
<add key="hibernate.connection.connection_string" value="ConnectionString = ${HotelPortal}"/>
<add key="hibernate.default_schema" value="abc" />
</config>
and hope this will change the generated sql to select data from abc.countries. While the result is, the generated sql still looking for dbo.countries and the "hibernate.default_schema" seems has no effect.
Since i was using Castle AR on top of NHibernate, so i don't have the mapping file here. While i already removed all "shema" attributes from my
AR classes, so i thought it should use the default_schema when generating the SQL.
can anyone advise me? really thanx a lot!
Login
FAQ
Search