473,903 Members | 4,731 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

installing a java sytored procedure from windoze development centre

Hi all,
I am trying to install a java stored procedure via the windows
development centre.

The linux box is running 8.1 FP4 as is the windoze platform. If I am
on the linux box i can install the sample jdbc stored procedures o.k.

For the purpose of this test I created a sample procedure that
executes "select * from department" when conected to the sample
database on the linux box.

The connection to the server works o.k. but when it tries to
build/install the stored procedure I get :-

DB2INST1.PROCED URE3 - Build started.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\javac -classpath
".;C:\PROGRA~1\ SQLLIB\java\db2 java.zip;C:\PRO GRA~1\SQLLIB\ja va\runtime.zip; C:\PROGRA~1\SQL LIB\java\sqlj.z ip"
"PROCEDURE3.jav a"
DB2INST1.PROCED URE3 - Javac completed.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\jar cf SQL310170502183 10.jar
PROCEDURE3.clas s
DB2INST1.PROCED URE3 - Jar file created.
Call sqlj.install_ja r ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
'"DB2INST1".SQL 31017050218310' , 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. SQLSTATE=58004

DB2INST1.PROCED URE3 - Build failed.
DB2INST1.PROCED URE3 - Roll back completed successfully.
Now is is just a case of the created jar file not getting to the
server? The aboe almost looks as if sqlj.install_ja r on the linux box
is trying to access a jar file on the windoze platform

While I *could* do all this from a cli on the linux box, it does seem
a bit easier to use the development centre.

Trawling through the information centre I did find some comments about
setting up classpath ld_library_path etc and I think I have done that
o.k.

Any help appreciated

Alex
Nov 12 '05 #1
7 3268
A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Hi all,
I am trying to install a java stored procedure via the windows
development centre.

The linux box is running 8.1 FP4 as is the windoze platform. If I am
on the linux box i can install the sample jdbc stored procedures o.k.

For the purpose of this test I created a sample procedure that
executes "select * from department" when conected to the sample
database on the linux box.

The connection to the server works o.k. but when it tries to
build/install the stored procedure I get :-

DB2INST1.PROCED URE3 - Build started.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\javac -classpath
".;C:\PROGRA~1\ SQLLIB\java\db2 java.zip;C:\PRO GRA~1\SQLLIB\ja va\runtime.zip; C:\PROGRA~1\SQL LIB\java\sqlj.z ip"
"PROCEDURE3.jav a"
DB2INST1.PROCED URE3 - Javac completed.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\jar cf SQL310170502183 10.jar
PROCEDURE3.clas s
DB2INST1.PROCED URE3 - Jar file created.
Call sqlj.install_ja r ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
'"DB2INST1".SQL 31017050218310' , 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. SQLSTATE=58004

DB2INST1.PROCED URE3 - Build failed.
DB2INST1.PROCED URE3 - Roll back completed successfully.
Now is is just a case of the created jar file not getting to the
server? The aboe almost looks as if sqlj.install_ja r on the linux box
is trying to access a jar file on the windoze platform

While I *could* do all this from a cli on the linux box, it does seem
a bit easier to use the development centre.

Trawling through the information centre I did find some comments about
setting up classpath ld_library_path etc and I think I have done that
o.k.

Any help appreciated

Alex

Try this:
http://www-1.ibm.com/support/docview...=utf-8&lang=en

-Eugene
Nov 12 '05 #2
Just an update.

I've trawled the ibm site and found various documents on setting up
a Java environment on a linux system and *think* I've got the
path,classpath and ld_library_path variables set up correctly.

This time I've uploaded a jar file into /usr/local/java/lib called
mail.jar and am trying to run call
sqlj.install_ja r('file:/usr/local/java/lib/mail.jar','MAIL JAR')

having connected to the sample database

I unfortunately get the same error as before i.e. SQL1042C and
SQLSTATE 58004

Is ther any form of additional logging i can enable to find out
exactly what is going on when i run the sqlj.install_ja r procedure?

TIA
Alex
A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Hi all,
I am trying to install a java stored procedure via the windows
development centre.

The linux box is running 8.1 FP4 as is the windoze platform. If I am
on the linux box i can install the sample jdbc stored procedures o.k.

For the purpose of this test I created a sample procedure that
executes "select * from department" when conected to the sample
database on the linux box.

The connection to the server works o.k. but when it tries to
build/install the stored procedure I get :-

