Support to SSL connection about trino-db2 HOT 9 CLOSED

@shawnzhu

from trino-db2.

This ticket is not for enhancement, it is a bug report... @shawnzhu

from trino-db2.

The error message from #14 (comment) is Invalid database URL syntax: jdbc:db2://db2whoc-flex-performance-riubnzs.services.dal.bluemix.net:50001/BLUDB:sslConnection=true. ERRORCODE=-4461, SQLSTATE=42815

So what doesn't work:

jdbc:db2://xxx.services.dal.bluemix.net:50001/BLUDB:sslConnection=true

What works (for me):

jdbc:db2://xxx.services.dal.bluemix.net:50001/BLUDB:sslConnection=true;

So the difference is the trailing semi-colon. See official guide in https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.doc/connecting/connect_connecting_jdbc_applications.html

from trino-db2.

@shawnzhu
Yeah, you are right. I just tested the URL with colon. And it works. Thanks to IBM's innovative URL design for their DB2 jdbc driver!

from trino-db2.

PR has been filed for this issue: #15

from trino-db2.

In one case, I used this library connected to DashDB (named DB2 on Cloud now) via SSL and it works well w/o code change. So I assume one of the expected outcome is documentation on howto.

from trino-db2.

I would love to know how to connect to learn the "how to".
I am using "IBM Db2 Warehouse on Cloud", at lease for this product, appending "sslConnection=true" to the url did not work for my case.

from trino-db2.

Let me know if you would like me to close the PR: #15.

from trino-db2.

Yeah, you are right. I just tested the URL with colon. And it works. Thanks to IBM's innovative URL design for their DB2 jdbc driver!

@psyking841 I prefer not to change what it was in DB2 JDBC driver/doc when using this connector, or we can do something to make such configuration more humane. will close #15 but create a new one to highlight this case.

from trino-db2.