All Questions
Tagged with java-stored-procedures db2
10 questions
0
votes
2
answers
656
views
DB2 stored procedure to run multiple insert & update SQL statements using List array from Java application
I want to use a DB2 stored procedure to run multi insert & update SQL statements from my Java application. I have prepared below procedure that contains error.
In this implementation, I first want ...
0
votes
2
answers
493
views
calling sqlj.install_jar from jdbc?
I have a python snippet that I try to port to java. The aim is Gradle but I could not get that to work, so I figured I would start with plain JDBC. The python code looks like this:
import argparse
...
- 7,191
0
votes
2
answers
1k
views
DB2 external java jar file stored procedure error
I have been trying to call a java jar file from DB2 stored procedure as external jar.
Below is my external jar file code.
package connection;
public class Connect {
static Connection con =...
- 11
0
votes
1
answer
2k
views
Java Stored Procedure DB2 issue
In my class I have created simple method below. This class also has a main function in it. I am calling getRes() from my DB2 stored proc.
public static void getRes() {
System.out.println("Start");...
- 33
0
votes
1
answer
274
views
How to drop DB2 Java Stored Procedure?
I have deployed a Java Stored Procedure through IBM Data Studio, and now I want to undeploy it, but I don't know how to do it completely.
I know you have to drop the procedure by calling DROP ...
- 432
0
votes
0
answers
593
views
How to resolve exception attempting to load java class in DB2 Java Stored procedure?
I have created Java.sqlj program and done with creating packages and jar, when attempting to call the procedure, facing the error like
ATTEMPTING TO LOAD JAVA CLASS s1.S1Sal ...
-1
votes
1
answer
2k
views
SQL4306N Java stored procedure or user-defined function could not call Java method
We just upgraded to DB2 10.5 from 9.5, this process was working fine until the upgrade was performed on the server. When i run the jar file from a linux server, I get the following error however when ...
- 581
0
votes
1
answer
1k
views
Syntax Error While Calling DB2 Stored Procedure Through JMeter
I am trying to call a DB2 Stored Procedure which has two Input parameters (Timestamp, both) and one Output parameter (Integer). I am trying to do so from JMeter JDBC Sampler and getting sql syntax ...
- 90
0
votes
2
answers
582
views
ERROR in DB2 stored procedure
What is wrong with following stored procedure?
CREATE PROCEDURE TEST
(IN mbr VARCHAR(30),
OUT sql_state CHAR(5)
)
DYNAMIC RESULT SETS 1 LANGUAGE SQL BEGIN DECLARE SQLSTATE CHAR(5);
...
- 1,299
4
votes
1
answer
1k
views
Bundling Java libraries with a DB2 Java stored procedure
Creating a DB2 Java stored procedure using IBM Data Studio, I have some libraries that are required in the classpath.
I'm running Data Studio in a VM, and deploying remotely to my DB2 server in a ...
- 18.3k