DB2INST1.PROCED URE3 - Build started.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\javac -classpath
".;C:\PROGRA~1\ SQLLIB\java\db2 java.zip;C:\PRO GRA~1\SQLLIB\ja va\runtime.zip; C:\PROGRA~1\SQL LIB\java\sqlj.z ip"
"PROCEDURE3.jav a"
DB2INST1.PROCED URE3 - Javac completed.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\jar cf SQL310170502183 10.jar
PROCEDURE3.clas s
DB2INST1.PROCED URE3 - Jar file created.
Call sqlj.install_ja r ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
'"DB2INST1".SQL 31017050218310' , 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. SQLSTATE=58004

DB2INST1.PROCED URE3 - Build failed.
DB2INST1.PROCED URE3 - Roll back completed successfully.
Now is is just a case of the created jar file not getting to the
server? The aboe almost looks as if sqlj.install_ja r on the linux box
is trying to access a jar file on the windoze platform

While I *could* do all this from a cli on the linux box, it does seem
a bit easier to use the development centre.

Trawling through the information centre I did find some comments about
setting up classpath ld_library_path etc and I think I have done that
o.k.

Any help appreciated

Alex

Nov 12 '05 #3
Anothe update

Hi all,

Well, on a test server i've managed to get some java stored procedures
into the system.

The small problem is that the system I want to do this on is currently
running either j2sdk1.4.0_01 or a JVM called jrockit by a company
called bea systems.

Is anyone running a different jdk to the one supplied in
/opt/IBMJava2-131 ?
Alex

A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Just an update.

I've trawled the ibm site and found various documents on setting up
a Java environment on a linux system and *think* I've got the
path,classpath and ld_library_path variables set up correctly.

This time I've uploaded a jar file into /usr/local/java/lib called
mail.jar and am trying to run call
sqlj.install_ja r('file:/usr/local/java/lib/mail.jar','MAIL JAR')

having connected to the sample database

I unfortunately get the same error as before i.e. SQL1042C and
SQLSTATE 58004

Is ther any form of additional logging i can enable to find out
exactly what is going on when i run the sqlj.install_ja r procedure?

TIA
Alex
A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Hi all,
I am trying to install a java stored procedure via the windows
development centre.

The linux box is running 8.1 FP4 as is the windoze platform. If I am
on the linux box i can install the sample jdbc stored procedures o.k.

For the purpose of this test I created a sample procedure that
executes "select * from department" when conected to the sample
database on the linux box.

The connection to the server works o.k. but when it tries to
build/install the stored procedure I get :-

DB2INST1.PROCED URE3 - Build started.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\javac -classpath
".;C:\PROGRA~1\ SQLLIB\java\db2 java.zip;C:\PRO GRA~1\SQLLIB\ja va\runtime.zip; C:\PROGRA~1\SQL LIB\java\sqlj.z ip"
"PROCEDURE3.jav a"
DB2INST1.PROCED URE3 - Javac completed.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\jar cf SQL310170502183 10.jar
PROCEDURE3.clas s
DB2INST1.PROCED URE3 - Jar file created.
Call sqlj.install_ja r ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
'"DB2INST1".SQL 31017050218310' , 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. SQLSTATE=58004

DB2INST1.PROCED URE3 - Build failed.
DB2INST1.PROCED URE3 - Roll back completed successfully.
Now is is just a case of the created jar file not getting to the
server? The aboe almost looks as if sqlj.install_ja r on the linux box
is trying to access a jar file on the windoze platform

While I *could* do all this from a cli on the linux box, it does seem
a bit easier to use the development centre.

Trawling through the information centre I did find some comments about
setting up classpath ld_library_path etc and I think I have done that
o.k.

Any help appreciated

Alex

Nov 12 '05 #4
Well now got a setup where I can add stored procedures and user
defined functions and define a trigger ( It's actually from an article
in the DB2 magazine Volume 8 number 4 "Combining Triggers and UDFs" )

The problem is that now when i try and execute an SQL command to run
the trigger which should run the UDF I get :-

db2 => update booktable set quantity=8 where isbn=446310786
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0723N An error occurred in a triggered SQL statement in trigger
"DB2INST1.TABLE TR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RESUP PLY|SQL03120114 4832600|java". SQLSTATE=09000
db2 =>

Any help appreciated

Alex
A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Anothe update

Hi all,

Well, on a test server i've managed to get some java stored procedures
into the system.

