thanks for the help I think I got pass the problem by changing the parm on the mapping
Anthony Dyer Director of Technology, Transportation (847) 954 4526 or (847) 699-6620 <mailto:anthonyd...@frontiernet.net> anthonyd...@frontiernet.net www.logility.com -----Original Message----- From: nhusers@googlegroups.com [mailto:nhus...@googlegroups.com] On Behalf Of Fabio Maulo Sent: Monday, April 27, 2009 5:18 PM To: nhusers@googlegroups.com Subject: [nhusers] Re: Oracke Transaction NH1.2.0 ?!!?!!?? Really ? 2009/4/27 Anthony Dyer <anthonyd...@frontiernet.net> Anyone has any ideas of how to get around this problem? Anthony Dyer Director of Technology, Transportation (847) 954 4526 or (847) 699-6620 anthonyd...@frontiernet.net www.logility.com -----Original Message----- From: nhusers@googlegroups.com [mailto:nhus...@googlegroups.com] On Behalf Of Anthony Dyer Sent: Monday, April 27, 2009 12:46 PM To: nhusers@googlegroups.com Subject: [nhusers] Re: Oracke Transaction Thanks for the reply- The mapping is: <?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> <class name="Logility.WebDB.Table.user_def, WebDB.Entity" table="user_def" lazy="true"> <id name="user_nbr" column ="user_nbr" type="Logility.Data.Type.NumericInteger, Logility.Data"> <generator class="assigned" /> </id> <property name="name_txt" column="name_txt" type="String" length="60" /> <property name="pass_txt" column="pass_txt" type="String" length="128" /> <property name="email_txt" column="email_txt" type="String" length="500" /> <property name="user_id" column="user_id" type="String" length="60" /> <property name="style_txt" column="style_txt" type="String" length="100" /> <property name="ldap_ind" column="ldap_ind" type="Logility.Data.Type.Fixed1, Logility.Data" length="1" /> <property name="sys_user_id" column="sys_user_id" type="String" length="30" /> </class> </hibernate-mapping> I have attached the code for the logility.data.type.integer and logility.data.type.fixed1 I am not sure why we have done it this way- but it is what I have to work with- The fields are defined the same in SQL Server and Oracle- I have attached how the first field (key) is defineed in both SQL and Oracle- I did notice that all of the lenghts in the mapping are greater than (usually double) the lengths on the columns themselves- but do not think that should cause a problem- Especially since this is a SELECT (read) Anthony Dyer Director of Technology, Transportation (847) 954 4526 or (847) 699-6620 anthonyd...@frontiernet.net www.logility.com -----Original Message----- From: nhusers@googlegroups.com [mailto:nhus...@googlegroups.com] On Behalf Of mhanney Sent: Monday, April 27, 2009 11:48 AM To: nhusers Subject: [nhusers] Re: Oracke Transaction In hibernate.session.jpg IdentityColumnString throws an exception because Oracle has no built in mechanism for identity key generation. This is probably the same reason forthis warning: WARN 2009-04-27 11:09:04 - System.ArgumentException: identifier type mismatch Parameter name: id. How are you defining id in your mappings? and are you using the same mappings for all of the DB dialects? Please can you post the mapping for the user_def table. On Apr 27, 9:35 am, "Anthony Dyer" <anthonyd...@frontiernet.net> wrote: > I got the logging working. > I am getting this error: > > [ SELECT this_.user_nbr as user1_0_0_, this_.name_txt as name2_0_0_, > this_.pass_txt as pass3_0_0_, this_.email_txt as email4_0_0_, > this_.user_id as user5_0_0_, this_.style_txt as style6_0_0_, > this_.ldap_ind as ldap7_0_0_, this_.sys_user_id as sys8_0_0_ FROM > user_def this_ WHERE this_.user_nbr = ? ] Positional parameters: 0 > 63 > > System.ArgumentException: identifier type mismatch > Parameter name: id > at NHibernate.Engine.EntityKey..ctor(Object id, Object > identifierSpace, Type clazz, IType identifierType, Boolean > isBatchLoadable, ISessionFactoryImplementor factory) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Engine\EntityKey.cs:lin > e 37 > at NHibernate.Engine.EntityKey..ctor(Object id, IEntityPersister p) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Engine\EntityKey.cs:line 54 > at NHibernate.Loader.Loader.GetKeyFromResultSet(Int32 i, ILoadable > persister, Object id, IDataReader rs, ISessionImplementor session) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 843 > at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, > ISessionImplementor session, QueryParameters queryParameters, LockMode[] > lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, > EntityKey[] keys, Boolean returnProxies) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 305 > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, > QueryParameters queryParameters, Boolean returnProxies) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 447 > at > NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImpl > ementor session, QueryParameters queryParameters, Boolean > returnProxies) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line > 181 > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, > QueryParameters queryParameters) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 1792 > WARN 2009-04-27 11:09:04 - System.ArgumentException: identifier type > mismatch > Parameter name: id > at NHibernate.Engine.EntityKey..ctor(Object id, Object identifierSpace, > Type clazz, IType identifierType, Boolean isBatchLoadable, > ISessionFactoryImplementor factory) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Engine\EntityKey.cs:line 37 > at NHibernate.Engine.EntityKey..ctor(Object id, IEntityPersister p) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Engine\EntityKey.cs:line 54 > at NHibernate.Loader.Loader.GetKeyFromResultSet(Int32 i, ILoadable > persister, Object id, IDataReader rs, ISessionImplementor session) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 843 > at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, > ISessionImplementor session, QueryParameters queryParameters, LockMode[] > lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, > EntityKey[] keys, Boolean returnProxies) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 305 > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, > QueryParameters queryParameters, Boolean returnProxies) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 447 > at > NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImpl > ementor session, QueryParameters queryParameters, Boolean > returnProxies) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line > 181 > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, > QueryParameters queryParameters) in > C:\DOWNLOAD\NHibernate\1.2.0.GA\src\NHibernate\Loader\Loader.cs:line 1792 > ERROR2009-04-27 11:09:04 - identifier type mismatch > > I am not sure what it means- this is on a SELECT against an Oracle 11g > database. > > Anthony Dyer > Director of Technology, Transportation > (847) 954 4526 or (847) 699-6620 > anthonyd...@frontiernet.netwww.logility.com > > -----Original Message----- > From: Anthony Dyer [mailto:anthonyd...@frontiernet.net] > Sent: Monday, April 27, 2009 11:22 AM > To: 'nhusers@googlegroups.com' > Subject: RE: [nhusers] Re: Oracke Transaction > > Never mind- I got the logging working > > Anthony Dyer > Director of Technology, Transportation > (847) 954 4526 or (847) 699-6620 > anthonyd...@frontiernet.netwww.logility.com > > -----Original Message----- > From: Anthony Dyer [mailto:anthonyd...@frontiernet.net] > Sent: Monday, April 27, 2009 9:41 AM > To: 'nhusers@googlegroups.com' > Subject: RE: [nhusers] Re: Oracke Transaction > > I actually have a couple of questions > > I am trying to get debugging out of log4net - How do I get hibernate > to do logging? (we have nothing in the web.config for hibernate, do > have for > log4net) > > 2. this is the code that builds the hibernate.config: > > config.Properties.Add("hibernate.connection.provider", > "NHibernate.Connection.DriverConnectionProvider"); > switch (connection.DatabaseType) > { > case "SQL": > { > > config.Properties.Add("hibernate.connection.driver_class", > "NHibernate.Driver.SqlClientDriver"); > > config.Properties.Add("hibernate.dialect", > "NHibernate.Dialect.MsSql2000Dialect"); > break; > } > case "ORA": > { > > config.Properties.Add("hibernate.connection.driver_class", > "NHibernate.Driver.OracleClientDriver"); > > config.Properties.Add("hibernate.dialect", > "NHibernate.Dialect.OracleDialect"); > break; > } > case "DB2": > { > > config.Properties.Add("hibernate.connection.driver_class", > "NHibernate.Driver.DB2Driver"); > > config.Properties.Add("hibernate.dialect", > "NHibernate.Dialect.DB2Dialect"); > break; > } > default: > { > break; > } > } > config.Properties.Add("hibernate.max_fetch_depth", > "-1"); > > config.Properties.Add("hibernate.connection.connection_string", > connection.OrmConnectString); > > //config.Properties.Add("hibernate.use_reflection_optimizer", > "false"); > config.Properties.Add("hibernate.show_sql", "true"); > // add current assembly > this._nhibernateConfiguration = > config.AddAssembly(this.GetType().Assembly); > // assembly loaded > config.SetInterceptor(new > Logility.Data.DaoInterceptor()); > this._nhibernateFactory = > this._nhibernateConfiguration.BuildSessionFactory(); > > And this is what it looks like after the logic has been processed: > > (see attached) > > But after I do the session.Open, I see: > > See second attachement (hibernate.session) > > Then when I do the session.BeginTransaction(); I get > (see third attachement 9 hibernate.transaction) > But the table does exist - > It should be referencing a synonym - but I can not see the actual SQL > statement (because of logging- which I can not get turned on) > > Any help will be much appreciated- > > thanks > > Anthony Dyer > Director of Technology, Transportation > (847) 954 4526 or (847) 699-6620 > anthonyd...@frontiernet.netwww.logility.com > > -----Original Message----- > From: Anthony Dyer [mailto:anthonyd...@frontiernet.net] > Sent: Sunday, April 26, 2009 1:23 PM > To: nhusers@googlegroups.com > Subject: RE: [nhusers] Re: Oracke Transaction > > We are building the config dynamically in the program > Thanks for the reply- > I will have to check tomorrow > I did see where the dialect was being set - but not sure it is > correctly set > > Anthony Dyer > Director of Technology, Transportation > (847) 954 4526 or (847) 699-6620 > anthonyd...@frontiernet.netwww.logility.com > > -----Original Message----- > From: nhusers@googlegroups.com [mailto:nhus...@googlegroups.com] On > Behalf Of mhanney > Sent: Sunday, April 26, 2009 11:35 AM > To: nhusers > Subject: [nhusers] Re: Oracke Transaction > > In your nhibernate.config for Oracle, do you have <property > name="connection.isolation"> set, and if so, what value is it set to? > Did you try <property name="connection.isolation">ReadCommitted</ > property> ? > > On Apr 24, 11:37 am, AAD <anthonyd...@frontiernet.net> wrote: > > I have a system that needs to interface with SQL Server or Oracle > > 11g. In the code, there is the following: > > > session = Data.DaoFactory.OpenSession(systemInstance); > > transaction = session.BeginTransaction(); > > > when I run and am connected to SQL Server, the BeginTransaction() > > works fine, with I am connected to Oracle, I get an error: > > > + IsolationLevel > > + '((NHibernate.Transaction.AdoTransaction) > > (transaction)).IsolationLevel' threw an exception of type > > 'System.Data.OracleClient.OracleException' > > System.Data.IsolationLevel > > {System.Data.OracleClient.OracleException} > > > any suggestion on how to go about debugging? > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
