RE: RPG2SQL - is there something in WebSphere that will do the same thing?

Just so y'all know - the bosses are *very* impressed with the new
searches... again, you've made me look like I know what I'm doing :)

I do, of course, give all credit to the brilliance of this list.

Tom



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Hightower
Sent: Thursday, April 21, 2011 8:11 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: RPG2SQL - is there something in WebSphere that will do thesame
thing?

Yesssss!

Adding that extra command " ADDENVVAR ENVVAR(QIBM_RPG_JAVA_PROPERTIES)
VALUE('-Djava.version=1.4;')" did the trick.

Thanks to all - now for some real testing...

Tom

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Wednesday, April 20, 2011 11:39 PM
To: Midrange Systems Technical Discussion
Subject: Re: RPG2SQL - is there something in WebSphere that will do thesame
thing?

Hi Tom,

I don't think JAVA_HOME worked on v5r2, did it?

There were issues in (maybe v5r2?) with not being able to control the way
RPG started the JVM. It ignored CLASSPATH, and SystemDefault.properties,
and you really couldn't get it to do anything.
But, eventually (via PTF) they added support for all of that stuff.

You might try using QIBM_RPG_JAVA_PROPERTIES to see if that helps.

ADDENVVAR ENVVAR(QIBM_RPG_JAVA_PROPERTIES) +
VALUE('-Djava.version=1.4;')

This (like CLASSPATH) should be done in a fresh session before you've run
any Java at all. So, if your program is being run interactively, sign off
and back on again before setting the envvar. And don't run any
RPG-calling-java programs until after the envvar is set.

If that doesn't work, then my guess is that you're missing the appropriate
PTFs. Not sure if they're still available, though?

If they're not, your only other alternative is to start the JVM via the JNI
APIs. Not fun. But, it would give you the ability to specify stuff like the
JVM version.

But, what can you do? This is the price you pay for using an outdated OS.