[Date Prev][Date Next] [Chronological] [Thread] [Top]

Back-sql and reserved words


I have a really annoying problem ; I use back-sql to connect to an
Oracle Database to map some data from my existing tables to posixAccount
objectclass. This results sooner or later in a query like this:

  SELECT users.name AS uid FROM users WHERE users.id=?

This does not work because of the 'AS uid' part, uid seems to be an
Oracle reserved keyword:

  SELECT 'hello' AS uid_ FROM dual;    -- this works
  SELECT 'hello' AS uid FROM DUAL;     -- this does not work :(

If it were my own objectClass I'd change the attribute name, but of 
course I cannot change posixAccount.

Did anyone else stumble across this?

University of Zurich, Centre for Computing Services 
Luzian Scherrer <lsc@zi.unizh.ch> 
Tel: +41 1 63 56778  Fax: +41 1 63 54505  Office: Y11-F-76