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.PROCEDURE3 - Build started.
C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PROGRA~1 \SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\java\s qlj.zip"
"PROCEDURE3.java"
DB2INST1.PROCEDURE3 - Javac completed.
C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
PROCEDURE3.class
DB2INST1.PROCEDURE3 - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
'"DB2INST1".SQL31017050218310', 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. 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_jar 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
7  3231  A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.PROCEDURE3 - Build started.
C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PROGRA~1 \SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\java\s qlj.zip"
"PROCEDURE3.java"
DB2INST1.PROCEDURE3 - Javac completed.
C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
PROCEDURE3.class
DB2INST1.PROCEDURE3 - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
'"DB2INST1".SQL31017050218310', 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. 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_jar 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
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_jar('file:/usr/local/java/lib/mail.jar','MAILJAR')
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_jar procedure?
TIA
Alex A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.PROCEDURE3 - Build started.
C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PROGRA~1 \SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\java\s qlj.zip"
"PROCEDURE3.java"
DB2INST1.PROCEDURE3 - Javac completed.
C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
PROCEDURE3.class
DB2INST1.PROCEDURE3 - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
'"DB2INST1".SQL31017050218310', 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. 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_jar 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
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.google. 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_jar('file:/usr/local/java/lib/mail.jar','MAILJAR')
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_jar procedure?
TIA
Alex
A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.PROCEDURE3 - Build started.
C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PROGRA~1 \SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\java\s qlj.zip"
"PROCEDURE3.java"
DB2INST1.PROCEDURE3 - Javac completed.
C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
PROCEDURE3.class
DB2INST1.PROCEDURE3 - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
'"DB2INST1".SQL31017050218310', 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. 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_jar 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
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.TABLETR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RESUPPLY|SQL031201144832600|java". SQLSTATE=09000
db2 =>
Any help appreciated
Alex A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.google. 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_jar('file:/usr/local/java/lib/mail.jar','MAILJAR')
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_jar procedure?
TIA
Alex
A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.PROCEDURE3 - Build started.
C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PROGRA~1 \SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\java\s qlj.zip"
"PROCEDURE3.java"
DB2INST1.PROCEDURE3 - Javac completed.
C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
PROCEDURE3.class
DB2INST1.PROCEDURE3 - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
'"DB2INST1".SQL31017050218310', 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. 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_jar 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
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.TABLETR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RESUPPLY|SQL031201144832600|java". SQLSTATE=09000
db2 =>
Any help appreciated
Alex
A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.google. 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_jar('file:/usr/local/java/lib/mail.jar','MAILJAR')
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_jar procedure?
TIA
Alex
A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.PROCEDURE3 - Build started.
C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PROG RA~1\SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\ja va\sqlj.zip"
"PROCEDURE3.java"
DB2INST1.PROCEDURE3 - Javac completed.
C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
PROCEDURE3.class
DB2INST1.PROCEDURE3 - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and
Settings/alex/Application
Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
'"DB2INST1".SQL31017050218310', 0)
[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
occurred. 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_jar 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
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_jar command or add them
to the classpath statement and not both - or do I have to add an entry
to the classpath statement for "<instancehome>/sqllib/function/jar" if
i use the call command mentioned above?
Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<bq*********@hanover.torolab.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.TABLETR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RESUPPLY|SQL031201144832600|java". SQLSTATE=09000
db2 =>
Any help appreciated
Alex
A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.google. 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_jar('file:/usr/local/java/lib/mail.jar','MAILJAR')
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_jar procedure?
TIA
Alex
A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.PROCEDURE3 - Build started.
>C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
>".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PROG RA~1\SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\ja va\sqlj.zip"
>"PROCEDURE3.java"
>DB2INST1.PROCEDURE3 - Javac completed.
>C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
>PROCEDURE3.class
>DB2INST1.PROCEDURE3 - Jar file created.
>Call sqlj.install_jar ('file:///C|/Documents and
>Settings/alex/Application
>Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
>'"DB2INST1".SQL31017050218310', 0)
>[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
>occurred. 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_jar 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
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_jar command or add them
to the classpath statement and not both - or do I have to add an entry
to the classpath statement for "<instancehome>/sqllib/function/jar" if
i use the call command mentioned above?
Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<bq*********@hanover.torolab.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.TABLETR". Information returned for the error includes
SQLCODE
"-4302", SQLSTATE "38501" and message tokens
"DB2INST1.RESUPPLY|SQL031201144832600|java". SQLSTATE=09000
db2 =>
Any help appreciated
Alex
A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.google. 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_jar('file:/usr/local/java/lib/mail.jar','MAILJAR')
>
>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_jar procedure?
>
>TIA
>Alex
>
>
>A.******@hull.ac.uk (Alex) wrote in message news:<b2**************************@posting.google. 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.PROCEDURE3 - Build started.
>>C:\PROGRA~1\SQLLIB\java\jdk\bin\javac -classpath
>>".;C:\PROGRA~1\SQLLIB\java\db2java.zip;C:\PR OGRA~1\SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\ java\sqlj.zip"
>>"PROCEDURE3.java"
>>DB2INST1.PROCEDURE3 - Javac completed.
>>C:\PROGRA~1\SQLLIB\java\jdk\bin\jar cf SQL31017050218310.jar
>>PROCEDURE3.class
>>DB2INST1.PROCEDURE3 - Jar file created.
>>Call sqlj.install_jar ('file:///C|/Documents and
>>Settings/alex/Application
>>Data/IBM/DB2/DC/Projects/bld1069088558256/SQL31017050218310.jar',
>>'"DB2INST1".SQL31017050218310', 0)
>>[IBM][CLI Driver][DB2/LINUX] SQL1042C An unexpected system error
>>occurred. 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_jar 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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...
|
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...
|
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,...
|
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...
|
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...
| | |
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...
|
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...
|
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,...
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| | |
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...
|
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 ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |
