MSSQL connect with Instance

[hks2002]

How to connect the database, if it has Instance the jdbc-url is:
jdbc:sqlserver://localhost\mydb;DatabaseName=mydb;TrustServerCertificate=true;

[tsegismont]

Please check:

https://vertx.io/docs/vertx-mssql-client/java/#_configuration

And:

https://vertx.io/docs/vertx-mssql-client/java/#_using_ssltls

[hks2002]

Bellow is the error message: this host can't with Instance

java.net.UnknownHostException: Failed to resolve '192.168.10.60\\x3v12' [A(1)] after 2 queries 
	at io.netty.resolver.dns.DnsResolveContext.finishResolve(DnsResolveContext.java:1137) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsResolveContext.java:1137
	at io.netty.resolver.dns.DnsResolveContext.tryToFinishResolve(DnsResolveContext.java:1084) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsResolveContext.java:1084
	at io.netty.resolver.dns.DnsResolveContext.query(DnsResolveContext.java:443) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsResolveContext.java:443
	at io.netty.resolver.dns.DnsResolveContext.onResponse(DnsResolveContext.java:673) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsResolveContext.java:673
	at io.netty.resolver.dns.DnsResolveContext.access$500(DnsResolveContext.java:69) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsResolveContext.java:69
	at io.netty.resolver.dns.DnsResolveContext$2.operationComplete(DnsResolveContext.java:501) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsResolveContext.java:501
	at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:603) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
DefaultPromise.java:603
	at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:596) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
DefaultPromise.java:596
	at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:572) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
DefaultPromise.java:572
	at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:505) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
DefaultPromise.java:505
	at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:649) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
DefaultPromise.java:649
	at io.netty.util.concurrent.DefaultPromise.setSuccess0(DefaultPromise.java:638) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
DefaultPromise.java:638
	at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:118) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
DefaultPromise.java:118
	at io.netty.resolver.dns.DnsQueryContext.trySuccess(DnsQueryContext.java:308) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsQueryContext.java:308
	at io.netty.resolver.dns.DnsQueryContext.finishSuccess(DnsQueryContext.java:299) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsQueryContext.java:299
	at io.netty.resolver.dns.DnsNameResolver$DnsResponseHandler.channelRead(DnsNameResolver.java:1512) ~[netty-resolver-dns-4.2.1.Final.jar:4.2.1.Final]
DnsNameResolver.java:1512
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:359) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
AbstractChannelHandlerContext.java:359
	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:107) ~[netty-codec-base-4.2.1.Final.jar:4.2.1.Final]
MessageToMessageDecoder.java:107
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:359) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
AbstractChannelHandlerContext.java:359
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1429) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
DefaultChannelPipeline.java:1429
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:918) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
DefaultChannelPipeline.java:918
	at io.netty.channel.nio.AbstractNioMessageChannel$NioMessageUnsafe.read(AbstractNioMessageChannel.java:100) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
AbstractNioMessageChannel.java:100
	at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.handle(AbstractNioChannel.java:445) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
AbstractNioChannel.java:445
	at io.netty.channel.nio.NioIoHandler$DefaultNioRegistration.handle(NioIoHandler.java:383) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:383
	at io.netty.channel.nio.NioIoHandler.processSelectedKey(NioIoHandler.java:577) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:577
	at io.netty.channel.nio.NioIoHandler.processSelectedKeysOptimized(NioIoHandler.java:552) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:552
	at io.netty.channel.nio.NioIoHandler.processSelectedKeys(NioIoHandler.java:493) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:493
	at io.netty.channel.nio.NioIoHandler.run(NioIoHandler.java:470) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:470
	at io.netty.channel.SingleThreadIoEventLoop.runIo(SingleThreadIoEventLoop.java:204) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
	at io.netty.channel.SingleThreadIoEventLoop.run(SingleThreadIoEventLoop.java:175) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
SingleThreadIoEventLoop.java:175
	at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:1073) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
SingleThreadEventExecutor.java:1073
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
ThreadExecutorMap.java:74
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
FastThreadLocalRunnable.java:30
	at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]

if not set Instance, here is the error message:

17:55:22.718 [INFO ] [com.da.docs.VertxApp] No args, use default Verticle: com.da.docs.TestVerticle
17:55:25.957 [INFO ] [com.da.docs.TestVerticle] Failure: Connection refused: getsockopt: /192.168.10.60:1433
17:55:25.965 [ERROR] [io.vertx.launcher.application.VertxApplication] Failed in deploying verticle
io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: getsockopt: /192.168.10.60:1433
Caused by: java.net.ConnectException: Connection refused: getsockopt
	at java.base/sun.nio.ch.Net.pollConnect(Native Method) ~[?:?]
	at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682) ~[?:?]
Net.java:682
	at java.base/sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:973) ~[?:?]
SocketChannelImpl.java:973
	at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:330) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioSocketChannel.java:330
	at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:384) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
AbstractNioChannel.java:384
	at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.handle(AbstractNioChannel.java:432) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
AbstractNioChannel.java:432
	at io.netty.channel.nio.NioIoHandler$DefaultNioRegistration.handle(NioIoHandler.java:383) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:383
	at io.netty.channel.nio.NioIoHandler.processSelectedKey(NioIoHandler.java:577) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:577
	at io.netty.channel.nio.NioIoHandler.processSelectedKeysOptimized(NioIoHandler.java:552) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:552
	at io.netty.channel.nio.NioIoHandler.processSelectedKeys(NioIoHandler.java:493) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:493
	at io.netty.channel.nio.NioIoHandler.run(NioIoHandler.java:470) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
NioIoHandler.java:470
	at io.netty.channel.SingleThreadIoEventLoop.runIo(SingleThreadIoEventLoop.java:204) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
SingleThreadIoEventLoop.java:204
	at io.netty.channel.SingleThreadIoEventLoop.run(SingleThreadIoEventLoop.java:175) ~[netty-transport-4.2.1.Final.jar:4.2.1.Final]
SingleThreadIoEventLoop.java:175
	at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:1073) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
SingleThreadEventExecutor.java:1073
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
ThreadExecutorMap.java:74
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.2.1.Final.jar:4.2.1.Final]
FastThreadLocalRunnable.java:30
	at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]

[hks2002]

@tsegismont
Please confirm it with a true MSQL server. The connection can't build.
Current Documents doesn't include such use case.

[tsegismont]

Not sure what you mean. Can you share a small reproducer on GitHub? Please explain how to setup the database server and share the code to reproduce this issue

[hks2002]

https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16

The general form of the connection URL is

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

Need split the instanceName from the serverName if it has.
@tsegismont

[Yaytay]

Working with instance names is complex (the client has to send a UDP request to a specific port on the server and wait for a UDP reply telling it the port to use).
This makes things much more messy in many environments (particularly containers).
Although I think the vertx client ought to be able to work with named instances, your life will be nicer if you connect using port number rather than instance name.

[tsegismont]

Thanks @Yaytay for your comments

@hks2002 as a workaround, can you try to connect using the right port instead of the instance name?

A contribution to support instance name for connectivity is welcome