JDeveloper SQL92 Table Alias

3 Dec 2004 12:07 PM

William T. Mann

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?

Thanks for any help.

William

4 Dec 2004 1:32 PM

William T. Mann

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