Howdy,
I am trying to get DB2 zOS 9 to work with NHibernate but I can not
find clear documenation on how to setup the app.config and the
hibernate.cfg.xml file. I'm getting an error when its trying to build
the SQL statements a substituting parameters. So I want to make sure
I've got my config file setup. I have tried both of these to
configurations and both get the same error.
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory name="Test">
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
property>
<property name="dialect">NHibernate.Dialect.DB2Dialect</property>
<property
name="connection.driver_class">NHibernate.Driver.DB2Driver</property>
<property
name="connection.connection_string">Database=dbalias;Uid=myUid;
Pwd=myPass</property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>
This is an ODBC example I found:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.0" >
<session-factory name="session">
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
property>
<property
name="connection.driver_class">NHibernate.Driver.OdbcDriver</property>
<property name="connection.connection_string">driver={IBM DB2
ODBC DRIVER};Database=db;hostname=host;port=port;protocol=TCPIP;
uid=uid; pwd=pwd</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.DB2Dialect</
property>
</session-factory>
</hibernate-configuration>
As I said I've tried both of these and get the same error and it
revolves around the false return of the UseNamedPrefixInSql function.
The Error I'm getting is:
could not load an entity: [ADRPData.Domain.DocType#ArbAssocRuling]
[SQL: SELECT doctype0_.SDOCTYPEID as SDOCTYPEID1_0_,
doctype0_.SDOCTYPECODE as SDOCTYPE2_1_0_ FROM DocType doctype0_ WHERE
doctype0_.SDOCTYPEID=?]
Can anybody point me to a good resource for using NHibernate with DB2
zOS UDB or how this config file should be set to make things work
correctly.
thanks
dbl
