Skip to Content
Oct 05, 2021 at 10:52 PM

Unable to connect to Oracle 19c on STIG environment with Crystal Reports Java Runtime

270 Views Last edit Oct 05, 2021 at 11:08 PM 2 rev

I'm having an issue connecting to Oracle 19c on a STIG environment. OS is Redhat. The software generally works on non-STIG'ed systems, so STIG bring the problem is just an assumption so far.

The application calling the Crystal Report Java Runtime (12.2.225) successfully obtains it's own connection to the database, but the runtime is unable to get it's own connection with the PropertyBag handoff. The PropertyBag given is:

{Trusted Connection=true, Database DLL=crdb_jdbc.dll, Connection URL=!oracle.jdbc.OracleDriver!jdbc:oracle:thin:@tnsname, Database Class Name=oracle.jdbc.OracleDriver, Server Type=JDBC, Use JDBC=true}

When attempting to create the connection, we get the following error:

com.businessobjects.reports.sdk.JRCCommunicationAdapter - detected an exception: Logon Error: IO Error: could not resolve the connect identifier "\#@tnsname" (CONNECTION_ID=2T5ufScBRb+DrAgCVGPmAg==)

I am concerned with why the tnsname comes back with a "#" inserted, but I don't know if this is the problem.

The calling application uses the same connect string (jdbc:oracle:thin:@tnsname) and is able to connect without issues. When running the application, we are passing the argument to the JVM:

We also get very similar behavior if we don't use TNS at all and pass the host/port/sid.

Any thoughts appreciated!