The database is a Sybase ASA which is largely compatible with Sybase ASE
and even MS SQL Server.
I use com.webobjects.jdbcadaptor.SybasePlugIn and
com.sybase.jdbc2.jdbc.SybDriver (jConnect).
If I explicitly write "precison" in Entity Modeler it gets written as
"\"precision\"" in the plist - and this works. I just don't think I
should have to do this. Are you saying that with other EOF plugins this
is not a problem? Never knew. For years I worked around these kind of
problems by avoiding some names and/or qouting names in Entity Modeler.
/Anders
Chuck Hill wrote:
>
> On Nov 27, 2008, at 1:48 AM, Anders Peterson wrote:
>
>> Hi all,
>>
>> I sometimes get problems with unfortunate column names when querying
>> the database.
>> Today the problem is the word "precision".
>>
>> If column names are written as quoted values everything works just
>> fine - the query
>> sent to the database should contain the quotes.
>>
>> Looking in my plists I see that some column names are quoted and
>> others are not (in
>> the same plist/entity), and this seems to have nothing to do with
>> what is sent to the db.
>> If I explicitly add the quotes in Entity Modeler it gets written as
>> "\"precision\"".
>>
>> Is there some way for me to force all table/view/column names
>> communicated to my
>> database to be quoted - perhaps a property I can set some where?
>>
>> (eclipse 3.3.2, stable WOLips, WO 5.3.3)
>>
>> /Anders
>
> Which database? The database plugin for EOF should control this.
>
> Chuck
>
>
This archive was generated by hypermail 2.0.0 : Fri Nov 28 2008 - 02:49:14 EST