Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Full stack trace of any exception that occurs:
SpringNba.IntegrationTests.OracleIntegrationTestNoDbUnit (TestFixtureSetUp):
Spring.Objects.Factory.ObjectCreationException : Error creating object with name 'NHibernateSessionFactory' defined in 'assembly [SpringNba, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null], resource [SpringNba.Config.oracle-db-provider-context.xml]' : Initialization of object failed : Could not create the driver from NHibernate.Driver.OracleDataClientDriver.
----> NHibernate.HibernateException : Could not create the driver from NHibernate.Driver.OracleDataClientDriver.
----> System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.
----> NHibernate.HibernateException : The IDbCommand and IDbConnection implementation in the assembly Oracle.DataAccess could not be found. Ensure that the assembly Oracle.DataAccess is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly.
Name and version of the database you are using:
Oracle 10g
The generated SQL (show_sql=true):
hello all,
i am trying to use NHIbernate (via Spring.NET) connecting to an Oracle 10 g database.
here's my config data
Code:
<db:provider id="DbProvider"
provider="OracleODP-2.0"
connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));User Id=scott;Password=tiger;"/>
<object id="NHibernateSessionFactory" type="Spring.Data.NHibernate.LocalSessionFactoryObject, Spring.Data.NHibernate12">
<property name="DbProvider" ref="DbProvider"/>
<property name="MappingAssemblies">
<list>
<value>SpringNba</value>
</list>
</property>
<property name="HibernateProperties">
<dictionary>
<entry key="hibernate.hbm2ddl.auto"
value="update"/>
<entry key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"/>
<entry key="hibernate.dialect"
value="NHibernate.Dialect.OracleDialect"/>
<entry key="hibernate.connection.driver_class"
value="NHibernate.Driver.OracleDataClientDriver"/>
</dictionary>
</property>
</object>
and i keep on getting exception reported in this message.
I can successfully connect to oracle using , as example, Spring AdoTemplate...
for some reasons, i keepo n getting exception that code cannot find Oracle.DataAccess..... but if it was so, i could not even run my other code not using NHibernate
has anyone found similar problems?i m running my tests usign NUnit 2.6..
anyone could help?
thanks and regars
marco