下面是我的使用步骤和eclipse报的异常(偶写的是一个java左面程序):
1,下载proxool包,把proxool-0.9.1.jar和proxool-cglib.jar拷贝到了程序的lib文件夹中,并且在项目的构建路径中加上了这两个包
2,下面是写的一个小例子的调用连接池的代码
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
Properties info = new Properties();
info.setProperty("proxool.maximum-connection-count", "10");
info.setProperty("proxool.house-keeping-test-sql", "select CURRENT_DATE");
info.setProperty("user", "sa");
info.setProperty("password", "sa");
String alias = "pool";
String driverClass = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String driverUrl = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=test";
String url = "proxool." + alias + ":" + driverClass + ":" + driverUrl;
ProxoolFacade.registerConnectionPool(url, info);
但奇怪的是总是报:
Exception in thread "main" java.lang.NoClassDefFoundError: org.apache.commons.logging.LogFactory
at org.logicalcobwebs.proxool.ProxoolDriver.<clinit>(ProxoolDriver.java:28)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
at java.lang.Class.forNameImpl(Native Method)
at java.lang.Class.forName(Class.java:136)
at com.boss.JdbcDemo.main(JdbcDemo.java:19)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory
at java.net.URLClassLoader.findClass(URLClassLoader.java:419)
at java.lang.ClassLoader.loadClass(ClassLoader.java:643)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:345)
at java.lang.ClassLoader.loadClass(ClassLoader.java:609)
... 6 more
这是为什么呢??ProxoolDriver明明就存在