Patrick LeBoutillier wrote:
> Michael,
> 
> It looks like something is really broken. Are you sure that each
> Apache child has it's own connection to the database (netstat will
> tell you)? 

Sorry, my box was no longer on the network with the AS400 and I had to wait
until they rolled out the new code with PRIVATE enabled. This is what I see with
"netstat -a | grep 7891"

tcp        0      0 localhost.localdomain:7891  *:*                         
LISTEN
tcp        0      0 localhost.localdomain:7891  localhost.localdomain:35076
ESTABLISHED
tcp        0      0 localhost.localdomain:7891  localhost.localdomain:35073
ESTABLISHED
tcp        0      0 localhost.localdomain:35076 localhost.localdomain:7891
ESTABLISHED
tcp        0      0 localhost.localdomain:35073 localhost.localdomain:7891
ESTABLISHED

It seems that there are only 2 connections to the 7891, from 35076 and 35073.
And since we have some cron jobs that run that also use Inline::Java it makes me
think they don't actually have their own connections.

Now, looking back at the code, we have a separate script that starts the JVM. I
noticed that this script does not set the PERL_INLINE_JAVA_PRIVATE environment
variable. For some reason, after reading the docs I got the impression that all
I needed was to pass the PRIVATE var into my call to "use Inline()", but since I
have SHARED => 1 and START_JVM = 0 it makes sense that the already running JVM
wouldn't know to make every connection private.

I'll try setting this environment variable and let you know how it works. 
Thanks.

-- 
Michael Peters
Developer
Plus Three, LP

Reply via email to