473,554 Members | 3,184 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1559

"esmith2112 " <es********@hot mail.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.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
3267
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 projects? Actually i'm intereseted in knowing to what extent java stored procedures are used in enterprise applications. A opensource project will...
7
3239
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 the sample jdbc stored procedures o.k. For the purpose of this test I created a sample procedure that executes "select * from department" when...
3
2789
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" when I launched the IBM Distributed Debugger via D:\IBMDebug>idebug.exe -qdaemon -quiport=8000,8001 First, a bit of background. I am running DB2...
1
1985
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 great help if any one help me in step-by-step guidelines to migrate SPs written in Java & C languages. I have successfully recreated SQL procedures.
1
2385
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.
2
9206
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 problems doing this. I wanted to implemented a generic "Helper" class like this: /** * Helper
8
11199
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 have an uninitialized variable, a 'dangling' pointer, or an expression that indexes an array beyond its bounds. Whole categories of bugs that...
2
6934
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
7589
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...
0
7516
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...
1
7551
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7881
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...
1
5428
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...
0
3550
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...
0
3539
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2012
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 we have to send another system
1
1121
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.