RE: SQL Statement giving me null pointer exception

Has conn been correctly initialized?

Dan Feather
Silhouette/PinPoint R&D Programmer
Jack Henry & Associates, Inc.
dfeather@xxxxxxxxxxxxx

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of RPower@xxxxxxxxxx
Sent: Friday, April 29, 2005 11:47 AM
To: Java Programming on and around the iSeries / AS400
Subject: SQL Statement giving me null pointer exception

Any ideas why this is failing?
getGarbageIdRecord = conn.prepareStatement("SELECT WGSCHDID, WGSTATUS, 
WGSDATE FROM PUBWRK.WGARSCHMST WHERE WGSCHDID = '7963535' FOR UPDATE OF 
WGSTATUS, WGSDATE");
It's returning [4/29/05 14:15:14:675 NDT]  4d804d8 SystemErr     R 
java.lang.NullPointerException
I've actually run that statement on the as/400 itself and it brings up
the 
correct row.  Am I doing something wrong?

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
________________________________________________________________________
___
Success is going from failure to failure without a loss of enthusiasm. -

Sir Winston Churchill
-- 
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.