Build of SP from SPB fails

[Odd Bjørn Andersen]

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 [phone], Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

[W Gemini]

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 [phone], 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?

[Odd Bjørn Andersen]

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 [phone], 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?

[Sean McKeough]

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 [phone], 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?

[Dmitri Liakh]

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

[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 [phone], Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

[oddand]

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 [phone], Telefaks 23 14 50 01 Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597

www.ergogroup.no

--
Posted via http://dbforums.com

[Remove the obvious for replies]

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 [phone], Telefaks 23 14 50 01 >Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597

www.ergogroup.no

--
Posted via http://dbforums.com

[Odd Bjørn Andersen]

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 [phone], Telefaks 23 14 50 01

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

www.ergogroup.no

--
Posted via http://dbforums.com