＜ResourceParams name="jdbc/TestDB"＞ ＜parameter＞ ＜name＞factory＜/name＞ ＜value＞org.apache.commons.dbcp.BasicDataSourceFactory＜/value＞ ＜/parameter＞ ＜!-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. --＞ ＜parameter＞ ＜name＞maxActive＜/name＞ ＜value＞100＜/value＞ ＜/parameter＞ ＜!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. --＞ ＜parameter＞ ＜name＞maxIdle＜/name＞ ＜value＞30＜/value＞ ＜/parameter＞ ＜!-- Maximum time to wait for a dB connection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. --＞ ＜parameter＞ ＜name＞maxWait＜/name＞ ＜value＞10000＜/value＞ ＜/parameter＞ ＜!-- MySQL dB username and password for dB connections --＞ ＜parameter＞ ＜name＞username＜/name＞ ＜value＞sa＜/value＞ ＜/parameter＞ ＜parameter＞ ＜name＞password＜/name＞ ＜value＞topcomputer＜/value＞ ＜/parameter＞ ＜!-- Class name for mm.mysql JDBC driver --＞ ＜parameter＞ ＜name＞driverClassName＜/name＞ ＜value＞com.microsoft.jdbc.sqlserver.SQLServerDriver＜/value＞ ＜/parameter＞ ＜!-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. --＞ ＜parameter＞ ＜name＞url＜/name＞ ＜value＞jdbc:microsoft:sqlserver://nt04:1433;DatabaseName=test＜/value＞ ＜/parameter＞ ＜/ResourceParams＞ ＜/Context＞ ＜/Host＞ ＜/Engine＞ ＜/Service＞ ＜/Server＞
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[testdata]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[testdata] GO
CREATE TABLE [dbo].[testdata] ( [id] [int] NOT NULL , [foo] [varchar] (50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL , [bar] [int] NOT NULL ) ON [PRIMARY]
＜Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"/＞ ＜ResourceParams name="jdbc/TestDB"＞ ＜parameter＞ ＜name＞factory＜/name＞ ＜value＞org.apache.commons.dbcp.BasicDataSourceFactory＜/value＞ ＜/parameter＞ ＜!-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. --＞ ＜parameter＞ ＜name＞maxActive＜/name＞ ＜value＞100＜/value＞ ＜/parameter＞ ＜!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. --＞ ＜parameter＞ ＜name＞maxIdle＜/name＞ ＜value＞30＜/value＞ ＜/parameter＞ ＜!-- Maximum time to wait for a dB connection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. --＞ ＜parameter＞ ＜name＞maxWait＜/name＞ ＜value＞10000＜/value＞ ＜/parameter＞ ＜!-- MySQL dB username and password for dB connections --＞ ＜parameter＞ ＜name＞username＜/name＞ ＜value＞sa＜/value＞ ＜/parameter＞ ＜parameter＞ ＜name＞password＜/name＞ ＜value＞topcomputer＜/value＞ ＜/parameter＞ ＜!-- Class name for mm.mysql JDBC driver --＞ ＜parameter＞ ＜name＞driverClassName＜/name＞ ＜value＞com.microsoft.jdbc.sqlserver.SQLServerDriver＜/value＞ ＜/parameter＞ ＜!-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. --＞ ＜parameter＞ ＜name＞url＜/name＞ ＜value＞jdbc:microsoft:sqlserver://nt04:1433;DatabaseName=test＜/value＞ ＜/parameter＞ ＜/ResourceParams＞ ＜/Context＞
