Tomcat Database Connection Pool Configuration is added to in Server.xml maxwait 10000 maxactive 100 password SWT URL jdbc: mysql: // localhost: 3306 / smsgroup? autoreconnect = true driverclassname Org.gjt.mm .MYSQL.DRIVER maxidle 30 Username SWT Add DB in Web.xml Connection jdbc / smsgroup javax.sql.datasource
container Connect and close Database Code PUBLIC VOID INITCONNECTION () {// Connection Pool Connection Database Try {Context CTX = New InitialContext (); DataSource Source = (Datasource) CTX.lookup ("Java: Comp / Env / JDBC / SMSGroup"); connection con = source.getConnection (); con = source.getConnection (); stmt = con.createstatement (); system. Out.println ("Database connection success!");} catch (exception e) {E.PrintStackTrace (); system.out.println ("Connection Database Failed!");}} Public void destroyConnection () {// Turn the database (connection pool) try {if (rs! = null) rs.close (); if (stmt! = null) stmt.close (); if (con! = null); system.out.println ("Database successfully closed!");} catch (exception e) {system.out.println ("Database Busy, press F5 Refresh!"); e .printStackTrace ();}} reference: 1, sql server drive Microsoft format url: jdbc: microsoft: sqlserver: // IP address: 1433; DatabaseName = driverClassName format default database name: com.microsoft.jdbc.sqlserver.SQLServerDriver2, Oracle Thin Drive URL Format: jdbc: oracle: thin: @IP address: 1521: instance name driverClassName format: oracle.jdbc.driver.OracleDriver3, MySql database url format: jdbc: mysql: // IP Address: 3306 / smsgroup autoReconnect = truedriverClassName format:? org. GJT.MM.MYSQL.DRIVER4, JDBC-ODBCURL format: JDBC: ODBC: DNS name driverclassname format: Sun.jdbc.odbc.jdbcodbcdriver