The small problem is that the system I want to do this on is currently
running either j2sdk1.4.0_01 or a JVM called jrockit by a company
called bea systems.

Is anyone running a different jdk to the one supplied in
/opt/IBMJava2-131 ?
Alex

A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Just an update.

I've trawled the ibm site and found various documents on setting up
a Java environment on a linux system and *think* I've got the
path,classpath and ld_library_path variables set up correctly.

This time I've uploaded a jar file into /usr/local/java/lib called
mail.jar and am trying to run call
sqlj.install_ja r('file:/usr/local/java/lib/mail.jar','MAIL JAR')

having connected to the sample database

I unfortunately get the same error as before i.e. SQL1042C and
SQLSTATE 58004

Is ther any form of additional logging i can enable to find out
exactly what is going on when i run the sqlj.install_ja r procedure?

TIA
Alex
A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Hi all,
I am trying to install a java stored procedure via the windows
development centre.

The linux box is running 8.1 FP4 as is the windoze platform. If I am
on the linux box i can install the sample jdbc stored procedures o.k.

For the purpose of this test I created a sample procedure that
executes "select * from department" when conected to the sample
database on the linux box.

The connection to the server works o.k. but when it tries to
build/install the stored procedure I get :-

DB2INST1.PROCED URE3 - Build started.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\javac -classpath
".;C:\PROGRA~1\ SQLLIB\java\db2 java.zip;C:\PRO GRA~1\SQLLIB\ja va\runtime.zip; C:\PROGRA~1\SQL LIB\java\sqlj.z ip"
"PROCEDURE3.jav a"
DB2INST1.PROCED URE3 - Javac completed.
C:\PROGRA~1\SQL LIB\java\jdk\bi n\jar cf SQL310170502183 10.jar
PROCEDURE3.clas s
DB2INST1.PROCED URE3 - Jar file created.
Call sqlj.install_ja r ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
'"DB2INST1".SQL 31017050218310' , 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. SQLSTATE=58004

DB2INST1.PROCED URE3 - Build failed.
DB2INST1.PROCED URE3 - Roll back completed successfully.
Now is is just a case of the created jar file not getting to the
server? The aboe almost looks as if sqlj.install_ja r on the linux box
is trying to access a jar file on the windoze platform

While I *could* do all this from a cli on the linux box, it does seem
a bit easier to use the development centre.

Trawling through the information centre I did find some comments about
setting up classpath ld_library_path etc and I think I have done that
o.k.

Any help appreciated

Alex

Nov 12 '05 #5
4302 often means either a java config problem, or a routine signature
mismatch. You might want to up your diaglevel to 4, and try invoking the
udf on its own...something useful might show up in the diag.

Alex wrote:
Well now got a setup where I can add stored procedures and user
defined functions and define a trigger ( It's actually from an article
in the DB2 magazine Volume 8 number 4 "Combining Triggers and UDFs" )

The problem is that now when i try and execute an SQL command to run
the trigger which should run the UDF I get :-

db2 => update booktable set quantity=8 where isbn=446310786
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0723N An error occurred in a triggered SQL statement in trigger
"DB2INST1.TABLE TR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RESUP PLY|SQL03120114 4832600|java". SQLSTATE=09000
db2 =>

Any help appreciated

Alex
A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Anothe update

Hi all,

Well, on a test server i've managed to get some java stored procedures
into the system.

The small problem is that the system I want to do this on is currently
running either j2sdk1.4.0_01 or a JVM called jrockit by a company
called bea systems.

Is anyone running a different jdk to the one supplied in
/opt/IBMJava2-131 ?
Alex

A.******@hull .ac.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Just an update.

I've trawled the ibm site and found various documents on setting up
a Java environment on a linux system and *think* I've got the
path,classpa th and ld_library_path variables set up correctly.

This time I've uploaded a jar file into /usr/local/java/lib called
mail.jar and am trying to run call
sqlj.install _jar('file:/usr/local/java/lib/mail.jar','MAIL JAR')

having connected to the sample database

I unfortunately get the same error as before i.e. SQL1042C and
SQLSTATE 58004

Is ther any form of additional logging i can enable to find out
exactly what is going on when i run the sqlj.install_ja r procedure?

TIA
Alex
A.******@hul l.ac.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...

Hi all,
I am trying to install a java stored procedure via the windows
developme nt centre.

The linux box is running 8.1 FP4 as is the windoze platform. If I am
on the linux box i can install the sample jdbc stored procedures o.k.

