Hello!
I try to create a Java Procedure in DB2 running under SuSE 9.3. But the
install_jar command fails with:
Error 58004 Error starting the Java Interpeter.
a db2set -all command results in:
db2inst1@linux:/usr/share/java> db2set -all
[i] DB2COMM=tcpip
[i] DB2AUTOSTART=YE S
[g] DB2SYSTEM=linux
[g] DB2ADMINSERVER= dasusr1
seems that there are some variables missing
my java is:
db2inst1@linux:/usr/share/java> java -version
java version "1.4.2_08"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_08-b03)
Java HotSpot(TM) Client VM (build 1.4.2_08-b03, mixed mode)
How can I append some variables in db2set and witch one do i have to
define for Java UDF?
Tanks!
Christian Meier
4  2530 
Hello.
Try
db2 update dbm cfg using JDK_PATH <your_jdk_dir >;
db2stop;
db2start;
Tip: you point to the directory that contains bin and lib
subdirectories.
Sincerely,
Mark B.
OK, now it's pointing to: /usr/lib/jvm/java-1.4.2-sun-1.4.2.08
I read in another Tread about some missing definitions in the
/etc/ld.so.conf
and I added there the entries:
/usr/lib/jvm/java-1.4.2-sun-1.4.2.08/bin
/usr/lib/jvm/java-1.4.2-sun-1.4.2.08/lib
I restared my DB2 but it still fails. The db2dia.log sais:
2005-08-11-07.30.46.489503 +120 I305086G359 LEVEL: Error
PID : 9191 TID : 3064985280 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:30
MESSAGE : sqloloadmodule failed. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFFC2A4 : 0A00 0F86 ....
2005-08-11-07.30.46.490403 +120 I305446G354 LEVEL: Error
PID : 9191 TID : 3064985280 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJAttach, probe:5
MESSAGE : JVM startup failed. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFFF4C0 : 34EF FFFF 4...
2005-08-11-07.30.46.490670 +120 I305801G355 LEVEL: Error
PID : 9191 TID : 3064985280 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejAttach, probe:10
MESSAGE : Error from sqloJAttach. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFFF4E4 : 34EF FFFF 4...
seems he can not open the JVM but why?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jack |
last post by:
I am trying to get javamail running with DB2 and am running into a
problem with the sqlj.install_jar. When I go to install the jar, I
get a SQL1131 error message which is unhelpful. This is a fresh DB2
install and the first jar file I've tried to install on this system.
This is one the command I am issuing:
call sqlj.install_jar('file:/home/db2inst1/jaf-1.0.2/activation.jar','ACTIVATION')
This is running on:
Linux RHEL AS 3 update 1,
|
by: Bernard Dhooghe |
last post by:
DB2 UDB V8.1 Fixpak 4 AIX 5.1
CLASSPATH:
/usr/opt/db2_08_01/java/db2jcc.jar:/usr/opt/db2_08_01/java/db2jcc_license_cu.jar:/usr/opt/db2_08_01/java/sqlj.zip:/usr/java131/jre/lib/rt.jar:
Program: tmp0.sqlj
import java.sql.*;
import sqlj.runtime.*;
import sqlj.runtime.ref.*;
|
by: Xela |
last post by:
Hi
A have a very annoying problem. I have written java strored procedures for
DB2 v8.1. Their deployement and usage is fine as long as the server is a
Windows one. But under Solaris 8 and Linux RH, the call of sqlj.install_jar
fails. It correctly create a directiory with the correct schema name, but
the jar is not copied in it. The error is "Permission Denied" SQLSTATE 38501
and in the log, we can see that calling sqlejReadJar fails in...
|
by: Rhino |
last post by:
I am having an odd problem: the sqlj command on my system doesn't work.
I am running DB2 (LUW) V8 (FP8) on WinXP.
I haven't done an sqlj program since Version 6 of DB2 (LUW) so I checked the
manuals for the proper techniques to prepare an sqlj program. When I went to
try the sqlj command, I got this:
Exception in thread "main" java.lang.NoClassDefFoundError:
sqlj/tools/Sqlj
|
by: Jean-Marc Blaise |
last post by:
Hi,
The dev center calls sqlj.DB2_UPDATEJARINFO
('JMARC.JMB','JMB','file:JMB.sqlj') to update the sqlj routine source.
I tried in CLP from the directory containing jar and sqlj files (Windows 8.2
FP9):
db2 connect to sample
db2 call sqlj.DB2_UPDATEJARINFO ('JMARC.JMB','JMB','file:JMB.sqlj')
| | |
by: bwa |
last post by:
I have created a SQLJ file with RAD and have customized and binded the
4 packages (1 for each isolation level).
But my DB2 monitor shows that the query is executed dynamlically.
Why ?
Bjørn-Willy
|
by: tol7481 |
last post by:
Hi,
I'm trying to deploy a Java stored procedure on DB2 V8 on a Linux box,
but I have some problems.
I've added to the classpath the following JARs
sqllib/java/db2java.zip
sqllib/java/db2jcc.jar
sqllib/java/db2jcc_license_cu.jar
sqllib/java/sqlj.zip
|
by: sofy |
last post by:
Hi all
'm facing a problem in translation/compilation of a .sqlj file.Eventhough the .sqlj file is modified , the translated java file still contains the previous errors.Also only .ser file is getting created.
Pls help
Thanks
|
by: mzhang |
last post by:
Hi,
Can anyone help? I'm kind stuck.
I have db2 workgroup 8.2 on RHEL 4.0, java 1.4.2. Here is the errors
db2 " call sqlj.install_jar ('file:/home/int24/vap/phx/vap/storedProc.jar', 'INT24Jar') "
SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
