做web应用的在客户现场经常碰到这样的拓扑结构:
这是一种典型的环境搭建模式.
这是我有一种需求,需要在客户端CLIENT1机器上做一个客户端小应用程序,这个程序需要访问数据库(DB SERVER),
这里我是用Ibatis实现的数据访问层,其访问数据库的方式有下面两种:
一.直连数据库(jdbc)
SqlMapConfig.xml:
<?
xml version="1.0" encoding="UTF-8"
?>
<! DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd" >
< sqlMapConfig >
< properties resource ="SqlMapConfig.properties" />
< settings
cacheModelsEnabled ="true"
enhancementEnabled ="false"
lazyLoadingEnabled ="true"
maxRequests ="20"
maxSessions ="10"
maxTransactions ="15"
useStatementNamespaces ="false" />
< transactionManager type ="JDBC" >
< dataSource type ="SIMPLE" >
< property name ="JDBC.Driver" value ="${driver}" />
< property name ="JDBC.ConnectionURL" value ="${url}" />
< property name ="JDBC.Username" value ="${username}" />
<
<! DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd" >
< sqlMapConfig >
< properties resource ="SqlMapConfig.properties" />
< settings
cacheModelsEnabled ="true"
enhancementEnabled ="false"
lazyLoadingEnabled ="true"
maxRequests ="20"
maxSessions ="10"
maxTransactions ="15"
useStatementNamespaces ="false" />
< transactionManager type ="JDBC" >
< dataSource type ="SIMPLE" >
< property name ="JDBC.Driver" value ="${driver}" />
< property name ="JDBC.ConnectionURL" value ="${url}" />
< property name ="JDBC.Username" value ="${username}" />
<