Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Phalcon on Oracle, double quotes in column names not working

Hi,

I am trying to use Phalcon 2.0.2 on Oracle 12c. I've installed Vokuro application and added debug log for SQL: Here is a raw SQL statement from model:

[Mon, 08 Jun 15 03:46:14 +0000][INFO] INSERT INTO "USERS" ("ID", "NAME", "EMAIL", "PASSWORD", "MUSTCHANGEPASSWORD", "PROFILESID", "BANNED", "SUSPENDED", "ACTIVE") VALUES (null, null, null, null, null, null, null, null, null) The problem is, that most likely Phalcon looks for capitalized propertiesin in Model Users.Otherwise I can not explain why they are all null.

I've tested my hypothesis and renamed column EMAIL in Oracle to "email" in a lowecase. This is a raw SQL for this:

[Mon, 08 Jun 15 04:03:43 +0000][INFO] INSERT INTO "USERS" ("ID", "NAME", "EMAIL", "PASSWORD", "MUSTCHANGEPASSWORD", "PROFILESID", "BANNED", "SUSPENDED", "ACTIVE") VALUES (null, null, ?, null, null, null, null, null, null)

Bind variable appeared, and it means, that hypothesis is right. Now, how can this be fixed?



891
Accepted
answer

I have found a solution through columnMap().