ADS 16.0.5
Debugging with a named instance gives The PORTNUMBER connection property is invalid
1. Remote desktop to AWS SQL Server 2014
2. Under Server Properties General Tab > Location > Server Name enter a named instance of the form host\named_instance
3. Under Server Properties Advanced Tab > Debugger > Enter the IP address as Domain, enter the correct username and password
4. Connect to the Server and navigate to Model database
5. Debug the sample stored procedure as in attached screenshot.
You get the exception : Connecting to server...
java.sql.SQLException: The PORTNUMBER connection property is invalid.
Null
Stack Trace:
java.sql.SQLException: The PORTNUMBER connection property is invalid.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.parseIntegerProperty(ConnectionJDBC2.java:1321)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.unpackProperties(ConnectionJDBC2.java:1165)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:289)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:58)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:191)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.aquafold.debugger.mssql.impl.tꀸꈙꃢ᠍ assert.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.oꆲꍏꅬꀒ 7 short.eO(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.cꆲꐹꆴᜩ float.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.oꆲꍏꅬꀒ 7 short.run(Unknown Source)
8/13 15:23:50.752 pꍽꆱꌌ⠪ boolean.sh java.lang.NullPointerException
8/13 15:23:50.752 pꍽꆱꌌ⠪ boolean.sh at \\...\\ .\\??���????????\\.o???? 7 short.a(Unknown Source)
8/13 15:23:50.752 pꍽꆱꌌ⠪ boolean.sh at \\...\\ .\\??���????????\\.o???? 7 short.a(Unknown Source)
8/13 15:23:50.754 pꍽꆱꌌ⠪ boolean.sh at \\...\\ .\\??���????????\\.o???? 7 short.run(Unknown Source)
8/13 15:23:50.782 oꆲꍏꅬꀒ 7 short.bY java.lang.IllegalArgumentException
8/13 15:23:50.783 oꆲꍏꅬꀒ 7 short.bY Cannot uninitialize debug session
java.lang.IllegalArgumentException
at com.aquafold.debugger.mssql.impl.tꀸꈙꃢ᠍ assert.i(Unknown Source)
at com.aquafold.debugger.mssql.impl.tꀸꈙꃢ᠍ assert.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.oꆲꍏꅬꀒ 7 short.bY(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.oꆲꍏꅬꀒ 7 short.run(Unknown Source)
Note that this error only occurs when using a Named Instance as the Host and where the port for the instance is not the default 1433. We have a Named Instance to reproduce on 10.1.1.69/1434 with named instance of 10.1.1.69\MSSQLSERVER02
Notice that two types of errors can occurs. One says "invalid database address", which is an error coming from the SQLite JDBC driver. If you remove the SQLite JDBC driver, then it tells you PORTNUMBER is invalid.
We are probably incorrectly constructing the URL. We need to pass it the INSTANCE property.