java.sql.SQLException: Error executing query

最新推荐文章于 2026-04-22 12:58:33 发布

原创最新推荐文章于 2026-04-22 12:58:33 发布 · 4.7k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

java 专栏收录该内容

17 篇文章

订阅专栏

这篇博客主要介绍了如何解决遇到的`java.sql.SQLException: Error executing query`问题。作者建议，当常规方法无效时，检查hosts文件，确保没有设置错误的xx.xx.xx.com和10.10.10.100的映射，移除即可解决此异常。

1、具体报错信息

Exception in thread "main" java.sql.SQLException: Error executing query
	at io.prestosql.jdbc.PrestoStatement.internalExecute(PrestoStatement.java:284)
	at io.prestosql.jdbc.PrestoStatement.execute(PrestoStatement.java:229)
	at io.prestosql.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:78)
	at DriverTest.main(DriverTest.java:22)
Caused by: java.io.UncheckedIOException: java.net.ConnectException: Failed to connect to xxx.xxx.com/10.10.10.100:28050
	at io.prestosql.jdbc.$internal.client.JsonResponse.execute(JsonResponse.java:154)
	at io.prestosql.jdbc.$internal.client.StatementClientV1.<init>(StatementClientV1.java:132)
	at io.prestosql.jdbc.$internal.client.StatementClientFactory.newStatementClient(StatementClientFactory.java:24)
	at io.prestosql.jdbc.QueryExecutor.startQuery(QueryExecutor.java:46)
	at io.prestosql.jdbc.PrestoConnection.startQuery(PrestoConnection.java:714)
	at io.prestosql.jdbc.PrestoStatement.internalExecute(PrestoStatement.java:241)
	... 3 more
Caused by: java.net.ConnectException: Failed to connect to xxx.xxx.com/10.10.10.100:28050
	at io.prestosql.jdbc.$internal.okhttp3.internal.connection.RealConnection.connectSocket(RealConnection.java:240)
	at io.prestosql.jdbc.$internal.okhttp3.internal.connection.RealConnection.connect(RealConnection.java:158)
	at io.prestosql.jdbc.$internal.okhttp3.internal.connection.StreamAllocation.findConnection(StreamAllocation.java:256)
	at io.prestosql.jdbc.$internal.okhttp3.internal.connection.StreamAllocation.findHealthyConnection(StreamAllocation.java:134)
	at io.prestosql.jdbc.$internal.okhttp3.internal.connection.StreamAllocation.newStream(StreamAllocation.java:113)
	at io.prestosql.jdbc.$internal.okhttp3.internal.connection.ConnectInterceptor.intercept(ConnectInterceptor.java:42)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:147)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:121)
	at io.prestosql.jdbc.$internal.okhttp3.internal.cache.CacheInterceptor.intercept(CacheInterceptor.java:93)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:147)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:121)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.BridgeInterceptor.intercept(BridgeInterceptor.java:93)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:147)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RetryAndFollowUpInterceptor.intercept(RetryAndFollowUpInterceptor.java:125)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:147)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:121)
	at io.prestosql.jdbc.$internal.client.OkHttpUtil.lambda$userAgent$0(OkHttpUtil.java:77)
	at io.prestosql.jdbc.$internal.client.OkHttpUtil$$Lambda$1/610998173.intercept(Unknown Source)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:147)
	at io.prestosql.jdbc.$internal.okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:121)
	at io.prestosql.jdbc.$internal.okhttp3.RealCall.getResponseWithInterceptorChain(RealCall.java:200)
	at io.prestosql.jdbc.$internal.okhttp3.RealCall.execute(RealCall.java:77)
	at io.prestosql.jdbc.$internal.client.JsonResponse.execute(JsonResponse.java:131)
	... 8 more
Caused by: java.net.ConnectException: Connection refused: no further information
	at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
	at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:716)
	at sun.nio.ch.SocketAdaptor.connect(SocketAdaptor.java:111)
	at io.prestosql.jdbc.$internal.okhttp3.internal.platform.Platform.connectSocket(Platform.java:125)
	at io.prestosql.jdbc.$internal.okhttp3.internal.connection.RealConnection.connectSocket(RealConnection.java:238)
	... 30 more

2、如果是尝试了其他办法还没有解决可以看下hosts文件中是不是加了 xx.xx.xx.com 和10.10.10.100的映射关系去掉就可以了