Matt,
Have you had to deal with properly handling the Db2 datatypes Date, Time,
and TimeStmp?
dbl
On Wednesday, August 31, 2011 11:17:39 AM UTC-6, DBLWizard wrote:
> 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 or how this config file should be set to make things work
> correctly.
>
> Thanks
>
> dbl
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/J74_WqBIMWMJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
