Pardon the n00b-ish question, but I'm [thankfully] mostly Java and JDBC illiterate. Traditionally, we've connected to JDBC data sources by using something like the following:
This works for 'onsoctcp' services. For 'onsocssl' services, we must do this:
Recently, we've started switching to using sqlhosts instead of hard-coding the host/port into the URL. That looks something like this:
What I'm curious about is whether the SSLCONNECTION=true is necessary, since the protocol is specified in sqlhosts. If it is, that's problematic, as we still have a mix of onsoctcp and onsocssl. If so, that's problematic, because I'd ideally like to make the connections as simple as specifying the INFORMIXSERVER and database name; requiring users and apps to conditionally specify SSLCONNECTION undermines the simplicity of the approach, and forces them to once again update connection strings as we transition legacy onsoctcp listeners to onsocssl.Thanks in advance for any insight.
Depending on the exact version TRUE is case sensitive J
These are lift from my java CM/SSL test harness, I can supply the code if you need it