java sql server ssl_java – JDBC(JTDS)SSL身份验证后SQL Server连接已关闭

使用jTDS JDBC驱动连接到SQL Server 2008时,启用SSL后遇到连接关闭的问题。尽管身份验证成功,但在尝试执行查询时连接立即断开。错误日志显示收到EOFException,并提示'DB server closed connection'。问题可能与SSL配置或驱动兼容性有关。
摘要由CSDN通过智能技术生成

我使用jTDS JDBC SQLServer库连接到SQL Server 2008数据库.它总是在没有SSL的情况下工作,但是一旦我们启用它,我就无法连接它.我已经跟踪了

Java,如下所示并检查了数据库端的日志,并且身份验证正常工作,但在尝试执行查询时立即断开连接.谁见过这个问题?

main, received EOFException: ignored

main, called closeInternal(false)

main, SEND TLSv1 ALERT: warning, description = close_notify

Padded plaintext before ENCRYPTION: len = 32

0000: 01 00 DF 4A F1 23 CF E7 6B 62 3D 7D 4D CD C9 AD ...J.#..kb=.M...

0010: 26 7B 16 59 84 9A 09 09 09 09 09 09 09 09 09 09 &..Y............

main, WRITE: TLSv1 Alert, length = 32

[Raw write]: length = 37

0000: 15 03 01 00 20 12 0A 45 80 96 80 F8 04 62 2F 62 .... ..E.....b/b

0010: E0 35 B9 4D 67 B0 4D D7 AC 9C CF C7 57 CA E1 B2 .5.Mg.M.....W...

0020: 9F DC BA 5E F8 ...^.

main, called closeSocket(selfInitiated)

main, called close()

main, called closeInternal(true)

java.sql.SQLException: I/O Error: DB server closed connection.

at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1053)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:465)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:390)

at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

at java.sql.DriverManager.getConnection(DriverManager.java:579)

at java.sql.DriverManager.getConnection(DriverManager.java:221)

at getConnection.main(getConnection.java:25)

Caused by: java.io.IOException: DB server closed connection.

at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:848)

at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:727)

at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)

at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)

at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)

at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3932)

at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1046)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值