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

Here i have send the part of the onconfig file. I am looking forward
for your kind reply.


VPCLASS jvp,num=1 # Number of JVPs to start with

JVPJAVAHOME # JDK installation root directory
JVPHOME # Krakatoa installation directory

JVPLOGFILE jvp.log # JVP log file.
JVPPROPFILE .jvpprops # JVP property file

JDKVERSION 1.3 # JDK version supported by this server

# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB \bin\

JVPJAVAVM hpi;server;verify;java;net;zip;jpeg

# Classpath to use upon Java VM start-up (use _g version for debugging)
JVPCLASSPATH

You didn't answer these questions:
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?

But from the values you pasted it looks like you're quoting
"onconfig.std" which is a template onconfig and not the onconfig file
your server uses when it is set up by the install program. Please paste
the same settings for the file: onconfig.%INFORMIXSERVER%

Thanks
Guy

Maroon wrote:
> Here i have send the part of the onconfig file. I am looking forward
> for your kind reply.
>
>
> VPCLASS jvp,num=1 # Number of JVPs to start with
>
> JVPJAVAHOME # JDK installation root directory
> JVPHOME # Krakatoa installation directory
>
> JVPLOGFILE jvp.log # JVP log file.
> JVPPROPFILE .jvpprops # JVP property file
>
> JDKVERSION 1.3 # JDK version supported by this server
>
> # The path to the JRE libraries relative to JVPJAVAHOME
> JVPJAVALIB \bin\
>
> JVPJAVAVM hpi;server;verify;java;net;zip;jpeg
>
> # Classpath to use upon Java VM start-up (use _g version for debugging)
> JVPCLASSPATH
>

Guy,
I paste the onconfig file, Sorry i am quite new in the informix
database.

OS---->"XP Professional Service Pack 1"
IDS version--->IBM Informix Dynamic Server Version 9.40.TC5

#
# The following are default settings for enabling Java in the database.
#

VPCLASS jvp,num=3 # Number of JVPs to start with

JVPJAVAHOME E:\program\informix\extend\krakatoa\jre # JDK installation
root directory
JVPHOME E:\program\informix\extend\krakatoa # Krakatoa installation
directory

JVPLOGFILE E:\program\informix\extend\krakatoa\coffee_jvp.log # VP log
file
JVPPROPFILE E:\program\informix\extend\krakatoa\.jvpprops_coff ee # JVP
property file

JDKVERSION 1.3 # JDK version supported by this server

# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB \bin\

JVPJAVAVM hpi;server;verify;java;net;zip;jpeg

# Classpath to use upon Java VM start-up (use _g version for debugging)
JVPCLASSPATH E:\program\informix\extend\krakatoa\krakatoa.jar;E :\program\informix\extend\krakatoa\jdbc.jar

Maroon,

You could try two things.

1. Make sure SINGLE_CPU_VP is set to 0 in the onconfig file.
2. Try changing the VPCLASS parameter to: VPCLASS jvp,num=1

After checking 1. and changing 2. restart IDS and try again.

If still no luck, try the examples in %INFORMIXDIR%\extend\krakatoa\examples
and see if they work.

Regards
Guy

Maroon wrote:
> Guy,
> I paste the onconfig file, Sorry i am quite new in the informix
> database.
>
> OS---->"XP Professional Service Pack 1"
> IDS version--->IBM Informix Dynamic Server Version 9.40.TC5
>
> #
> # The following are default settings for enabling Java in the database.
> #
>
> VPCLASS jvp,num=3 # Number of JVPs to start with
>
> JVPJAVAHOME E:\program\informix\extend\krakatoa\jre # JDK installation
> root directory
> JVPHOME E:\program\informix\extend\krakatoa # Krakatoa installation
> directory
>
> JVPLOGFILE E:\program\informix\extend\krakatoa\coffee_jvp.log # VP log
> file
> JVPPROPFILE E:\program\informix\extend\krakatoa\.jvpprops_coff ee # JVP
> property file
>
> JDKVERSION 1.3 # JDK version supported by this server
>
> # The path to the JRE libraries relative to JVPJAVAHOME
> JVPJAVALIB \bin\
>
> JVPJAVAVM hpi;server;verify;java;net;zip;jpeg
>
> # Classpath to use upon Java VM start-up (use _g version for debugging)
> JVPCLASSPATH E:\program\informix\extend\krakatoa\krakatoa.jar;E :\program\informix\extend\krakatoa\jdbc.jar
>

Hello Guy,
thanks,
I could not find the vpclass parameter error.

EXECUTE PROCEDURE sqlj.install_jar
('file:E:\program\informix\jar\ninesync.jar',
'ninesync_jar', 1);

