[TYPO3-dev] DBAL Usuage

[belbono]

Hey,
> 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.
>   
Just for in case - don't get me wrong: quoting attribut names is okay - 
like "TITLE" - quoting attributnames with its tablename as prefix is wrong
- like "TAB1"."TITLE" - ...correct would be TAB1."TITLE"

>   
>> 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?
>   
Because my development is done on a mysql database. I don't have access 
to the oracle DB from my place.
>   
>> 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.
>
>   
Alex