proxool抛出异常? Couldn't load property file Proxool.properties
导常说不能加载Proxool.properties
可这个文件我明明有写放在WEB-INF/classes下面,而WEB-INF/下也放过,均不能加载,我不知还有什么地方要设置
安很多资料说放在WEB-INF/classes下面,可就是不能加载,是为什么呀!
org.logicalcobwebs.proxool.ProxoolException: Couldn't load property file Proxool.properties
at org.logicalcobwebs.proxool.configuration.PropertyConfigurator.configure(PropertyConfigurator.java:97)
at hibernate.connDB.getConnection(connDB.java:22)
at hibernate.connDB.main(connDB.java:56)
+++++++++++++++++++++++++++++++++++++++++++++++
测试原码
///////////////////////////////////////////////////
package hibernate;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import org.logicalcobwebs.proxool.ProxoolException;
//import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;
import org.logicalcobwebs.proxool.configuration.PropertyConfigurator;
public class connDB {
private static Connection conn=null;
private static Statement stmt=null;
connDB(){}
public static Connection getConnection(){
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
PropertyConfigurator.configure("Proxool.properties");
conn = DriverManager.getConnection("proxool.test");
/*
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
JAXPConfigurator.configure("proxool.xml", false);
conn = DriverManager.getConnection("proxool.test");
*/
/*
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
Properties info = new Properties();
info.setProperty("proxool.maximum-connection-count", "20");
info.setProperty("proxool.house-keeping-test-sql", "select CURRENT_DATE");
info.setProperty("user", "root");
info.setProperty("password", "111111");
conn = DriverManager.getConnection("proxool.example:org.gjt.mm.mysql.Driver:jdbc:mysql://localhost:3306/weekday", info);
*/
/*
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/weekday","root","111111");
*/
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ProxoolException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void main(String[] args){
System.out.println("haha");
try{
conn=getConnection();
stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from board");
while(rs.next()){
System.out.println(rs.getString("title"));
}
}catch (Exception e ){}
}
}
/////////////////////////////////////////////////////////