[symfony-users] Re: Oracle and table names

[Jony dos Santos Kostetzer]

Charley, It works perfectly! Thank you for your reply =} Jony dos Santos Kostetzer | Linux user #392481 Charley Tiggs escreveu: 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 symfony-users@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---