RE: JDBC SQL problem

["Richard Casey" <casey_r@xxxxxxxxxxxxxxxx>]

Glenn,

You can change things so your JDBC statements run with SQL naming by
specifying "naming=sql" when you create your JDBC connection.

        Connection con =
DriverManager.getConnection("jdbc:as400://system;naming=sql","userid","passw
ord");

That way you should be able to leave the SQL statements alone.

Hope this helps!
Richard


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Glenn Holmer
Sent: Tuesday, December 02, 2003 11:06 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: JDBC SQL problem


Colin Williams wrote:
> 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

OK, I found how to do that and it works, but that means changing
all the other SQL in this program.  Is there a way to correct the
syntax so that it runs with sql naming?

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

[SQL5001] Column qualifier or table WIPFPH undefined.

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