Connect Windows Based SQL client software application to SAS using IOM and Java 11

scotjohnston — Wed, 19 May 2021 17:41:51 GMT

Hi,

We have some users who would like to connect a Windows Based SQL client software application to SAS using IOM and Java 11. I can get the connection to work using Java 8 and the com.sas.rio.MVADriver class but the client software comes with a bundled JRE for Java 11 and I am not sure how unstable the client will be for other database connections and if it will still be able to be updated automatically by the vendor if we force it to use Java 8.

I found this kb that talks to the issue I was seeing:

https://support.sas.com/kb/63/716.html

I tried the Workaround for Java 11 from the kb and it didn't work for me throwing this error:

Unable to return workspace. can't instantiate default ORB implementation com.sun.corba.ee.impl.orb.ORBSingleton

The GlassFish CORBA JAR file version I downloaded was 4.2.1 from April 2019. Maybe I need to try 4.2.0?

SAS Version: 9.04.01M5P091317.

Thanks for any input anyone has.

Re: Connect Windows Based SQL client software application to SAS using IOM and Java 11

gwootton — Mon, 24 May 2021 13:48:05 GMT

Did you get all the files mentioned in the SAS Note in your class path? It looks like the current version is 4.2.4, does that work any differently? I think 4.2.0 was the version technical support tested so that may be another one to try. Is there any additional information surrounding the error? That path (com.sun.corba.ee.impl.orb.ORBSingleton) is in glassfish-corba-orb.jar.

topic Connect Windows Based SQL client software application to SAS using IOM and Java 11 in Administration and Deployment

Connect Windows Based SQL client software application to SAS using IOM and Java 11

Re: Connect Windows Based SQL client software application to SAS using IOM and Java 11