eclipse 连接 sqlserver ping failed

最新推荐文章于 2019-09-15 17:46:21 发布
原创 最新推荐文章于 2019-09-15 17:46:21 发布 · 4k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#sqlserver

本文探讨了在使用SQL JDBC驱动程序时遇到的常见问题：选择不正确的jar文件导致连接失败。通过对比sqljdbc.jar, sqljdbc4.jar, sqljdbc41.jar的不同用途，最终成功使用sqljdbc41.jar建立连接。了解如何正确选择和配置JDBC驱动对于提高应用程序的稳定性和性能至关重要。

这里写图片描述

后来发现是jdbc的jar文件选择不正确

jar
sqljdbc.jar
sqljdbc4.jar
sqljdbc41.jar

具体选择哪个可以参考JDBC 驱动程序的系统要求

使用sqljdbc41.jar，连接成功！
这里写图片描述

驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。错误:“SQL Server 未返回响应。连接已关闭
qq_35553465的博客
08-31 4391
环境：WIN10 + JDK1.8 + SQLSERVER2008 R2 起因：在做一个公司项目的时候，有一套数据库是在虚拟机里的，虚拟机的环境是win2003 + sqlserver 2008 R2 项目用的框架是spring boot 2.1.7 + jpa , jdbc 用的是微软的com.microsoft.sqlserver （为什么不怀疑是编译器的问题呢，因为我之前在e...
Linux常见服务与云原生运维常见服务报错与解决方案
PS : 文章如果是VIP可见可以私信我打开，因为文章会自动升级为VIP文章...... 作者声明: 所有的技术分享均为免费开放！
03-18 1727
日均处理日志量可达TB级。如果使用的是私有仓库，确保 Kubernetes 配置了正确的凭证（通过 Kubernetes Secret 或 Docker Config）。在 GitLab CI/CD 流水线中，推送镜像到 Docker registry 时，可能会遇到认证失败或推送超时的问题。优化 Dockerfile，避免频繁无变化的步骤，比如将频繁变化的命令移至 Dockerfile 的后面。确保 Dockerfile 中的路径、文件名和基础镜像都正确，并且必要的环境变量已正确配置。
eclipse配置连接mysql出现ping failed
种一棵树最好的时间是十年前，其次是现在。
03-11 6229
记录下自己在配置的过程中出现的问题。配置好之后的样子是这样的： 我遇到的第1个问题是，由于eclipse版本的问题，缺少database插件，导致试图里面没有DataSource的选项，后来装完database插件之后还是失败，于是果断换了eclipse EE版本的，结果又遇到新的问题了。。。。 当我右键点击”Database Connections”->new一个连接时，在指定连接...
Eclipse 通过Database Connections连接ORACLE 数据库时，一直报 ping failed 解决办法
qq_26602277的博客
09-15 1565
你能看到这篇解决办法的话，可能是别的文章还没有解决你的问题。首先，你先确定是否你所有配置都完全正确，且没有拼写错误的问题。可以试试我的办法。 如果你反复的 “db”或者 “xe”都还是没法解决问题的话。那应该试试 SID了。 查看你的SID 1、win+R打开cmd 2、输入sqlplus / as sysdba以dba的方式进入数据库 3、输入show parameter ...
有关“ping不通”的解释
In my dream
11-17 9152
ping命令常用在测试本机与网络其他主机i
得到SQL服务器的IP地址(来自优快云邹建)
laihua的专栏
11-19 1653
create table #tb(o varchar(250))declare @sql varchar(500)set @sql=ping +@@servernameinsert into #tb exec master..xp_cmdshell @sqlselect @sql=o from #tb where o like Pinging%select @sql=substring
sql sever 连接eclipse
最新发布
10-29
1. **JDBC连接机制**：通过`jdbc:sqlserver://host:port;databaseName=xxx`格式建立通信链路。 2. **驱动加载规范**：必须将`mssql-jdbc.jar`放入项目类路径（`WEB-INF/lib`或Build Path）。 3. **SQL Server配置...
请求的方法为:login SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.gxa.controller.BaseController.service(BaseController.java:79) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:835) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1685) at com.gxa.filter.TransactionFilter.doFilter(TransactionFilter.java:24) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.CORSFilter.doFilter(CORSFilter.java:34) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.AuthenFilter.doFilter(AuthenFilter.java:62) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.AuthenFilter.doFilter(AuthenFilter.java:62) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.CORSFilter.doFilter(CORSFilter.java:34) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:38) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1158) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1090) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:119) at org.eclipse.jetty.server.Server.handle(Server.java:517) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:242) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:75) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:213) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:147) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: null, message from server: "Host 'brynn' is not allowed to connect to this MySQL server" ### The error may exist in com/gxa/mapper/UserMapper.xml ### The error may involve com.gxa.mapper.UserMapper.getByUsername ### The error occurred while executing a query ### Cause: java.sql.SQLException: null, message from server: "Host 'brynn' is not allowed to connect to this MySQL server" at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52) at jdk.proxy4/jdk.proxy4.$Proxy29.getByUsername(Unknown Source) at com.gxa.service.impl.UserServiceImpl.login(UserServiceImpl.java:26) at com.gxa.controller.UserController.login(UserController.java:30) ... 43 more Caused by: java.sql.SQLException: null, message from server: "Host 'brynn' is not allowed to connect to this MySQL server" at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:195) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:190) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:92) at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:375) at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:84) at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:134) at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61) at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:72) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108) ... 50 more java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.gxa.controller.BaseController.service(BaseController.java:79) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:835) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1685) at com.gxa.filter.TransactionFilter.doFilter(TransactionFilter.java:24) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.CORSFilter.doFilter(CORSFilter.java:34) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.AuthenFilter.doFilter(AuthenFilter.java:62) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.AuthenFilter.doFilter(AuthenFilter.java:62) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.CORSFilter.doFilter(CORSFilter.java:34) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at com.gxa.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:38) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1158) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1090) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:119) at org.eclipse.jetty.server.Server.handle(Server.java:517) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:242) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:75) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:213) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:147) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: null, message from server: "Host 'brynn' is not allowed to connect to this MySQL server" ### The error may exist in com/gxa/mapper/UserMapper.xml ### The error may involve com.gxa.mapper.UserMapper.getByUsername ### The error occurred while executing a query ### Cause: java.sql.SQLException: null, message from server: "Host 'brynn' is not allowed to connect to this MySQL server" at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52) at jdk.proxy4/jdk.proxy4.$Proxy29.getByUsername(Unknown Source) at com.gxa.service.impl.UserServiceImpl.login(UserServiceImpl.java:26) at com.gxa.controller.UserController.login(UserController.java:30) ... 43 more Caused by: java.sql.SQLException: null, message from server: "Host 'brynn' is not allowed to connect to this MySQL server" at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:195) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:190) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:92) at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:375) at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:84) at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:134) at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61) at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:72) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108) ... 50 more 请求的方法为:login请求的方法为:login ...提交事务... ...提交事务...
09-24
`Host 'brynn' is not allowed to connect to this MySQL server` 错误表明 MySQL 服务器拒绝了来自主机 `brynn` 的连接请求。这通常是由于 MySQL 的权限配置问题导致的。以下是几种可能的解决方法： ### 1. 授予...
ESP32连接阿里云IoT平台：掌握MQTT协议的5个关键实践步骤
ESP32与阿里云IoT平台的连接概述 在物联网系统中，ESP32作为高性价比、集成Wi-Fi/蓝牙的微控制器，广泛应用于智能设备的数据采集与通信场景。本章将介绍如何将其接入阿里云IoT平台，实现安全可靠的云端互联。 ...
ICMPPING failed
开阔的生命
01-27 2101
Zabbix uses external utility fping for processing of ICMP pings.
eclipse连接MySQL出现的错误
weixin_41097181的博客
05-31 2638
我是一个初学者，当用eclipse连接MySQL时，在eclipse中写入数据，出现java.sql.SQLException: Column count doesn't match value count at row 1；一开始百度都说写的格式与MySQL的列不一样，最后发现时创建的表的格式与写入的数据格式不相同，例如我开始的表的格式是varchar(20),varchar(20),但是我写入...
mysql_ping 阻塞问题
Kevin的专栏
08-09 8716
在日常开发过程中，为了解决Mysql has gone away问题使用了函数mysql_ping进行数据库的重连，不过在使用中发现mysql_ping有可能会永远阻塞，测试如下： 首先建立好数据库连接，然后sleep（20），在20秒内添加iptables规则，如下： iptables -A INPUT -p tcp --dport 3306 -jDROP 20秒后使用mysql_pi
从零开始配置MySQL MMM (续)——32bit CentOS 5上遇到的一些问题
suoyihen
12-29 193
在上一篇《从零开始配置MySQL MMM》中，在64bit的RHEL6中安装和配置MySQL-mmm。这两天又拿到了一个全32bit的CentOS 5，在配置过程中有遇到了一些其他问题。 一、依赖问题 因为这个环境中无法通过yum直接安装mysql-mmm，所以只有通过下载安装文件进行安装。而在安装mmm之前，需要安装其所依赖的库文件。为了方便起见，并没有对monitor和database...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值