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=":"
/>
<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

