Re: JDeveloper SQL92 Table Alias

From: William T. Mann <wtmann_at_linuxthinktank.org>
Date: Sat, 04 Dec 2004 14:32:49 +0100
Message-ID: <31dsk1F38r2jqU1_at_individual.net>


William T. Mann wrote:

> Hello everyone,
>
> I need to use JDeveloper 10g with a postgresql database. I'm making a fast
> and dirty Swing/ADF JClient and everything "seems" to work fine, until I
> try to update some data. I then get an error because JDeveloper is not
> using the (optional) AS keyword to alias the database tables. The AS
> keyword for postgresql is mandatory and there sits my problem. Is it
> possible to configure JDeveloper ADF framework to use the AS keyword when
> aliasing the tables somewhere? Has anyone else ran into this problem and
> solved it?

After further investigation, it seems that the problem happens when aliasing tables on the UPDATE clause, and possibly the INSERT and DELETE clauses. This gives an error in postgresql: 'UPDATE table Alias SET field1 = ?' -- you can't alias the table in this context; whereas, in the normal SELECT query, the AS keyword is optional as specified by the SQL92 standard. Any ideas?

William Received on Sat Dec 04 2004 - 14:32:49 CET

Original text of this message