473,289 Members | 2,089 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Java Store Procedures Help

We all of a sudden find ourselves in dire straits, because we have one
of those mysteries where everything used to work, and apparently, all
of a sudden everything went to pot just in time for a major software
release. All of our Java stored procedures have developed some bad
behavior and we've exhausted our resources in figuring this out.

Symptoms:

1. Store procedures have stopped returning result sets. Whereas before,
it would return the column headers with zero rows returned, it now
returns the message: No results returned from the stored procedure.
It's as if the proc is never actually executing the query.

2. Procedures have started to complain that that they've never heard of
various objects. We get SQL0204 errors saying that a nickname (that for
sure exists) is undefined.
I turn to the group because we have been unable to upgrade to the
current release of DB2 software due to legacy compatibility issues and
find ourselves out of support. I've tried the archives for the group
and lots of web searches with no definitive hits. If anyone has any
clue I'd love to hear from you

Environment:

DB2 7.2 FP 11
AIX 4.3
Federated database with 2 servers defined.
Thanks in advance,
Evan

Nov 12 '05 #1
1 1543

"esmith2112" <es********@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
We all of a sudden find ourselves in dire straits, because we have one
of those mysteries where everything used to work, and apparently, all
of a sudden everything went to pot just in time for a major software
release. All of our Java stored procedures have developed some bad
behavior and we've exhausted our resources in figuring this out.

Symptoms:

1. Store procedures have stopped returning result sets. Whereas before,
it would return the column headers with zero rows returned, it now
returns the message: No results returned from the stored procedure.
It's as if the proc is never actually executing the query.

2. Procedures have started to complain that that they've never heard of
various objects. We get SQL0204 errors saying that a nickname (that for
sure exists) is undefined.
I turn to the group because we have been unable to upgrade to the
current release of DB2 software due to legacy compatibility issues and
find ourselves out of support. I've tried the archives for the group
and lots of web searches with no definitive hits. If anyone has any
clue I'd love to hear from you

Environment:

DB2 7.2 FP 11
AIX 4.3
Federated database with 2 servers defined.
Thanks in advance,
Evan

The only way to be really sure about what is happening is to examine at
least one or two of the stored procedures thoroughly. Make sure that the
tables they are trying to read actually exist; it's not enough to assume
they exist because you don't remember explicitly dropping them. Make sure
that the desired tables actually contain the rows you expect to return from
the stored procedure; perhaps someone (inadvertently?) deleted the rows you
expected to find.

Run the code in the Java stored procedure debugger and step through it a
statement at a time, making sure that every statement does what it should
do. I think you will soon see exactly what is wrong if you take this
approach. Now, that's assuming that you can get the debugger to work; I
never had much luck with it in DB2 V7.2. However, if you can't get it to
work, remember that
Java stored procedures cannot do screen I/O but they _can_ do file I/O. I
found it very educational to write lines to an external flat file to debug
my programs. It's not as convenient as a proper online debugger but it
works.

Good luck!

Rhino
Nov 12 '05 #2

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

Similar topics

1
by: Suresh Tri | last post by:
Hi all, I am in search of any Enterprise level Opensource Project that uses Java Stored Procedures supported by Oracle. I could not find any by googling. Can any one plese point me to any such...
7
by: Alex | last post by:
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...
3
by: Rhino | last post by:
I've spent the last couple of hours trying to figure out how to debug a Java stored procedure and am just going in circles. The last straw came when I got "Cannot open input stream for default"...
1
by: Kumar | last post by:
Hi I am trying to recreate a database under the following environments : From: Solaris with DB2UDB version 7.2 with FP 9 To: Linux with DB2UDB version 7.2 with FP 9 It will be of really a...
1
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...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
8
by: Michael A. Covington | last post by:
Has anyone made any tests they'd like to tell me about? -- Michael A. Covington - Artificial Intelligence Ctr - University of Georgia "In the core C# language it is simply not possible to...
2
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

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.