Java开发网 - 关于在MYECLIPSE+TOMCAT用proxool配置MSSQL连接的问题

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"?>

<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

话题树型展开

人气	标题	作者	字数	发贴时间
15129	关于在MYECLIPSE+TOMCAT用proxool配置MSSQL连接的问题	Barbarossa	2302	2006-09-16 02:28
12901	Re:关于在MYECLIPSE+TOMCAT用proxool配置MSSQL连接的问题	Barbarossa	8	2006-10-03 18:45

已读帖子

新的帖子

被删除的帖子