vertx-sql-client icon indicating copy to clipboard operation
vertx-sql-client copied to clipboard

MS SQL uri parser does not parse JDBC urls

Open tsegismont opened this issue 3 years ago • 5 comments

With the Postgres and MySQL clients, you can take a connection URI that works with JDBC drivers and parse with the Reactive client parser.

I haven't checked for DB2 but this does not work with MSSQLConnectOptions.fromUri.

See https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url

tsegismont avatar May 03 '21 08:05 tsegismont

this is expected for the moment we don't parse JDBC urls

vietj avatar May 03 '21 14:05 vietj

if we were to do it, then we would do it globally

vietj avatar May 03 '21 14:05 vietj

@vietj indeed we don't commit to being able to parse any JDBC url.

But for Postgres and MySQL, most common urls are the same in JDBC and reactive clients. For MS SQL, we took the same format as Postgres and MySQL, but Microsoft uses values separated by semi-colons.

tsegismont avatar May 03 '21 14:05 tsegismont

Looks like this may be related to #1118

rdruss avatar Feb 02 '22 15:02 rdruss

@rdruss yes, it's a similar issue

tsegismont avatar Feb 04 '22 10:02 tsegismont