我的SqlMapConfig.xml内容如下 驱动包和ibaties包都导入了
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<properties resource="com/scott/jdbc.properties"/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="Driver" value="${driverClassName}"/>
<property name="Url" value="${url}"/>
<property name="Username" value="${username}"/>
<property name="Password" value="${password}"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/scott/emp.xml"/>
</sqlMapConfig>jdbc.properties内容如下
driverClassName = oracle.jdbc.driver.OracleDriver
url = jdbc:oracle:thin:@127.0.0.1:1521:orcl
username = scott
password = tiger
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<properties resource="com/scott/jdbc.properties"/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="Driver" value="${driverClassName}"/>
<property name="Url" value="${url}"/>
<property name="Username" value="${username}"/>
<property name="Password" value="${password}"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/scott/emp.xml"/>
</sqlMapConfig>jdbc.properties内容如下
driverClassName = oracle.jdbc.driver.OracleDriver
url = jdbc:oracle:thin:@127.0.0.1:1521:orcl
username = scott
password = tiger
<property name="driverUrl" value="${url}"/>
<property name="user" value="${sername}"/>
<property name="password" value="${password}"/>-------换成这样写试试呢?
是不是还有其他属性没设置?
里面的各项属性 属性的name对么
里面的各项属性 属性的name对么 比如那个url
里面的各项属性 属性的name对么 比如那个url
SqlMap.properties 内容如下jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.password=icdrpt
jdbc.url=jdbc:oracle:thin:@10.32.145.210:1521:orcl
jdbc.username=icdrpt这是没有错的,这是原来可行的工程拷下来的
SqlMapConfig.xml 的内容如下
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd"><sqlMapConfig>
<properties resource="com/scott/SqlMap.properties"/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property value="${jdbc.driverClassName}" name="jdbc.driverClassName" />
<property value="${jdbc.url}" name="jdbc.url" />
<property value="${jdbc.username}" name="jdbc.username" />
<property value="${jdbc.password}" name="jdbc.password" />
</dataSource>
</transactionManager>
<sqlMap resource="com/scott/emp.xml"/>
</sqlMapConfig>
<dataSource type="SIMPLE">
<property name="JDBC.Driver"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
<property name="JDBC.Username" value="scott"/>
<property name="JDBC.Password" value="tiger"/>
<property name="JDBC.DefaultAutoCommit" value="false" />
<property name="Pool.MaximumActiveConnections" value="10" />
<property name="Pool.MaximumIdleConnections" value="5" />
<property name="Pool.MaximumCheckoutTime" value="20000" />
<property name="Pool.TimeToWait" value="20000" />
<property name="Pool.PingConnectionsOlderThan" value="0" />
<property name="Pool.PingConnectionsNotUsedFor" value="0" />
</dataSource>
</transactionManager>