sqlj.install problem
Maroon, new to Informix on Windows, got error 9799 (VP context switch failed) running sqlj.install_jar. Claus Samuelsen advised enabling the VPCLASS jvp line, checking JVPCLASSPATH, restarting and verifying with onstat -g glo. Maroon edited the onconfig but still had the error. Guy Bowerman asked for onconfig entries, OS and IDS versions, and onstat -d. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello all
I am quite new in the informix database. When i was trying to
install java jar file in the informix, i get the following error.
EXECUTE PROCEDURE sqlj.install_jar# ^
# 9799: User Defined Routine (install_jar) VP context switch failed.
#
#
('file:E:\\Informix\\src\\ninesync.jar',
'nine_jar');
My OS- Windows
Maroon wrote:
> Hello all
> I am quite new in the informix database. When i was trying to
> install java jar file in the informix, i get the following error.
>
> EXECUTE PROCEDURE sqlj.install_jar> # ^
> # 9799: User Defined Routine (install_jar) VP context switch failed.
> #
> #
> ('file:E:\\Informix\\src\\ninesync.jar',
> 'nine_jar');
>
>
> My OS- Windows
>
If you want to create a user defined function (UDF) written in java, you
should first ensure that your IDS java environment is correct. Have you
initialized a java VP? See the last 10 lines or so in $ONCONFIG.
Uncomment the '#VPCLASS jvp' and check that JVPCLASSPATH is correct.
Then bounce IDS.
Ensure that you have intialized the java VP (jvp), use 'onstat -g glo'.
Hello dear, Thanks for your quick reply, I have changed the $ONCONFIG file in the location of \\informix\\etc, but still i have found the same error. I am looking forward for ur kind reply.
Maroon wrote:
> Hello dear,
> Thanks for your quick reply,
> I have changed the $ONCONFIG file in the location of \\informix\\etc,
> but still i have found the same error.
>
> I am looking forward for ur kind reply.
>
Can you paste your onconfig file here, or at least the following entries:
VPCLASS
JVP*
JDK*
MULTIPROCESSOR
NUMCPUVPS
SBSPACENAME
> My OS- Windows
What is the exact OS and version? e.g. "XP Professional Service Pack 2"
What is the IDS version (output from onstat -V)?
Can you run onstat -d to confirm you have an sbspace?
Guy