Save 
Join IIUG
 for   
 

Informix News
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter


[ 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.