SQL Map XML配置檔案。

SQL Map使用XML配置檔案統一配置不同的屬性，包括DataSource的詳細配置資訊，SQL Map和其他可選屬性，如執行緒管理等。以下是SQL Map配置檔案的一個例子：

SqlMapConfig.xml

<?xml version ="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap Config PUBLIC "_//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">

<!-- Always ensure to use the correct XML headers as above!  -->

<sqlMapConfig>

<!-- The properties (name = value) in the file specified here can be used placeholders in this config file (e.g."${driver}". The file is relative to the classpath and is completely optional.) -->

<properties resource = "examples/sqlmap/maps/SqlMapConfigExample.properties" />

<!-- These settings control SqlMapClient configuration details, primarily to do with transaction management. They are all optional(more detail later in this document). -->

<settings

cacheModelsEnabled = "true"

enhancementEnabled = "true"

lazyLoadingEnabled = "true"

maxRequests = "32"

maxSessions = "10"

maxTransactions = "5"

useStatementNamespaces = "false"

/>

<!-- Type alias allow you to use a shorter name for long fully qualified class names. -->

<typeAlias alias = "order" type ="testdomain.Order" />

<!-- Configure a datasource to use with this SQL Map using SimpleDataSource. Notice the use of the properties from the above resource -->

<transactionManager type = "JDBC">

<dataSource type = "SIMPLE">

<property name = "JDBC.Driver" value ="${driver}" />

<property name = "JDBC.ConnectionURL" value = "${url}" />

<property name = "JDBC.Username" value ="${username}" />

<property name = "JDBC.Password" value = "${password}" />

<property name = "JDBC.DefaultAutoCommit" value = "true" />

<property name = "Pool.MaximumActiveConnections"  value ="10" />

<property name = "Pool.MaximumldleConnections" value = "5" />

<property name = "Pool.MaximumCheckoutTime" value = "120000" />

<property name = "Pool.TimeToWait" value = "500" />

<property name = "Pool.PingQuery" value = "select 1 from ACCOUNT" />

<property name = "Pool.PingEnabled" value = "false" />

<property name = "Pool.PingConnectionsOlderThan" value = "1" />

<property name = "Pool.PingConnectionsNotUsedFor" value = "1" />

</dataSource>

</transactionManager>

<!-- Identify all SQL Map XML files to be loaded by this SQL map. Notice the paths are relative to the classpath. For now,we only have one... -->

<sqlMap resource = "examples/sqlmap/maps/Person.xml"/>

</sqlMapConfig>

以下詳細討論SQL Map配置檔案的各組成部分。

<properties>元素

SQL Map配置檔案擁有唯一的<properties>元素，用於在配置檔案中使用標準的Java屬性檔案（name = value）。這樣做後，在屬性檔案中定義的屬性可以作為變數在SQL Map配置檔案及其包含的所有SQL Map對映檔案中引用。例如，如果屬性檔案中包含屬性：

driver = org.hsqldb.jdbcDriver

SQL Map配置檔案及其每個對映檔案都可以使用佔位符${driver}來代表值org.hsqldb.jdbcDriver。例如：

<property name = "JDBC.Driver" value = "${driver}" />

這個元素在開發，測試和部署各階段都很有用。他可以使在多個不同的環境重新配置應用和使用自動生成工具（如ANT）變得容易。屬性檔案可以從類路徑中載入（使用resource屬性），也可以從合法的URL中載入（使用url屬性）。例如，要載入固定路徑的屬性檔案，使用：

<properties url = "file:///c:/config/my.properties" />

<setting>元素

<setting>元素用於配置和優化SqlMapClient例項的各選項。<setting>元素本身及其所有的屬性都是可選的。以下列出了<setting>元素支援的屬性及其功能：

• maxRequests

• maxSessions

• maxTransactions

• cacheModelsEnabled

• lazyLoadingEnabled

• enhancementEnabled

• useStatementNamespaces