Can you not, within config/propel.ini add the following line: propel.disableIdentifierQuoting = true
While I don't use Oracle, adding this line to my propel.ini got rid of the double quotes. Charley Jony dos Santos Kostetzer wrote: > Hi! > > That's exactly what I'm doing to solve this issue. > After every code generation, I'm replacing those double quotes.. > > Annoying, isn't it? but works ;-} > Thank you! > > Jony dos Santos Kostetzer > | Linux user #392481 > > > > j0k3r escreveu: >> Hi, >> >> I got the same problem. I use doctrine but i think it is the same >> problem. >> >> If you use the generated sql code, Oracle will create the table with >> the name in lowercase ONLY. And after you got some problem to work >> with. >> The solution i found is to change the generated code. >> >> You have : >> CREATE TABLE "state" >> >> Replace by : >> CREATE TABLE state >> >> Hope this can help you :-) >> >> >> On 6 août, 19:29, Jony dos Santos Kostetzer <[EMAIL PROTECTED]> wrote: >> >>> Hi, >>> >>> I'm using Symfony + Oracle and I'm having problems with case sensitive >>> table/field names. For example, the generated SQL is: >>> >>> CREATE TABLE "state" >>> ( >>> "id" NUMBER NOT NULL, >>> "name" VARCHAR2(50), >>> ); >>> >>> But every query (built with Peer classes) using Propel fails, such as: >>> >>> SELECT id FROM state >>> >>> But these queries work (manually tested): >>> >>> SELECT "id" FROM "state" >>> SELECT "ID" FROM "STATE" >>> SELECT ID FROM STATE >>> >>> Is there any way to solve this problem? >>> >>> Thanks! >>> >>> -- >>> Jony dos Santos Kostetzer >>> | Linux user #392481 >>> >> >> >> >> >> > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
