[symfony-users] Re: Oracle and table names

Fri, 17 Aug 2007 07:50:36 -0700

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
-~----------~----~----~----~------~----~------~--~---

Reply via email to