IBatisNet+Oracle.ManagedDataAccess打造无需安装oracle客户端和ODP即可连接oracle数据库

最新推荐文章于 2023-03-30 16:04:36 发布

weixin_30595035

最新推荐文章于 2023-03-30 16:04:36 发布

阅读量216

点赞数

文章标签：数据库网络

原文链接：http://www.cnblogs.com/deeround/p/7151349.html

版权

库环境：

Oracle.ManagedDataAccess　　版本：4.122.1.0

IBatisNet　　　　　　　　　　版本：1.6.2

其实很简单的，只需在驱动配置那里添加上Oracle.ManagedDataAccess驱动相关的配置即可

1.修改驱动配置文件providers.config

  <provider
    name="oracle12"
    description="Oracle, oracle provider V4.122.1.0"
    enabled="true"
    assemblyName="Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionClass="Oracle.ManagedDataAccess.Client.OracleConnection"
    commandClass="Oracle.ManagedDataAccess.Client.OracleCommand"
    parameterClass="Oracle.ManagedDataAccess.Client.OracleParameter"
    parameterDbTypeClass="Oracle.ManagedDataAccess.Client.OracleDbType"
    parameterDbTypeProperty="OracleDbType"
    dataAdapterClass="Oracle.ManagedDataAccess.Client.OracleDataAdapter"
    commandBuilderClass="Oracle.ManagedDataAccess.Client.OracleCommandBuilder"
    usePositionalParameters="true"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix=":"
    useDeriveParameters="false"/>

2.修改连接字符串已经驱动名称sqlmap.config

1   <database>
4     <dataSource name="iBatisNet" connectionString="data source=${datasource};database=${database};user id=${userid};password=${password};connection reset=false;connection lifetime=5; min pool size=1; max pool size=50"/>-->
5     <provider name="oracle12" />
7     <dataSource name="iBatisNet" connectionString="Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.248)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = jbsb)));User ID=elane_sbk_test;Password=elane_sbk_test;"/>
8   </database>