ibatis 连接字符串 SqlMapConfig.xml

ibatis 连接字符串 SqlMapConfig.xml

 

下面两个dtd 文件的位置-------在ibatis 的jar 包中，ibatis-2.3.0.677.jar( 不同的版本，文件位置和文件名称有所不同)

com.ibatis.sqlmap.engine.builder.xml 包中

修改dtd 文件位置，是为了能提示

原： "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"

修改后： "./sql-map-config-2.dtd","./"是与当前文件(SqlMapConfig.xml)同级目录

sql-map-2.dtd

sql-map-config-2.dtd

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
    "./sql-map-config-2.dtd">
    
<sqlMapConfig>

  <!-- Configure a built-in transaction manager.  If you're using an 
       app server, you probably want to use its transaction manager 
       and a managed datasource -->
   <!-- 
  <transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:mysql://192.168.122.128/test" />
      <property name="JDBC.Username" value="root"/>
      <property name="JDBC.Password" value="root"/>
    </dataSource>
  </transactionManager>
   -->
    <transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@192.168.122.128:1521:ACCP" />
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="oracle"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the 
       classpath, as they are here (com.domain.data...) -->
  <sqlMap resource="Account.xml"/>
  <!-- List more here...
  <sqlMap resource="com/mydomain/data/Order.xml"/>
  <sqlMap resource="com/mydomain/data/Documents.xml"/>
  -->

</sqlMapConfig>