RE: JDBC SQL problem

[Colin Williams <colin.williams@xxxxxxxxxxxx>]

Glenn,

You are running your JDBC connection with naming set to SYS, but you are
using SQL naming in your SQL statement.

SYS naming uses /
SQL naming uses .

Set the naming property on your JDBC URL to the one you are using

Cheers
Colin.W

-----Original Message-----
From: Glenn Holmer [mailto:gholmer@xxxxxxxxxxxxxx] 
Sent: 02 December 2003 14:43
To: java400-l@xxxxxxxxxxxx
Subject: JDBC SQL problem


I'm building an SQL statement programmatically and running it against a V5R2
AS/400 (running Java 1.4.1) from a rich client running on a PC. I'm getting
an error I don't understand.  Here's the SQL as the NetBeans debugger traps
it:

SELECT DISTINCT WIPFPD.WPWIP, WIPFPH.WPEDT
FROM ACSDBASE2.WIPFPH, ACSDBASE2.WIPFPD
WHERE WPDVN LIKE 'JI%' AND WPSTG = 3 AND WPUNT > 0
ORDER BY WPEDT DESC

I get the error "[SQL5001] Column qualifier or table WIPFPD undefined." But
if I cut 'n' paste that same SQL into STRSQL in a 5250 terminal (changing
lib.file to lib/file), it runs just fine.  

Anybody have any ideas why that might be?

-- 
____________________________________________________________
Glenn Holmer                          gholmer@xxxxxxxxxxxxxx
Programmer/Analyst                       phone: 414.908.1809
Weyco Group, Inc.                          fax: 414.908.1601

_______________________________________________
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.

For the latest on Bertram Books products and services and for up-to-the-minute 
book news visit www.bertrams.com


This e-mail and any attachments may contain information that is confidential 
and privileged and is solely for the use of the intended recipient. If you are 
not the intended recipient please notify the sender and delete this e-mail and 
any attachments immediately