For the purpose of this test I created a sample procedure that
executes "select * from department" when conected to the sample
database on the linux box.

The connection to the server works o.k. but when it tries to
build/install the stored procedure I get :-

DB2INST1.PR OCEDURE3 - Build started.
C:\PROGRA~1 \SQLLIB\java\jd k\bin\javac -classpath
".;C:\PROGR A~1\SQLLIB\java \db2java.zip;C: \PROGRA~1\SQLLI B\java\runtime. zip;C:\PROGRA~1 \SQLLIB\java\sq lj.zip"
"PROCEDURE3 .java"
DB2INST1.PR OCEDURE3 - Javac completed.
C:\PROGRA~1 \SQLLIB\java\jd k\bin\jar cf SQL310170502183 10.jar
PROCEDURE3. class
DB2INST1.PR OCEDURE3 - Jar file created.
Call sqlj.install_ja r ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
'"DB2INST1" .SQL31017050218 310', 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. SQLSTATE=58004

DB2INST1.PR OCEDURE3 - Build failed.
DB2INST1.PR OCEDURE3 - Roll back completed successfully.
Now is is just a case of the created jar file not getting to the
server? The aboe almost looks as if sqlj.install_ja r on the linux box
is trying to access a jar file on the windoze platform

While I *could* do all this from a cli on the linux box, it does seem
a bit easier to use the development centre.

Trawling through the information centre I did find some comments about
setting up classpath ld_library_path etc and I think I have done that
o.k.

Any help appreciated

Alex


Nov 12 '05 #6
Well managed to get it working,
The problem was that the UDF couldn't find the activation.jar file.
Once I'd modified the CLASSPATH statement configured in db2profile and
restarted the instance it all worked.

Having said that, I thought that you either had to register the
referenced jar files via the call sqlj.install_ja r command or add them
to the classpath statement and not both - or do I have to add an entry
to the classpath statement for "<instanceh ome>/sqllib/function/jar" if
i use the call command mentioned above?

Sean McKeough <mc******@nospa m.ca.ibm.com> wrote in message news:<bq******* **@hanover.toro lab.ibm.com>...
4302 often means either a java config problem, or a routine signature
mismatch. You might want to up your diaglevel to 4, and try invoking the
udf on its own...something useful might show up in the diag.

Alex wrote:
Well now got a setup where I can add stored procedures and user
defined functions and define a trigger ( It's actually from an article
in the DB2 magazine Volume 8 number 4 "Combining Triggers and UDFs" )

The problem is that now when i try and execute an SQL command to run
the trigger which should run the UDF I get :-

db2 => update booktable set quantity=8 where isbn=446310786
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0723N An error occurred in a triggered SQL statement in trigger
"DB2INST1.TABLE TR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RESUP PLY|SQL03120114 4832600|java". SQLSTATE=09000
db2 =>

Any help appreciated

Alex
A.******@hull.a c.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Anothe update

Hi all,

Well, on a test server i've managed to get some java stored procedures
into the system.

The small problem is that the system I want to do this on is currently
running either j2sdk1.4.0_01 or a JVM called jrockit by a company
called bea systems.

Is anyone running a different jdk to the one supplied in
/opt/IBMJava2-131 ?
Alex

A.******@hull .ac.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...

Just an update.

I've trawled the ibm site and found various documents on setting up
a Java environment on a linux system and *think* I've got the
path,classpa th and ld_library_path variables set up correctly.

This time I've uploaded a jar file into /usr/local/java/lib called
mail.jar and am trying to run call
sqlj.install _jar('file:/usr/local/java/lib/mail.jar','MAIL JAR')

having connected to the sample database

I unfortunately get the same error as before i.e. SQL1042C and
SQLSTATE 58004

Is ther any form of additional logging i can enable to find out
exactly what is going on when i run the sqlj.install_ja r procedure?

TIA
Alex
A.******@hul l.ac.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...

