给Log4j配上数据库连接池(3)

Connection conn = null;
try {
conn = plmn.connect("jdbc:poolman://" dbName);
conn.setAutoCommit(true);
} catch (Exception ec) {
System.out.println(ec.toString() "First:Connect sqlsever failed" module);
try {
Thread.sleep(1000);
conn = plmn.connect("jdbc:poolman://" dbName);
conn.setAutoCommit(true);
} catch (Exception ecs) {
System.out.println(ecs.toString() "Again:Connect sqlsever faile" module);
}
}
return conn;
}

public Connection getConnection() {
return getNewConnection();
}
}
GeneralDb.java:

package common.sql;

package common.sql;

import java.util.*;

public class GeneralDb {
private static Hashtable dbPool;
public static MyDB getInstance(String dbname) {
if (dbPool == null) {
dbPool = new Hashtable();
}
MyDB db = (MyDB) dbPool.get(dbname);
if (db == null) {
db = new MyDB(dbname);
dbPool.put(dbname, db);
}
return db;
}
}

Log4j数据库连接池的配置如下：
log4j.appender.JDBC=common.log.JDBCPoolAppender
log4j.appender.JDBC.sqlname=log
log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout
log4j.appender.JDBC.sql=INSERT INTO LOGGING (log_date, log_level, location, message) VALUES ('%d{ISO8601}', '%-5p', '%C,%L', '%m')


poolman.XML配置如下：
下一篇： 跟我学Java Swing之游戏设计(4)

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有