I thought NH requires that it uses the abstract DbConnection base (which is ADO.NET 2.0 right?), or at least that is the trouble I remember having :)
Thanks for the heads up, I'll toy around a bit more. I'm an idiot about the iSeries stuff. I just know we are V5R3 for client access, and when I asked the db guy about V6 he said it would require an upgrade on the server. On Jul 22, 12:06 pm, Nexus <[email protected]> wrote: > For V5, it's a .net provider based on 1.0 ADO.NET model, but this > still works with nhibernate. > > Our development machines our using the new driver V6R1, and our server > is DB2 on ISeries 5 with V6 client access, we started it up before > nhibernate came into play. And you really don't need ADO.NET 2.0 with > Nhibernate, no use of transactionscope > > Kind regards > > Nexus > > On 22 jul, 14:07, Eyston <[email protected]> wrote: > > > > > Howdy. > > > For a driver on your V5R4 you are using Odbc or? When I ask my db guy > > and search IBM there doesn't appear to be an option of an ADO.NET 2.0 > > provider for V5? Just wanting to make sure I'm not missing something > > obvious. V6 has one though. > > > On Jul 22, 6:14 am, Nexus <[email protected]> wrote: > > > > Hello, > > > > As we are using DB2400Dialect on a iseries 5v4 and 6v1 provider, we > > > found that the BLOB and CLOB support, is not working, or you need to > > > specify sql-type in mapping. > > > > To improve this , i've implemented an DB2400V5Dialect that corrects > > > this behaviour and more improvements on varchar and char sizes also > > > added a default binary. > > > > Also DB2 for ISeries supports sequences > > > > // ReSharper disable InconsistentNaming > > > public class DB2400V5Dialect : DB2400Dialect > > > // ReSharper restore InconsistentNaming > > > { > > > #region Public Properties (1) > > > > /// <summary> > > > /// Gets a value indicating whether [supports sequences]. > > > /// </summary> > > > /// <value><c>true</c> if [supports sequences]; otherwise, > > > <c>false</c>.</value> > > > public override bool SupportsSequences > > > { > > > get > > > { > > > return true; > > > } > > > } > > > > #endregion Public Properties > > > > #region Constructors (1) > > > > /// <summary> > > > /// Initializes a new instance of the <see > > > cref="DB2400Dialect"/> class. > > > /// </summary> > > > public DB2400V5Dialect() > > > { > > > // Length between 1 and 32765 for nullable CHAR > > > RegisterColumnType(DbType.AnsiStringFixedLength, 32765, > > > "CHAR($l)"); > > > // Length between 1 and 32739 for nullable VARCHAR > > > RegisterColumnType(DbType.AnsiString, 32739, "VARCHAR > > > ($l)"); > > > RegisterColumnType(DbType.AnsiString, 2147483647, "CLOB > > > ($l)"); > > > // default binary size 1 mb > > > RegisterColumnType(DbType.Binary, "BLOB"); > > > RegisterColumnType(DbType.Binary, 2147483647, "BLOB($l)"); > > > RegisterColumnType(DbType.String, 32739, "VARCHAR($l)"); > > > RegisterColumnType(DbType.String, 2147483647, "CLOB($l)"); > > > } > > > > #endregion Constructors > > > } > > > > Kind regards > > > > Ps: Maybe not really a request for change, but still it could help > > > others working on ISeries DB2- Tekst uit oorspronkelijk bericht niet > > > weergeven - > > > - Tekst uit oorspronkelijk bericht weergeven - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. 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 -~----------~----~----~----~------~----~------~--~---
