Java开发网 |
注册 |
登录 |
帮助 |
搜索 |
排行榜 |
发帖统计
|
您没有登录 |
» Java开发网 » Database/JDBC/SQL/JDO/Hibernate
» MS SQL
打印话题 寄给朋友 订阅主题 |
作者 | 关于在MYECLIPSE+TOMCAT用proxool配置MSSQL连接的问题 |
Barbarossa
发贴: 3 积分: 0 |
于 2006-09-16 02:28
使用的MSSQL驱动是JTDS的 好心人帮我看看啊 proxool.xml <?xml version="1.0" encoding="ISO-8859-1"?> <!-- the proxool configuration can be embedded within your own application's. Anything outside the "proxool" tag is ignored. --> <something-else-entirely> <proxool> <alias>MSSQLDS</alias> <driver-url>jdbc:jtds:sqlserver://localhost:1433/BBS</driver-url> <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class> <driver-properties> <property name="user" value="sa"/> <property name="password" value="sa"/> </driver-properties> <maximum-connection-count>100</maximum-connection-count> <minimum-connection-count>5</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> 应用 package cn.ossa.classes; import java.sql.*; import org.apache.log4j.*; public class dbConnection { private Connection conn=null; Logger log = Logger.getLogger("dbConnection"); public Connection getConnection() { try { Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); log.info("Class正确"); conn = DriverManager.getConnection("proxool.MSSQLDS"); log.debug("数据库连接成功"); System.out.print("数据库连接成功"); } catch(Exception ex) { log.error("数据库连接异常:"+ex.toString()); System.out.print("数据库连接异常"); } if(conn==null) { log.error("连接无效..."); System.out.print("连接无效"); } return conn; } web.xml <?xml version="1.0" encoding="UTF-8"?> <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <servlet> <servlet-name>Admin</servlet-name> <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>Admin</servlet-name> <url-pattern>/admin</url-pattern> </servlet-mapping> </web-app> 当我http://127.0.0.1:8080/proxool/admin测试连接时,页面显示 No pools have been registered.
why edited on 2006-09-16 08:59
|
作者 | Re:关于在MYECLIPSE+TOMCAT用proxool配置MSSQL连接的问题 [Re:Barbarossa] |
Barbarossa
发贴: 3 积分: 0 |
于 2006-10-03 18:45
就没一个人知道? |
已读帖子 新的帖子 被删除的帖子 |
Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1 客服电话 18559299278 客服信箱 714923@qq.com 客服QQ 714923 |