By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

Build of SP from SPB fails

P: n/a
When trying to build a stored procedure from Stored Procedure Builder, I get
the following error message:

[IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-defined
function ".", specific name "" could not load Java class
"COM/ibm/db2/app/sqlejProcs", reason code "4". SQLSTATE=42724

This suddenly appeared after applying a fixpack. I have run bind on
db2ubind.lst and db2cli.lst.

Does any know what is wrong ?
--
Regards
-----------
Odd Bjørn Andersen

ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no
Nov 12 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Odd Bjørn Andersen wrote:
When trying to build a stored procedure from Stored Procedure Builder, I get
the following error message:

[IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-defined
function ".", specific name "" could not load Java class
"COM/ibm/db2/app/sqlejProcs", reason code "4". SQLSTATE=42724

This suddenly appeared after applying a fixpack. I have run bind on
db2ubind.lst and db2cli.lst.

Does any know what is wrong ?
--
Regards
-----------
Odd Bj?n Andersen

ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

Either the particular jar file was not installed properly or the
classpath was set wrong. Did you try run db2profile?

Nov 12 '05 #2

P: n/a
Sorry, but I forgot to mention that this is a Db2 versjon 7.2 on Windows NT.

My classpath looks like this:
CLASSPATH=.;D:\j2sdk1.4.2\bin;d:\javakurs;d:\oracl e\ora90\jdbc\lib\classes12
..zip
;D:\j2sdk1.4.2\bin\mail.jar;D:\j2sdk1.4.2\bin\acti vation.jar;D:\SQLLIB\java\
db2j
ava.zip;D:\SQLLIB\java\runtime.zip;D:\SQLLIB\java\ sqlj.zip;D:\SQLLIB\bin

I can not imagine what is missing, but supposing I am wrong and something is
missing - what could it possibly be ?

:-) Odd Bjørn Andersen

"W Gemini" <wg*****@nowhere.com> wrote in message
news:k0********************@news01.bloor.is.net.ca ble.rogers.com...
Odd Bjørn Andersen wrote:
When trying to build a stored procedure from Stored Procedure Builder, I get the following error message:

[IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-defined
function ".", specific name "" could not load Java class
"COM/ibm/db2/app/sqlejProcs", reason code "4". SQLSTATE=42724

This suddenly appeared after applying a fixpack. I have run bind on
db2ubind.lst and db2cli.lst.

Does any know what is wrong ?
--
Regards
-----------
Odd Bj?n Andersen

ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

Either the particular jar file was not installed properly or the
classpath was set wrong. Did you try run db2profile?

Nov 12 '05 #3

P: n/a
For v7 windows, only the 1.1.8 and 1.2.1 jdks are supported...
Odd Bjørn Andersen wrote:
Sorry, but I forgot to mention that this is a Db2 versjon 7.2 on Windows NT.

My classpath looks like this:
CLASSPATH=.;D:\j2sdk1.4.2\bin;d:\javakurs;d:\oracl e\ora90\jdbc\lib\classes12
.zip
;D:\j2sdk1.4.2\bin\mail.jar;D:\j2sdk1.4.2\bin\acti vation.jar;D:\SQLLIB\java\
db2j
ava.zip;D:\SQLLIB\java\runtime.zip;D:\SQLLIB\java\ sqlj.zip;D:\SQLLIB\bin

I can not imagine what is missing, but supposing I am wrong and something is
missing - what could it possibly be ?

:-) Odd Bjørn Andersen

"W Gemini" <wg*****@nowhere.com> wrote in message
news:k0********************@news01.bloor.is.net.ca ble.rogers.com...
Odd Bjørn Andersen wrote:
When trying to build a stored procedure from Stored Procedure Builder, I
get
the following error message:

[IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-defined
function ".", specific name "" could not load Java class
"COM/ibm/db2/app/sqlejProcs", reason code "4". SQLSTATE=42724

This suddenly appeared after applying a fixpack. I have run bind on
db2ubind.lst and db2cli.lst.

Does any know what is wrong ?
--
Regards
-----------
Odd Bj?n Andersen

ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no


Either the particular jar file was not installed properly or the
classpath was set wrong. Did you try run db2profile?



Nov 12 '05 #4

P: n/a
Hi,

I've never seen a reason code 4 : "Could not load driver for
"jdbc:default:connection"". It's possible there are conflicting class
names in classpath.
Can you remove Oracle jar files and retest?

-dmitri
Nov 12 '05 #5

P: n/a
I got the same message on one of my machines (none of my test machines
had that trouble).

I fixed it by specifying the Java Development Kit 1.1 path
(jdk11_path) variable for the instance to :

d:\sqllib\java\java12\jdk

Obviously you would need to substitute the appropraite drive letter.
But that fixed it for me....
On Tue, 28 Oct 2003 10:18:19 +0100, "Odd Bjørn Andersen"
<od**********@ergo.no> wrote:
When trying to build a stored procedure from Stored Procedure Builder, I get
the following error message:

[IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-defined
function ".", specific name "" could not load Java class
"COM/ibm/db2/app/sqlejProcs", reason code "4". SQLSTATE=42724

This suddenly appeared after applying a fixpack. I have run bind on
db2ubind.lst and db2cli.lst.

Does any know what is wrong ?
--
Regards
-----------
Odd Bjørn Andersen

ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no


Nov 12 '05 #6

P: n/a

I tried your suggestion, but this time I got another error message:
[IBM][CLI Driver][DB2/NT] SQL4301N Java interpreter startup or
communication failed, reason code "2". SQLSTATE=58004.

And I get a lot of error messages in the db2diag.log, the first
ones being:

2003-11-05-11.59.08.065000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

oper_system_services sqloJVMstart Probe:20

Error from sqloSuffixEnv. RC:

11f6 ffff ....

2003-11-05-11.59.08.075000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

oper_system_services sqloJAttach Probe:5

JVM startup failed. RC:

33ef ffff 3...

2003-11-05-11.59.08.085000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

BSU Java support sqlejAttach Probe:10

Error from sqloJAttach. RC:

33ef ffff 3...

Anyone any ideas from this ?

Regards

Odd Bjørn Andersen

Originally posted by Remove The Obvious For
Replies
I got the same message on one of my machines (none of my test machines had that trouble). I fixed it by specifying the Java Development Kit 1.1 path (jdk11_path) variable for the instance to : d:\sqllib\java\java12\jdk Obviously you would need to substitute the appropraite drive letter. But that fixed it for me.... On Tue, 28 Oct 2003 10:18:19 +0100, "Odd Bjørn Andersen" <od**********@ergo.no> wrote:
When trying to build a stored procedure from Stored Procedure

Builder, I get

the following error message: [IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-

defined

function ".", specific name "" could not load Java class "COM/ibm/db2/app/sqlejProcs", reason code "4".

SQLSTATE=42724

This suddenly appeared after applying a fixpack. I have run bind

on

db2ubind.lst and db2cli.lst. Does any know what is wrong ? -- Regards ----------- Odd Bjørn Andersen ErgoSolutions AS Postboks 4364 Nydalen, 0402 Oslo Telefon 23 14 50 00, Telefaks 23 14 50 01 Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597

www.ergogroup.no

--
Posted via http://dbforums.com
Nov 12 '05 #7

P: n/a
YUP - I forgot to mention that you need to set an environment variable
:

DB2SET DB2_USE_JDK12=1
That should fix yer problem...

On Wed, 05 Nov 2003 07:51:03 -0500, oddand <me********@dbforums.com>
wrote:

I tried your suggestion, but this time I got another error message:
[IBM][CLI Driver][DB2/NT] SQL4301N Java interpreter startup or
communication failed, reason code "2". SQLSTATE=58004.

And I get a lot of error messages in the db2diag.log, the first
ones being:

2003-11-05-11.59.08.065000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

oper_system_services sqloJVMstart Probe:20

Error from sqloSuffixEnv. RC:

11f6 ffff ....

2003-11-05-11.59.08.075000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

oper_system_services sqloJAttach Probe:5

JVM startup failed. RC:

33ef ffff 3...

2003-11-05-11.59.08.085000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

BSU Java support sqlejAttach Probe:10

Error from sqloJAttach. RC:

33ef ffff 3...

Anyone any ideas from this ?

Regards

Odd Bjørn Andersen

Originally posted by Remove The Obvious For
Replies
I got the same message on one of my machines (none of my test machines

had that trouble).


I fixed it by specifying the Java Development Kit 1.1 path

(jdk11_path) variable for the instance to :


d:\sqllib\java\java12\jdk


Obviously you would need to substitute the appropraite drive letter.

But that fixed it for me....



On Tue, 28 Oct 2003 10:18:19 +0100, "Odd Bjørn Andersen"

<od**********@ergo.no> wrote:


>When trying to build a stored procedure from Stored Procedure

Builder, I get

>the following error message: >[IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-

defined

>function ".", specific name "" could not load Java class >"COM/ibm/db2/app/sqlejProcs", reason code "4".

SQLSTATE=42724

>This suddenly appeared after applying a fixpack. I have run bind

on

>db2ubind.lst and db2cli.lst. >Does any know what is wrong ? >-- >Regards >----------- >Odd Bjørn Andersen >ErgoSolutions AS >Postboks 4364 Nydalen, 0402 Oslo >Telefon 23 14 50 00, Telefaks 23 14 50 01 >Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597

www.ergogroup.no

--
Posted via http://dbforums.com


Nov 12 '05 #8

P: n/a
Yes! Thank you. That did the trick.

Regards
Odd Bjørn A

"Remove the obvious for replies" <kurt.wood@NO**@M.state.mn.us> wrote in
message news:3f**************@news.state.mn.us...
YUP - I forgot to mention that you need to set an environment variable
:

DB2SET DB2_USE_JDK12=1
That should fix yer problem...

On Wed, 05 Nov 2003 07:51:03 -0500, oddand <me********@dbforums.com>
wrote:

I tried your suggestion, but this time I got another error message:
[IBM][CLI Driver][DB2/NT] SQL4301N Java interpreter startup or
communication failed, reason code "2". SQLSTATE=58004.

And I get a lot of error messages in the db2diag.log, the first
ones being:

2003-11-05-11.59.08.065000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

oper_system_services sqloJVMstart Probe:20

Error from sqloSuffixEnv. RC:

11f6 ffff ....

2003-11-05-11.59.08.075000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

oper_system_services sqloJAttach Probe:5

JVM startup failed. RC:

33ef ffff 3...

2003-11-05-11.59.08.085000 Instance:DB2 Node:000

PID:3716(db2dari.exe) TID:3492 Appid:

BSU Java support sqlejAttach Probe:10

Error from sqloJAttach. RC:

33ef ffff 3...

Anyone any ideas from this ?

Regards

Odd Bjørn Andersen

Originally posted by Remove The Obvious For
Replies
I got the same message on one of my machines (none of my test machines

had that trouble).


I fixed it by specifying the Java Development Kit 1.1 path

(jdk11_path) variable for the instance to :


d:\sqllib\java\java12\jdk


Obviously you would need to substitute the appropraite drive letter.

But that fixed it for me....



On Tue, 28 Oct 2003 10:18:19 +0100, "Odd Bjørn Andersen"

<od**********@ergo.no> wrote:


>When trying to build a stored procedure from Stored Procedure
Builder, I get

>the following error message:

>[IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or user-
defined

>function ".", specific name "" could not load Java class

>"COM/ibm/db2/app/sqlejProcs", reason code "4".
SQLSTATE=42724

>This suddenly appeared after applying a fixpack. I have run bind
on

>db2ubind.lst and db2cli.lst.

>Does any know what is wrong ?

>--

>Regards

>-----------

>Odd Bjørn Andersen

>ErgoSolutions AS

>Postboks 4364 Nydalen, 0402 Oslo

>Telefon 23 14 50 00, Telefaks 23 14 50 01

>Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597

www.ergogroup.no

--
Posted via http://dbforums.com

Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.