毒毒√快闪
发贴: 9
积分: 0
|
于 2007-12-19 04:33
<!--proxool.xml-->
<?xml version="1.0" encoding="UTF-8"?> <!-- the proxool configuration can be embedded within your own application's. Anything outside the "proxool" tag is ignored. --> <something-else-entirely> <proxool> <alias>conn1</alias> <driver-url>jdbc:mysql://localhost:3306/myContent</driver-url> <driver-class>org.gjt.mm.mysql.Driver</driver-class> <driver-properties> <property name="user" value="HaoLing"/> <property name="password" value="HL"/> </driver-properties> <statistics>1m,15m,1d</statistics> <maximum-connection-count>100</maximum-connection-count> <minimum-connection-count>25</minimum-connection-count> <maximum-active-time>60000</maximum-active-time> <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql> </proxool> </something-else-entirely> ================================================================================= <!---web.xml->
<!--使用proxool--> <servlet> <servlet-name>ServletConfigurator</servlet-name> <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class> <init-param> <param-name>xmlFile</param-name> <param-value>WEB-INF/proxool.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <!--使用proxool查看数据库的运行状态--> <servlet> <servlet-name>proxool</servlet-name> <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>proxool</servlet-name> <url-pattern>/proxool</url-pattern> </servlet-mapping> </web-app> ================================================================================= <!--GdDbConnection.java-->
/* * 该方法用来获取数据库连接 * @see com.myContent.jdbc.DbConnection#getConnection(java.lang.Object) */ public Connection getConnection(Object obj) throws SQLException, ClassNotFoundException { try{ if(this.objId == obj && this.conn != null && !isClosed()){ System.out.println("*********************连接数据成***!*********************"); return conn; } else{ Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); conn = DriverManager.getConnection("proxool.conn1"); System.out.println("*********************连接数据成***!*********************"); } }catch(SQLException e){ throw new SQLException("获取数据库连接失败" + obj.getClass().getName() + e); }catch(Exception e){ System.out.println("GdDbConnection class:getConnection(Object obj) method ERROR--: "+e); } return conn; } ================================================================================= 请问这下面的写法有错嘛?? Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); conn = DriverManager.getConnection("proxool.conn1"); 为什么老报 别名错误啊。我的。proxool.xml 里声明的和这里的别名一样啊。我实在找不到原因了。 去掉Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");这句话也不对。
我使用原始的方法: Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); conn = DriverManager.getConnection
("proxool.gd:com.mysql.jdbc.Driver:jdbc:mysql://localhost:3306/myContent","HaoLing","HL"); 这样写的话。数据库连接就是正常的。为什么用上面的方法写。就不对啊。
郁闷啊。请教下高人。谢谢~~~~~~~~~~~~~~~~~~
|