You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@empire-db.apache.org by Frank Lupo <fr...@email.it> on 2009/03/27 10:10:09 UTC
postgresql reseved keyword
Hi,
in DBDatabaseDriverPostgreSQL add the reserved keyword
see
http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html
/**
* Constructor for the PostgreSQL database driver.<br>
*/
public DBDatabaseDriverPostgreSQL() {
// Default Constructor
// list of reserved keywords
//
http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html
reservedSQLKeywords.add("ALL".toLowerCase());
reservedSQLKeywords.add("ANALYSE".toLowerCase());
reservedSQLKeywords.add("ANALYZE".toLowerCase());
reservedSQLKeywords.add("AND".toLowerCase());
reservedSQLKeywords.add("ANY".toLowerCase());
reservedSQLKeywords.add("ARRAY".toLowerCase());
reservedSQLKeywords.add("AS".toLowerCase());
reservedSQLKeywords.add("ASC".toLowerCase());
reservedSQLKeywords.add("ASYMMETRIC".toLowerCase());
reservedSQLKeywords.add("AUTHORIZATION".toLowerCase());
reservedSQLKeywords.add("BETWEEN".toLowerCase());
reservedSQLKeywords.add("BINARY".toLowerCase());
reservedSQLKeywords.add("BOTH".toLowerCase());
reservedSQLKeywords.add("CASE".toLowerCase());
reservedSQLKeywords.add("CAST".toLowerCase());
reservedSQLKeywords.add("CHECK".toLowerCase());
reservedSQLKeywords.add("COLLATE".toLowerCase());
reservedSQLKeywords.add("COLUMN".toLowerCase());
reservedSQLKeywords.add("CONSTRAINT".toLowerCase());
reservedSQLKeywords.add("CREATE".toLowerCase());
reservedSQLKeywords.add("CROSS".toLowerCase());
reservedSQLKeywords.add("CURRENT_DATE".toLowerCase());
reservedSQLKeywords.add("CURRENT_ROLE".toLowerCase());
reservedSQLKeywords.add("CURRENT_TIME".toLowerCase());
reservedSQLKeywords.add("CURRENT_TIMESTAMP".toLowerCase());
reservedSQLKeywords.add("CURRENT_USER".toLowerCase());
reservedSQLKeywords.add("DEFAULT".toLowerCase());
reservedSQLKeywords.add("DEFERRABLE".toLowerCase());
reservedSQLKeywords.add("DESC".toLowerCase());
reservedSQLKeywords.add("DISTINCT".toLowerCase());
reservedSQLKeywords.add("DO".toLowerCase());
reservedSQLKeywords.add("ELSE".toLowerCase());
reservedSQLKeywords.add("END".toLowerCase());
reservedSQLKeywords.add("EXCEPT".toLowerCase());
reservedSQLKeywords.add("FALSE".toLowerCase());
reservedSQLKeywords.add("FOR".toLowerCase());
reservedSQLKeywords.add("FOREIGN".toLowerCase());
reservedSQLKeywords.add("FREEZE".toLowerCase());
reservedSQLKeywords.add("FROM".toLowerCase());
reservedSQLKeywords.add("FULL".toLowerCase());
reservedSQLKeywords.add("GRANT".toLowerCase());
reservedSQLKeywords.add("GROUP".toLowerCase());
reservedSQLKeywords.add("HAVING".toLowerCase());
reservedSQLKeywords.add("ILIKE".toLowerCase());
reservedSQLKeywords.add("IN".toLowerCase());
reservedSQLKeywords.add("INITIALLY".toLowerCase());
reservedSQLKeywords.add("INNER".toLowerCase());
reservedSQLKeywords.add("INTERSECT".toLowerCase());
reservedSQLKeywords.add("INTO".toLowerCase());
reservedSQLKeywords.add("IS".toLowerCase());
reservedSQLKeywords.add("ISNULL".toLowerCase());
reservedSQLKeywords.add("JOIN".toLowerCase());
reservedSQLKeywords.add("LEADING".toLowerCase());
reservedSQLKeywords.add("LEFT".toLowerCase());
reservedSQLKeywords.add("LIKE".toLowerCase());
reservedSQLKeywords.add("LIMIT".toLowerCase());
reservedSQLKeywords.add("LOCALTIME".toLowerCase());
reservedSQLKeywords.add("LOCALTIMESTAMP".toLowerCase());
reservedSQLKeywords.add("NATURAL".toLowerCase());
reservedSQLKeywords.add("NEW".toLowerCase());
reservedSQLKeywords.add("NOT".toLowerCase());
reservedSQLKeywords.add("NOTNULL".toLowerCase());
reservedSQLKeywords.add("NULL".toLowerCase());
reservedSQLKeywords.add("OFF".toLowerCase());
reservedSQLKeywords.add("OFFSET".toLowerCase());
reservedSQLKeywords.add("OLD".toLowerCase());
reservedSQLKeywords.add("ON".toLowerCase());
reservedSQLKeywords.add("ONLY".toLowerCase());
reservedSQLKeywords.add("OR".toLowerCase());
reservedSQLKeywords.add("ORDER".toLowerCase());
reservedSQLKeywords.add("OUTER".toLowerCase());
reservedSQLKeywords.add("OVERLAPS".toLowerCase());
reservedSQLKeywords.add("PLACING".toLowerCase());
reservedSQLKeywords.add("PRIMARY".toLowerCase());
reservedSQLKeywords.add("REFERENCES".toLowerCase());
reservedSQLKeywords.add("RETURNING".toLowerCase());
reservedSQLKeywords.add("RIGHT".toLowerCase());
reservedSQLKeywords.add("SELECT".toLowerCase());
reservedSQLKeywords.add("SESSION_USER".toLowerCase());
reservedSQLKeywords.add("SIMILAR".toLowerCase());
reservedSQLKeywords.add("SOME".toLowerCase());
reservedSQLKeywords.add("SYMMETRIC".toLowerCase());
reservedSQLKeywords.add("TABLE".toLowerCase());
reservedSQLKeywords.add("THEN".toLowerCase());
reservedSQLKeywords.add("TO".toLowerCase());
reservedSQLKeywords.add("TRAILING".toLowerCase());
reservedSQLKeywords.add("TRUE".toLowerCase());
reservedSQLKeywords.add("UNION".toLowerCase());
reservedSQLKeywords.add("UNIQUE".toLowerCase());
reservedSQLKeywords.add("USER".toLowerCase());
reservedSQLKeywords.add("USING".toLowerCase());
reservedSQLKeywords.add("VERBOSE".toLowerCase());
reservedSQLKeywords.add("WHEN".toLowerCase());
reservedSQLKeywords.add("WHERE".toLowerCase());
reservedSQLKeywords.add("WITH".toLowerCase());
}
thanks
--
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f
Sponsor:
Con Poker Club anche a Marzo il montepremi è garantito: ogni lunedì, giovedì e domenica vinci fino a 25.000!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8806&d=27-3
Re: postgresql reseved keyword
Posted by Francis De Brabandere <fr...@gmail.com>.
added to previous issue for the postgre driver:
https://issues.apache.org/jira/browse/EMPIREDB-37
On Fri, Mar 27, 2009 at 10:10 AM, Frank Lupo <fr...@email.it> wrote:
> Hi,
> in DBDatabaseDriverPostgreSQL add the reserved keyword
> see
> http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html
>
> /**
> * Constructor for the PostgreSQL database driver.<br>
> */
> public DBDatabaseDriverPostgreSQL() {
> // Default Constructor
>
> // list of reserved keywords
> //
> http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html
> reservedSQLKeywords.add("ALL".toLowerCase());
> reservedSQLKeywords.add("ANALYSE".toLowerCase());
> reservedSQLKeywords.add("ANALYZE".toLowerCase());
> reservedSQLKeywords.add("AND".toLowerCase());
> reservedSQLKeywords.add("ANY".toLowerCase());
> reservedSQLKeywords.add("ARRAY".toLowerCase());
> reservedSQLKeywords.add("AS".toLowerCase());
> reservedSQLKeywords.add("ASC".toLowerCase());
> reservedSQLKeywords.add("ASYMMETRIC".toLowerCase());
> reservedSQLKeywords.add("AUTHORIZATION".toLowerCase());
> reservedSQLKeywords.add("BETWEEN".toLowerCase());
> reservedSQLKeywords.add("BINARY".toLowerCase());
> reservedSQLKeywords.add("BOTH".toLowerCase());
> reservedSQLKeywords.add("CASE".toLowerCase());
> reservedSQLKeywords.add("CAST".toLowerCase());
> reservedSQLKeywords.add("CHECK".toLowerCase());
> reservedSQLKeywords.add("COLLATE".toLowerCase());
> reservedSQLKeywords.add("COLUMN".toLowerCase());
> reservedSQLKeywords.add("CONSTRAINT".toLowerCase());
> reservedSQLKeywords.add("CREATE".toLowerCase());
> reservedSQLKeywords.add("CROSS".toLowerCase());
> reservedSQLKeywords.add("CURRENT_DATE".toLowerCase());
> reservedSQLKeywords.add("CURRENT_ROLE".toLowerCase());
> reservedSQLKeywords.add("CURRENT_TIME".toLowerCase());
> reservedSQLKeywords.add("CURRENT_TIMESTAMP".toLowerCase());
> reservedSQLKeywords.add("CURRENT_USER".toLowerCase());
> reservedSQLKeywords.add("DEFAULT".toLowerCase());
> reservedSQLKeywords.add("DEFERRABLE".toLowerCase());
> reservedSQLKeywords.add("DESC".toLowerCase());
> reservedSQLKeywords.add("DISTINCT".toLowerCase());
> reservedSQLKeywords.add("DO".toLowerCase());
> reservedSQLKeywords.add("ELSE".toLowerCase());
> reservedSQLKeywords.add("END".toLowerCase());
> reservedSQLKeywords.add("EXCEPT".toLowerCase());
> reservedSQLKeywords.add("FALSE".toLowerCase());
> reservedSQLKeywords.add("FOR".toLowerCase());
> reservedSQLKeywords.add("FOREIGN".toLowerCase());
> reservedSQLKeywords.add("FREEZE".toLowerCase());
> reservedSQLKeywords.add("FROM".toLowerCase());
> reservedSQLKeywords.add("FULL".toLowerCase());
> reservedSQLKeywords.add("GRANT".toLowerCase());
> reservedSQLKeywords.add("GROUP".toLowerCase());
> reservedSQLKeywords.add("HAVING".toLowerCase());
> reservedSQLKeywords.add("ILIKE".toLowerCase());
> reservedSQLKeywords.add("IN".toLowerCase());
> reservedSQLKeywords.add("INITIALLY".toLowerCase());
> reservedSQLKeywords.add("INNER".toLowerCase());
> reservedSQLKeywords.add("INTERSECT".toLowerCase());
> reservedSQLKeywords.add("INTO".toLowerCase());
> reservedSQLKeywords.add("IS".toLowerCase());
> reservedSQLKeywords.add("ISNULL".toLowerCase());
> reservedSQLKeywords.add("JOIN".toLowerCase());
> reservedSQLKeywords.add("LEADING".toLowerCase());
> reservedSQLKeywords.add("LEFT".toLowerCase());
> reservedSQLKeywords.add("LIKE".toLowerCase());
> reservedSQLKeywords.add("LIMIT".toLowerCase());
> reservedSQLKeywords.add("LOCALTIME".toLowerCase());
> reservedSQLKeywords.add("LOCALTIMESTAMP".toLowerCase());
> reservedSQLKeywords.add("NATURAL".toLowerCase());
> reservedSQLKeywords.add("NEW".toLowerCase());
> reservedSQLKeywords.add("NOT".toLowerCase());
> reservedSQLKeywords.add("NOTNULL".toLowerCase());
> reservedSQLKeywords.add("NULL".toLowerCase());
> reservedSQLKeywords.add("OFF".toLowerCase());
> reservedSQLKeywords.add("OFFSET".toLowerCase());
> reservedSQLKeywords.add("OLD".toLowerCase());
> reservedSQLKeywords.add("ON".toLowerCase());
> reservedSQLKeywords.add("ONLY".toLowerCase());
> reservedSQLKeywords.add("OR".toLowerCase());
> reservedSQLKeywords.add("ORDER".toLowerCase());
> reservedSQLKeywords.add("OUTER".toLowerCase());
> reservedSQLKeywords.add("OVERLAPS".toLowerCase());
> reservedSQLKeywords.add("PLACING".toLowerCase());
> reservedSQLKeywords.add("PRIMARY".toLowerCase());
> reservedSQLKeywords.add("REFERENCES".toLowerCase());
> reservedSQLKeywords.add("RETURNING".toLowerCase());
> reservedSQLKeywords.add("RIGHT".toLowerCase());
> reservedSQLKeywords.add("SELECT".toLowerCase());
> reservedSQLKeywords.add("SESSION_USER".toLowerCase());
> reservedSQLKeywords.add("SIMILAR".toLowerCase());
> reservedSQLKeywords.add("SOME".toLowerCase());
> reservedSQLKeywords.add("SYMMETRIC".toLowerCase());
> reservedSQLKeywords.add("TABLE".toLowerCase());
> reservedSQLKeywords.add("THEN".toLowerCase());
> reservedSQLKeywords.add("TO".toLowerCase());
> reservedSQLKeywords.add("TRAILING".toLowerCase());
> reservedSQLKeywords.add("TRUE".toLowerCase());
> reservedSQLKeywords.add("UNION".toLowerCase());
> reservedSQLKeywords.add("UNIQUE".toLowerCase());
> reservedSQLKeywords.add("USER".toLowerCase());
> reservedSQLKeywords.add("USING".toLowerCase());
> reservedSQLKeywords.add("VERBOSE".toLowerCase());
> reservedSQLKeywords.add("WHEN".toLowerCase());
> reservedSQLKeywords.add("WHERE".toLowerCase());
> reservedSQLKeywords.add("WITH".toLowerCase());
> }
>
> thanks
>
>
> --
> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
> autenticato? GRATIS solo con Email.it http://www.email.it/f
>
> Sponsor:
> Con Poker Club anche a Marzo il montepremi è garantito: ogni lunedì, giovedì
> e domenica vinci fino a 25.000 !
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8806&d=27-3
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.