context.xml－PhilChen的學習筆記

tomcat 之 context.xml 針對 SQLServer 與 MySQL 的 DataSource 設定 (放在META-INF資料夾下)

------------------------------------------

<?xml version='1.0' encoding='utf-8'?>
<Context displayName="MyTest Web Application" docBase="MyTest" path="/MyTest"
    reloadable="true">
    <!-- MySQL -->
    <Resource name="jdbc/MySQL" type="javax.sql.DataSource"
    username="username" password="password"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://127.0.0.1:3306/jspdb"
    connectionProperties="useUnicode=yes;characterEncoding=utf8;"
    maxActive="8"
    maxIdle="4"
    maxWait="5000" />
    <!-- SQLServer -->
    <Resource name="jdbc/SQLServer" type="javax.sql.DataSource"
    username="username" password="password"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jspdb" 
maxActive="8"
maxIdle="4"
maxWait="5000" />
</Context>