Oninit cdi / Archive
Talk to an expert →

Pb with Krakatoa on Linux

Posted in 2007

Topics: Installation, Setup & Upgrades, Platform-Specific Issues, Java & JDBC Development

Jean Georges Perrin — — source: Usenet: comp.databases.informix

Hi, I am inserting a JAR in Cheetah and I get: SQL Error (-9431): Can't find system class or method or library (/opt/IBM/informix/extend/krakatoa/jre/bin/libhpi.so). Just after executing: EXECUTE PROCEDURE sqlj.install_jar( 'file:/tmp/statbuilder.jar','statbuilder', 0); Of course, (/opt/IBM/informix/extend/krakatoa/jre/bin/libhpi.so exists, Informix has the right to play with it. If I run: geo:/opt/IBM/informix/extend/krakatoa/jre/bin # ./java -version I get: java version "1.4.2" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2) Classic VM (build 1.4.2, J2RE 1.4.2 IBM build cxia32142-20060824 (SR6) (JIT enabled: jitc)) (ok it's a little lite for a Java test, but.) Any help would be. .helpful (ok, it's Friday here). Thanks! jgp

↪ replying to Jean Georges Perrin
Claus Samuelsen — — source: Usenet: comp.databases.informix

Jean Georges Perrin wrote: > Hi, > > I am inserting a JAR in Cheetah and I get: > > SQL Error (-9431): Can't find system class or method or library > (/opt/IBM/informix/extend/krakatoa/jre/bin/libhpi.so). > > Just after executing: > EXECUTE PROCEDURE sqlj.install_jar( 'file:/tmp/statbuilder.jar',> 'statbuilder', 0); > > Of course, (/opt/IBM/informix/extend/krakatoa/jre/bin/libhpi.so exists, > Informix has the right to play with it. > > If I run: > geo:/opt/IBM/informix/extend/krakatoa/jre/bin # ./java -version > > I get: > java version "1.4.2" > Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2) > Classic VM (build 1.4.2, J2RE 1.4.2 IBM build cxia32142-20060824 (SR6) (JIT > enabled: jitc)) > > (ok it's a little lite for a Java test, but.) > > Any help would be. .helpful (ok, it's Friday here). > > Thanks! > > jgp > As root create a file called /etc/ld.so.conf.d/informix.conf with a list of directories of the shared libraries you need. My /etc/ld.so.conf.d/informix.conf looks like this: /opt/IBM/informix/ids11/lib /opt/IBM/informix/ids11/lib/esql /opt/IBM/informix/ids11/extend/krakatoa/jre/bin After editing the file run the command 'ldconfig'

↪ replying to Claus Samuelsen
Jean Georges Perrin — — source: Usenet: comp.databases.informix

Thanks Claus, Well, it's better: > EXECUTE PROCEDURE sqlj.remove_jar('statbuilder', 0);SQL Error (-9431): Can't find system class or method or library (/opt/IBM/informix/extend/krakatoa/jre/bin/libjava.so). But not perfect... Of course... geo:/opt/IBM/informix # ll /opt/IBM/informix/extend/krakatoa/jre/bin/libjava.so -rwxr-xr-x 1 informix informix 142010 May 16 06:33 /opt/IBM/informix/extend/krakatoa/jre/bin/libjava.so My informix.conf is: /opt/IBM/informix/lib /opt/IBM/informix/lib/esql /opt/IBM/informix/extend/krakatoa/jre/bin /opt/IBM/informix/extend/krakatoa I tried with / without the 4th line... > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Claus Samuelsen > Sent: Friday, July 06, 2007 19:08 > To: informix-list@iiug.org > Subject: Re: Pb with Krakatoa on Linux > > Jean Georges Perrin wrote: > > Hi, > > > > I am inserting a JAR in Cheetah and I get: > > > > SQL Error (-9431): Can't find system class or method or library > > (/opt/IBM/informix/extend/krakatoa/jre/bin/libhpi.so). > > > > Just after executing: > > EXECUTE PROCEDURE sqlj.install_jar( 'file:/tmp/statbuilder.jar',> > 'statbuilder', 0); > > > > Of course, (/opt/IBM/informix/extend/krakatoa/jre/bin/libhpi.so > exists, > > Informix has the right to play with it. > > > > If I run: > > geo:/opt/IBM/informix/extend/krakatoa/jre/bin # ./java -version > > > > I get: > > java version "1.4.2" > > Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2) > > Classic VM (build 1.4.2, J2RE 1.4.2 IBM build cxia32142-20060824 > (SR6) (JIT > > enabled: jitc)) > > > > (ok it's a little lite for a Java test, but.) > > > > Any help would be. .helpful (ok, it's Friday here). > > > > Thanks! > > > > jgp > > > > As root create a file called /etc/ld.so.conf.d/informix.conf with a > list > of directories of the shared libraries you need. My > /etc/ld.so.conf.d/informix.conf looks like this: > /opt/IBM/informix/ids11/lib > /opt/IBM/informix/ids11/lib/esql > /opt/IBM/informix/ids11/extend/krakatoa/jre/bin > > After editing the file run the command 'ldconfig' > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list