sqlserver2000 远程连接报错connection validation failed for current managed connection.

好奇怪呀，有传统方式就可以连上，用druid就不行

jfinal错误2.png

jfinal错误1.png

//原来没有写配置现在补上

//配置一、

package com.mcdc.common.config;

import com.jfinal.config.Constants;

import com.jfinal.config.Handlers;

import com.jfinal.config.Interceptors;

import com.jfinal.config.JFinalConfig;

import com.jfinal.config.Plugins;

import com.jfinal.config.Routes;

import com.jfinal.core.JFinal;

import com.jfinal.kit.PropKit;

import com.jfinal.template.Engine;

import com.jfinal.plugin.druid.DruidPlugin;

import com.jfinal.plugin.activerecord.ActiveRecordPlugin;

import com.jfinal.plugin.activerecord.dialect.SqlServerDialect;

import com.jfinal.plugin.activerecord.CaseInsensitiveContainerFactory;

import com.jfinal.render.ViewType;

public class MainConfig extends JFinalConfig {

@Override

public void configConstant(Constants me) {

//读取数据库配置文件

PropKit.use("config.properties");

//设置当前是否为开发模式

me.setDevMode(PropKit.getBoolean("devMode"));

//设置默认上传文件保存路径 getFile等使用

me.setBaseUploadPath("upload/temp/");

//设置上传最大限制尺寸

//me.setMaxPostSize(1024*1024*10);

//设置默认下载文件路径 renderFile使用

me.setBaseDownloadPath("download");

//设置默认视图类型

me.setViewType(ViewType.JFINAL_TEMPLATE);

//me.setError404View("404.html");

}

@Override

public void configRoute(Routes me) {}

@Override

public void configPlugin(Plugins me) {

//配置数据库连接池插件

DruidPlugin dbPlugin=new DruidPlugin(PropKit.get("jdbcUrl"), PropKit.get("user"), PropKit.get("password"));

//orm映射配置ActiveRecord插件

ActiveRecordPlugin arp=new ActiveRecordPlugin(dbPlugin);

arp.setShowSql(PropKit.getBoolean("devMode"));

dbPlugin.setDriverClass("com.microsoft.jdbc.sqlserver.SQLServerDriver");

arp.setDialect(new SqlServerDialect());

arp.setContainerFactory(new CaseInsensitiveContainerFactory(true));

me.add(dbPlugin);

me.add(arp);

}

@Override

public void configInterceptor(Interceptors me) {}

@Override

public void configHandler(Handlers me) {}

@Override

public void configEngine(Engine me) {}

public static void main(String[] args) {JFinal.start("WebRoot", 8001, "/", 5);}

}

// 配置二、propity文件中内容（为了安全）没写用户名和密码，但是用户名和密码都是正确的

#database config

dbType=sqlserver

jdbcUrl=jdbc:microsoft:sqlserver://122.114.253.148:56890;DatabaseName=Agency

user = *****

password =******

devMode =true

//由于是slq server2000我又多加了3个jar包

另外三个jar包.png

//以下是控制台返回的结果

运行结果2.png

Starting JFinal 3.0

Starting scanner at interval of 5 seconds.

Starting web server on port: 8001

大概15秒后出现下面的内容

2017-03-20 12:55:14

[WARN]-[Thread: main]-[com.alibaba.druid.pool.vendor.MSSQLValidConnectionChecker.isValidConnection()]: warning: connection validation failed for current managed connection.

2017-03-20 12:55:14

[ERROR]-[Thread: main]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error

java.sql.SQLException: validateConnection false

at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1199)

at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1422)

at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:602)

at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:876)

at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:872)

at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:97)

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:38)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServer.doStart(JettyServer.java:131)

at com.jfinal.server.JettyServer.start(JettyServer.java:70)

at com.jfinal.core.JFinal.start(JFinal.java:159)

at com.mcdc.common.config.MainConfig.main(MainConfig.java:98)

2017-03-20 12:55:14

[ERROR]-[Thread: main]-[com.alibaba.druid.pool.DruidDataSource.init()]: dataSource init error