>Hi all,
>I am trying to install a java stored procedure via the windows
>developme nt centre.
>
>The linux box is running 8.1 FP4 as is the windoze platform. If I am
>on the linux box i can install the sample jdbc stored procedures o.k.
>
>For the purpose of this test I created a sample procedure that
>executes "select * from department" when conected to the sample
>database on the linux box.
>
>The connection to the server works o.k. but when it tries to
>build/install the stored procedure I get :-
>
>DB2INST1.PR OCEDURE3 - Build started.
>C:\PROGRA~1 \SQLLIB\java\jd k\bin\javac -classpath
>".;C:\PROGR A~1\SQLLIB\java \db2java.zip;C: \PROGRA~1\SQLLI B\java\runtime. zip;C:\PROGRA~1 \SQLLIB\java\sq lj.zip"
>"PROCEDURE3 .java"
>DB2INST1.PR OCEDURE3 - Javac completed.
>C:\PROGRA~1 \SQLLIB\java\jd k\bin\jar cf SQL310170502183 10.jar
>PROCEDURE3. class
>DB2INST1.PR OCEDURE3 - Jar file created.
>Call sqlj.install_ja r ('file:///C|/Documents and
>Settings/alex/Application
>Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
>'"DB2INST1" .SQL31017050218 310', 0)
>[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
>occurred. SQLSTATE=58004
>
>DB2INST1.PR OCEDURE3 - Build failed.
>DB2INST1.PR OCEDURE3 - Roll back completed successfully.
>
>
>Now is is just a case of the created jar file not getting to the
>server? The aboe almost looks as if sqlj.install_ja r on the linux box
>is trying to access a jar file on the windoze platform
>
>While I *could* do all this from a cli on the linux box, it does seem
>a bit easier to use the development centre.
>
>Trawling through the information centre I did find some comments about
>setting up classpath ld_library_path etc and I think I have done that
>o.k.
>
>Any help appreciated
>
>Alex

Nov 12 '05 #7
I think that dependent jars must be in the classpath...we only modify
the classpath used for load to include the jar containing the sp that's
being invoked.

Alex wrote:
Well managed to get it working,
The problem was that the UDF couldn't find the activation.jar file.
Once I'd modified the CLASSPATH statement configured in db2profile and
restarted the instance it all worked.

Having said that, I thought that you either had to register the
referenced jar files via the call sqlj.install_ja r command or add them
to the classpath statement and not both - or do I have to add an entry
to the classpath statement for "<instanceh ome>/sqllib/function/jar" if
i use the call command mentioned above?

Sean McKeough <mc******@nospa m.ca.ibm.com> wrote in message news:<bq******* **@hanover.toro lab.ibm.com>...
4302 often means either a java config problem, or a routine signature
mismatch. You might want to up your diaglevel to 4, and try invoking the
udf on its own...something useful might show up in the diag.

Alex wrote:

Well now got a setup where I can add stored procedures and user
defined functions and define a trigger ( It's actually from an article
in the DB2 magazine Volume 8 number 4 "Combining Triggers and UDFs" )

The problem is that now when i try and execute an SQL command to run
the trigger which should run the UDF I get :-

db2 => update booktable set quantity=8 where isbn=446310786
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0723N An error occurred in a triggered SQL statement in trigger
"DB2INST1.TA BLETR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RE SUPPLY|SQL03120 1144832600|java ". SQLSTATE=09000
db2 =>

Any help appreciated

Alex
A.******@hul l.ac.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
Anothe update

Hi all,

Well, on a test server i've managed to get some java stored procedures
into the system.

The small problem is that the system I want to do this on is currently
running either j2sdk1.4.0_01 or a JVM called jrockit by a company
called bea systems.

Is anyone running a different jdk to the one supplied in
/opt/IBMJava2-131 ?
Alex

A.******@hu ll.ac.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
>Just an update.
>
>I've trawled the ibm site and found various documents on setting up
>a Java environment on a linux system and *think* I've got the
>path,class path and ld_library_path variables set up correctly.
>
>This time I've uploaded a jar file into /usr/local/java/lib called
>mail.jar and am trying to run call
>sqlj.insta ll_jar('file:/usr/local/java/lib/mail.jar','MAIL JAR')
>
>having connected to the sample database
>
>I unfortunately get the same error as before i.e. SQL1042C and
>SQLSTATE 58004
>
>Is ther any form of additional logging i can enable to find out
>exactly what is going on when i run the sqlj.install_ja r procedure?
>
>TIA
>Alex
>
>
>A.******@h ull.ac.uk (Alex) wrote in message news:<b2******* *************** ****@posting.go ogle.com>...
>
>
>>Hi all,
>>I am trying to install a java stored procedure via the windows
>>developme nt centre.
>>
>>The linux box is running 8.1 FP4 as is the windoze platform. If I am
>>on the linux box i can install the sample jdbc stored procedures o.k.
>>
>>For the purpose of this test I created a sample procedure that
>>execute s "select * from department" when conected to the sample
>>databas e on the linux box.
>>
>>The connection to the server works o.k. but when it tries to
>>build/install the stored procedure I get :-
>>
>>DB2INST1. PROCEDURE3 - Build started.
>>C:\PROGRA ~1\SQLLIB\java\ jdk\bin\javac -classpath
>>".;C:\PRO GRA~1\SQLLIB\ja va\db2java.zip; C:\PROGRA~1\SQL LIB\java\runtim e.zip;C:\PROGRA ~1\SQLLIB\java\ sqlj.zip"
>>"PROCEDUR E3.java"
>>DB2INST1. PROCEDURE3 - Javac completed.
>>C:\PROGRA ~1\SQLLIB\java\ jdk\bin\jar cf SQL310170502183 10.jar
>>PROCEDURE 3.class
>>DB2INST1. PROCEDURE3 - Jar file created.
>>Call sqlj.install_ja r ('file:///C|/Documents and
>>Setting s/alex/Application
>>Data/IBM/DB2/DC/Projects/bld106908855825 6/SQL310170502183 10.jar',
>>'"DB2INST 1".SQL310170502 18310', 0)
>>[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
>>occurre d. SQLSTATE=58004
>>
>>DB2INST1. PROCEDURE3 - Build failed.
>>DB2INST1. PROCEDURE3 - Roll back completed successfully.
>>
>>
>>Now is is just a case of the created jar file not getting to the
>>server? The aboe almost looks as if sqlj.install_ja r on the linux box
>>is trying to access a jar file on the windoze platform
>>
>>While I *could* do all this from a cli on the linux box, it does seem
>>a bit easier to use the development centre.
>>
>>Trawlin g through the information centre I did find some comments about
>>setting up classpath ld_library_path etc and I think I have done that
>>o.k.
>>
>>Any help appreciated
>>
>>Alex


Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
1702
by: Beatrice Rutger | last post by:
Hi, I am a previous Micro$oft desertee (moved from VB/VC++ to Java before this whole DOTNET thing) because I had several issues with Micro$oft. I am not completely in love with Windoze, but I have to say that Java SWING sucks BIG TIME for developing and deploying desktop applications (especially on Windoze). Unfortunately, I have been dragged kicking and screaming back to my old haunts - but the landscape has changed somewhat and I...
0
1397
by: Sumit Gupta | last post by:
We are developing Java Stored Procedures using DB2 Development Center v8. While importing a stored procedure (.java file) from one database to another using the Development Center, all the java.lang.String type parameters defined inside the java file get converted to Character(32) type. Is there a way that we can specify that these should be converted to Varchar2(40) instead? Since we import Java Stored Procedures from one DB to another...
1
2581
by: Raquel | last post by:
Have a question on the Stored procedure method code generated by DB2 development center for Java stored procedures. Suppose I have a requirement to return the resultset consisting of FIRSTNME, LASTNAME of all employees belonging to a particular department, following is the stored procedure method code generated by "DB2 development center": public static void sproc3mtd ( String workdept, String firstnme,
1
2412
by: Alex | last post by:
Hi all, Just been dabbling with java stored procedures and I'm having problems replacing System: db2 8.1.4 on RH 7.1 linux system 1). Look at java jdbc samples as supplied with db2 and run the SpServer and Spclient progs against the default database SAMPLE. And everything works.
4
5831
by: Abram Friesen | last post by:
Hi all, I'm a newbie at DB2 and trying to create a simple java UDF. When I call my function, I'm receiving SQL4306N. Could someone please tell me what I'm doing wrong here? Here is my java code for a UDF that simply returns the integer value you pass it:
10
4386
by: Ed Stevens | last post by:
A tale of woe, and a question . . . Last week my boss said to me "we've installed DB2 Connect on this Solaris box. Make it work." Now, I've barely seen DB2 Connect on Windows, having fumbled thru one install and config, with a lot of handholding from IBM Support. I'm comfortable in unix but have never dealt with DB2 Connect there. (my main job is as an Oracle DBA, and most of my db's are on Solaris or AIX) I've found the install...
2
6993
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of attending interviews. If you own a company best way to judge if the candidate is worth of it. http://www.questpond.com/InterviewRatingSheet.zip
0
9999
marktang
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...
0
9849
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,...
0
10878
jinu1996
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...
0
10501
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
8049
isladogs
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...
0
7208
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();...
0
5894
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4308
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3324
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.