9498: Incorrect path to JAR file specified:
(java.io.FileNotFoundException: \tmp\coffee.informix.ninesync_jar.jar
(T). Error in line 3 Near character position 16

But the location of my jar file is correct. Is anything worng here?


Guy Bowerman wrote:
> Maroon,
>
> You could try two things.
>
> 1. Make sure SINGLE_CPU_VP is set to 0 in the onconfig file.
> 2. Try changing the VPCLASS parameter to: VPCLASS jvp,num=1
>
> After checking 1. and changing 2. restart IDS and try again.
>
> If still no luck, try the examples in %INFORMIXDIR%\extend\krakatoa\examples
> and see if they work.
>
> Regards
> Guy
>
> Maroon wrote:
> > Guy,
> > I paste the onconfig file, Sorry i am quite new in the informix
> > database.
> >
> > OS---->"XP Professional Service Pack 1"
> > IDS version--->IBM Informix Dynamic Server Version 9.40.TC5
> >
> > #
> > # The following are default settings for enabling Java in the database.
> > #
> >
> > VPCLASS jvp,num=3 # Number of JVPs to start with
> >
> > JVPJAVAHOME E:\program\informix\extend\krakatoa\jre # JDK installation
> > root directory
> > JVPHOME E:\program\informix\extend\krakatoa # Krakatoa installation
> > directory
> >
> > JVPLOGFILE E:\program\informix\extend\krakatoa\coffee_jvp.log # VP log
> > file
> > JVPPROPFILE E:\program\informix\extend\krakatoa\.jvpprops_coff ee # JVP
> > property file
> >
> > JDKVERSION 1.3 # JDK version supported by this server
> >
> > # The path to the JRE libraries relative to JVPJAVAHOME
> > JVPJAVALIB \bin\
> >
> > JVPJAVAVM hpi;server;verify;java;net;zip;jpeg
> >
> > # Classpath to use upon Java VM start-up (use _g version for debugging)
> > JVPCLASSPATH E:\program\informix\extend\krakatoa\krakatoa.jar;E :\program\informix\extend\krakatoa\jdbc.jar
> >

>>You could try two things.
>>
>>1. Make sure SINGLE_CPU_VP is set to 0 in the onconfig file.
>>2. Try changing the VPCLASS parameter to: VPCLASS jvp,num=1

> I could not find the vpclass parameter error.

I don't understand your answer. Did you check the SINGLE_CPU_VP onconfig
paramter? Did you change the VPCLASS parameter to "jvp,num=1" ?

You seem to be getting a new error now, earlier you were reporting a
context switch error. Is that because you made the above changes?

Did you try running the examples in %INFORMIXDIR%\extend\krakatoa\examples ?

Guy

Maroon wrote:
> Hello Guy,
> thanks,

>
> EXECUTE PROCEDURE sqlj.install_jar
> ('file:E:\program\informix\jar\ninesync.jar',
> 'ninesync_jar', 1);
>
> 9498: Incorrect path to JAR file specified:
> (java.io.FileNotFoundException: \tmp\coffee.informix.ninesync_jar.jar
> (T). Error in line 3 Near character position 16
>
> But the location of my jar file is correct. Is anything worng here?
>
>
> Guy Bowerman wrote:
>
>>Maroon,
>>


>>
>>After checking 1. and changing 2. restart IDS and try again.
>>
>>If still no luck, try the examples in %INFORMIXDIR%\extend\krakatoa\examples
>>and see if they work.
>>
>>Regards
>>Guy
>>
>>Maroon wrote:
>>
>>>Guy,
>>>I paste the onconfig file, Sorry i am quite new in the informix
>>>database.
>>>
>>>OS---->"XP Professional Service Pack 1"
>>> IDS version--->IBM Informix Dynamic Server Version 9.40.TC5
>>>
>>>#
>>># The following are default settings for enabling Java in the database.
>>>#
>>>
>>>VPCLASS jvp,num=3 # Number of JVPs to start with
>>>
>>>JVPJAVAHOME E:\program\informix\extend\krakatoa\jre # JDK installation
>>>root directory
>>>JVPHOME E:\program\informix\extend\krakatoa # Krakatoa installation
>>>directory
>>>
>>>JVPLOGFILE E:\program\informix\extend\krakatoa\coffee_jvp.log # VP log
>>>file
>>>JVPPROPFILE E:\program\informix\extend\krakatoa\.jvpprops_coff ee # JVP
>>>property file
>>>
>>>JDKVERSION 1.3 # JDK version supported by this server
>>>
>>># The path to the JRE libraries relative to JVPJAVAHOME
>>>JVPJAVALIB \bin\
>>>
>>>JVPJAVAVM hpi;server;verify;java;net;zip;jpeg
>>>
>>># Classpath to use upon Java VM start-up (use _g version for debugging)
>>>JVPCLASSPATH E:\program\informix\extend\krakatoa\krakatoa.jar;E :\program\informix\extend\krakatoa\jdbc.jar
>>>
>
>