[TYPO3-dev] DBAL Usuage

[Martin Kutschker]

belbono schrieb:
> Hi,
> 
> Martin Kutschker wrote:
>> belbono schrieb:
>>  
>>> Hi Martin,
>>>
>>>
>>> bad news brackets doesn't work.
>>> If I give something like
>>>
>>> 'FROM PUBLICATIONS INNER JOIN ARTICLE ON (PUBLICATIONS.UID_ = 
>>> ARTICLE.PUBLICATIONS_UID) '
>>>
>>> to DBAL I get an Error saying that there is no handler found and no 
>>> join clause and other things...
>>>     
>>
>> Could be that DBAL supports currently join condiitons only with OUTER 
>> JOINS.
>>
>> But I still think that it is an error to use upper case table names 
>> unless they are spelled as such in the table definition.
>>   
> That's right. Since Oracle accepts only tablenames in uppercase, I´m 
> only allowed to use those.

In thise case DBAL should do the conversion.

>>
>> The generated code is IMHO perfectly wrong. Why do you think that the 
>> quoting is incorrect?
>>   
> Quoting the tablenames is wrong since you get an error when using such a 
> statement in a program like oracle's SQL-Developer.
> Remove the quotes on the tablename and everything is fine...

Strange. Quotes are ANSI SQL and I don't think Oracle deviates here.

> Yes, I could use AdoDB directly ... But I wanted it to be compatible 
> with MySQL, because I don't really think an Oracle DB is necessary for 
> my plugin- But unfortunately that's not my decision...

Go even further and use the Oracle API directly. Why mess with an 
abstraction layer you don't need?

> The other thing, is when using tablenames that are compatible with typo3 
> I may get problems with oracle again, because it limits the length of 
> tablenames.

When you use DBAL you can use it's mapping feature.

Masi