International Informix Users Group

	Informix News

14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read 29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

Home Member Area About IIUG

[ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Linux-Informix Forum

Java UDR Error- JVPABORT:JVP

Posted By: Emilio
Date: Thursday, 10 October 2002, at 4:48 p.m.

This is a multi-part message in MIME format.

------=_NextPart_000_00D5_01C27084.3AF34290
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi!

I'm having problems executing java user defined routines in Informix =
Dynamic Server 9.3 UC2 in Debian/Linux.

The jar file is installed correctly and also there are no problems in =
creating the external function.

I can call the function from dbaccess or from any ODBC windows-tool with =
no problems.=20

But when I call the function from any java program (IBM Informix JDBC =
Driver 2.21.JC2) it hungs up and have no response from the server.

online.log
----------
17:16:21 Booting Language <spl> from module <>
17:16:21 Loading Module <SPLNULL>
17:17:28 Booting Language <java> from module =
<$INFORMIXDIR/extend/krakatoa/lmjava.so>
17:17:28 Loading Module <$INFORMIXDIR/extend/krakatoa/lmjava.so>
17:17:28 The C Language Module =
</opt/informix/extend/krakatoa/lmjava.so> loaded
17:17:28 Loading Module <helloworld_jar:helloworld_classes>
17:17:28 Got the mutex
17:17:28 Use Server hotspot VM

17:17:28 VM args[0]=3D -Xss512k
17:17:28 VM args[1]=3D =
-Djava.security.policy=3D/opt/informix/JVM_security
17:17:28 VM args[2]=3D -Xms16m
17:17:28 VM args[3]=3D -Xmx16m
17:17:28 VM args[4]=3D exit
17:17:28 VM args[5]=3D abort
17:17:28 VM args[6]=3D -verbose:jni
17:17:28 VM args[7]=3D vfprintf
17:17:28 VM args[8]=3D =
-Djava.class.path=3D/opt/informix/extend/krakatoa/krakatoa.jar:/opt/infor=
mix/extend/krakatoa/jdbc.jar:/opt/informix/extend/krakatoa
17:17:28 Successfully created Java VM.
17:17:29 JVPABORT:JVP process id =3D 28489 is aborting now!
Please contact Informix Technical Support...

jvp.log (also tried with krakatoa_g.jar and jdbc_g.jar but didn't have =
any other trace output)
-------
loading native library /opt/informix/extend/krakatoa/libjvp.so
Read JVP property file/opt/informix/extend/krakatoa/.jvpprops
*** Start copying old log content to /opt/informix/jvp.log3old ***
*** Log file reset is successful ***Thu Oct 10 17:17:29 ART 2002
DBAThread Pool is enabled with size =3D 20 with patrol interval =3D 5
Alarm Time set to 3

.jvpprops
---------
JVP.trace.settings:JVP=3D2
JVP.trace.verbose:1
JVP.trace.timestampformat: HH:mm
JVP.splitLog:1000
JVP.monitor.port:10000

$onstat -g sql 12 (never stops)
Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 01:29:51 =
-- 66792 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
12 EXEC PROCEDURE db_test CR Not Wait 0 0 9.03
Current statement name : _ifxc0000000000002
Current SQL statement :
execute function helloworld(?)
Last parsed SQL statement :
execute function helloworld(?)

Java UDR Code
-------------

public class helloworld_classes {
public static String helloWorld(String helloParam) {
return helloParam;
}
}

Can anyone help me? Any ideas?

Thanks!!!

Emilio Gutter
Datatransfer
egutter@datatransfer.com.ar

------=_NextPart_000_00D5_01C27084.3AF34290
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>Hi!</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>I'm having =
problems executing=20
java user defined routines in Informix Dynamic Server 9.3 UC2 in=20
Debian/Linux.</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>The jar =
file is=20
installed correctly and also there are no problems in creating the =
external=20
function.</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>I can call the =
function from=20
dbaccess or from any ODBC windows-tool with no problems. </FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>But when I call =
the function=20
from any java program (IBM Informix JDBC Driver 2.21.JC2) it hungs =
up and=20
have no response from the server.</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>online.log</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>----------</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>17:16:21 =
Booting=20
Language <spl> from module <><BR>17:16:21 Loading =
Module=20
<SPLNULL><BR>17:17:28 Booting Language <java> from =
module=20
<$INFORMIXDIR/extend/krakatoa/lmjava.so><BR>17:17:28 Loading =
Module=20
<$INFORMIXDIR/extend/krakatoa/lmjava.so><BR>17:17:28 The C =
Language=20
Module </opt/informix/extend/krakatoa/lmjava.so> =
loaded<BR>17:17:28 =20
Loading Module =
<helloworld_jar:helloworld_classes><BR>17:17:28 Got=20
the mutex<BR>17:17:28 Use Server hotspot VM</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>17:17:28 =
VM args[0]=3D=20
-Xss512k<BR>17:17:28 VM args[1]=3D=20
-Djava.security.policy=3D/opt/informix/JVM_security<BR>17:17:28 VM =
args[2]=3D=20
-Xms16m<BR>17:17:28 VM args[3]=3D -Xmx16m<BR>17:17:28 VM =
args[4]=3D=20
exit<BR>17:17:28 VM args[5]=3D abort<BR>17:17:28 VM =
args[6]=3D=20
-verbose:jni<BR>17:17:28 VM args[7]=3D vfprintf<BR>17:17:28 =
VM=20
args[8]=3D=20
-Djava.class.path=3D/opt/informix/extend/krakatoa/krakatoa.jar:/opt/infor=
mix/extend/krakatoa/jdbc.jar:/opt/informix/extend/krakatoa<BR>17:17:28&nb=
sp;=20
Successfully created Java VM.<BR>17:17:29 JVPABORT:JVP process id =
=3D 28489=20
is aborting now!<BR>Please contact Informix Technical=20
Support...<BR></FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>jvp.log (also =
tried with=20
krakatoa_g.jar and jdbc_g.jar but didn't have any other trace=20
output)</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>-------</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>loading native =
library=20
/opt/informix/extend/krakatoa/libjvp.so<BR>Read JVP property=20
file/opt/informix/extend/krakatoa/.jvpprops<BR>*** Start copying old log =
content=20
to /opt/informix/jvp.log3old ***<BR>*** Log file reset is successful =
***Thu Oct=20
10 17:17:29 ART 2002<BR>DBAThread Pool is enabled with size =3D 20 with =
patrol=20
interval =3D 5<BR>Alarm Time set to 3<BR></FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>.jvpprops</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>---------</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2>JVP.trace.settings:JVP=3D2</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2>JVP.trace.verbose:1</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>JVP.trace.timestampformat:=20
HH:mm</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2>JVP.splitLog:1000<BR></FONT><FONT face=3D"Courier New" =
color=3D#0000ff=20
size=3D2>JVP.monitor.port:10000<BR></FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>$onstat -g sql =
12 (never=20
stops)</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>Informix =
Dynamic Server=20
Version 9.30.UC2     -- On-Line -- Up 01:29:51 -- =
66792=20
Kbytes</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>Sess =20
SQL           =20
Current           =
Iso=20
Lock       SQL ISAM=20
F.E.<BR>Id    Stmt type     =20
Database           Lvl =

Mode       ERR ERR =20
Vers<BR>12    EXEC=20
PROCEDURE db_test        &nb=
sp;   =20
CR Not Wait   0    0   =20
9.03</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>Current =
statement name :=20
_ifxc0000000000002</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>Current SQL =
statement=20
:<BR> execute function helloworld(?)</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>Last parsed SQL =
statement=20
:<BR> execute function helloworld(?)<BR></FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>Java UDR =
Code</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>-------------</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>public class=20
helloworld_classes {</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2>        public static String =

helloWorld(String helloParam) {</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2>          &nbs=
p;    =20
return helloParam;</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2>        }<BR>}<BR><BR>Can =
anyone help=20
me? Any ideas?</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2>Thanks!!!</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2>Emilio=20
Gutter<BR>Datatransfer<BR><A=20
href=3D"mailto:egutter@datatransfer.com.ar">egutter@datatransfer.com.ar</=
A></FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2> </DIV></FONT></BODY></HTML>

------=_NextPart_000_00D5_01C27084.3AF34290--

Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html

[ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Linux-Informix Forum is maintained by Administrator with WebBBS 5.12.