＜ResourceParams name="jdbc/TestDB"＞ ＜parameter＞ ?。糿ame＞factory＜/name＞ ?。紇alue＞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＞ ?。糿ame＞maxActive＜/name＞ ?。紇alue＞100＜/value＞ ?。?parameter＞ ＜!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. --＞ ?。紁arameter＞ ?。糿ame＞maxIdle＜/name＞ ?。紇alue＞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. --＞ ?。紁arameter＞ ?。糿ame＞maxWait＜/name＞ ?。紇alue＞10000＜/value＞ ＜/parameter＞ ＜!-- MySQL dB username and password for dB connections --＞ ?。紁arameter＞ ＜name＞username＜/name＞ ?。紇alue＞sa＜/value＞ ?。?parameter＞ ＜parameter＞ ?。糿ame＞password＜/name＞ ＜value＞topcomputer＜/value＞ ?。?parameter＞ ?。?-- Class name for mm.mysql JDBC driver --＞ ?。紁arameter＞ ?。糿ame＞driverClassName＜/name＞ ?。紇alue＞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. --＞ ?。紁arameter＞ ?。糿ame＞url＜/name＞ ?。紇alue＞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]
?。糝esource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"/＞ ?。糝esourceParams name="jdbc/TestDB"＞ ＜parameter＞ ＜name＞factory＜/name＞ ?。紇alue＞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. --＞ ?。紁arameter＞ ?。糿ame＞maxActive＜/name＞ ?。紇alue＞100＜/value＞ ＜/parameter＞ ＜!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. --＞ ＜parameter＞ ＜name＞maxIdle＜/name＞ ?。紇alue＞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. --＞ ?。紁arameter＞ ＜name＞maxWait＜/name＞ ?。紇alue＞10000＜/value＞ ?。?parameter＞ ?。?-- MySQL dB username and password for dB connections --＞ ?。紁arameter＞ ?。糿ame＞username＜/name＞ ＜value＞sa＜/value＞ ?。?parameter＞ ?。紁arameter＞ ＜name＞password＜/name＞ ?。紇alue＞topcomputer＜/value＞ ＜/parameter＞ ＜!-- Class name for mm.mysql JDBC driver --＞ ＜parameter＞ ＜name＞driverClassName＜/name＞ ?。紇alue＞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. --＞ ?。紁arameter＞ ＜name＞url＜/name＞ ?。紇alue＞jdbc:microsoft:sqlserver://nt04:1433;DatabaseName=test＜/value＞ ?。?parameter＞ ?。?ResourceParams＞ ?。?Context＞
