I want to use DataAccess with SqlMapper.but errors there.
 
I use provider for oracle:
 <provider
  name="oracleClient1.0"
  description="Oracle, Microsoft provider V1.0.5000.0"
  enabled="true"
  default="false"
  assemblyName="System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
  connectionClass="System.Data.OracleClient.OracleConnection" 
  commandClass=" System.Data.OracleClient.OracleCommand"
  parameterClass="System.Data.OracleClient.OracleParameter"
  parameterDbTypeClass="System.Data.OracleClient.OracleType"
  parameterDbTypeProperty="OracleType"
  dataAdapterClass="System.Data.OracleClient.OracleDataAdapter"
  commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder"
  usePositionalParameters = "false"
  useParameterPrefixInSql = "true"
  useParameterPrefixInParameter = "false"
  parameterPrefix=":"
 />

dao.config as:
<?xml version="1.0" encoding="utf-8"?>
<daoConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
  
 <providers resource="providers.config"/>

 <context id="SqlMapDao" default="true">
     
  <database>
   <provider name="oracleClient1.0"/>
   <dataSource name="ibatisDemo" connectionString="Data Source=DATA-89;Persist Security Info=True;User ID=data;password=data"/>
  </database>   
  
  <daoSessionHandlers>
  <daoSessionHandler id="SqlMap">
   <property name="resource" value="sqlMap.config"/>
  </daoSessionHandler>
  </daoSessionHandlers>
  
  <daoFactory>
   <dao interface="OraTest.IProduct"  implementation="OraTest.ProductDAO"/>   
  </daoFactory>
 </context>
 
</daoConfig>

but errors:

Unhandled Exception: IBatisNet.Common.Exceptions.ConfigurationException:
- The error occurred while add global properties.
- configure provider
- The error occurred in <provider name="oracleClient1.0 " />.
- Check the oracleClient1.0. ---> System.NullReferenceException: Object referenc
e not set to an instance of an object.
   at IBatisNet.DataAccess.Configuration.DomDaoManagerBuilder.ParseProvider (Conf
igurationScope configurationScope)
   at IBatisNet.DataAccess.Configuration.DomDaoManagerBuilder.GetContexts(Config
urationScope configurationScope)
   at IBatisNet.DataAccess.Configuration.DomDaoManagerBuilder.BuildDaoManagers (X
mlDocument document, Boolean useConfigFileWatcher)
   --- End of inner exception stack trace ---
   at IBatisNet.DataAccess.Configuration.DomDaoManagerBuilder.BuildDaoManagers(X
mlDocument document, Boolean useConfigFileWatcher)
   at IBatisNet.DataAccess.Configuration.DomDaoManagerBuilder.Configure(String r
esource)
   at IBatisNet.DataAccess.Configuration.DomDaoManagerBuilder.Configure()
   at OraTest.BaseDao.GetLocalSqlMap() in E:\work_net\ibatisNet\DATest\OraTest\B
aseDAO.cs:line 29
   at OraTest.BaseDao.ExecuteQueryForList(String statementName, Object parameter
Object) in E:\work_net\ibatisNet\DATest\OraTest\BaseDAO.cs:line 46
   at OraTest.ProductDAO.GetProductList() in E:\work_net\ibatisNet\DATest\OraTes
t\ProductDAO.cs:line 16
   at OraTest.Program.Main() in E:\work_net\ibatisNet\DATest\OraTest\Program.cs:
line 17

Reply via email to