Re: sqlj.install problem

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_coffee # 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_coffee # 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 >>> > >