Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error while saving many to many association in oracle #85

Open
harishchander67 opened this issue Jul 27, 2013 · 3 comments
Open

Error while saving many to many association in oracle #85

harishchander67 opened this issue Jul 27, 2013 · 3 comments

Comments

@harishchander67
Copy link

While saving associations this SQL is generated for oracle:
INSERT INTO amg_user_interest ("amg_user_id","interest_id") VALUES (1234602,1)

It happens due to escaping of values in driver.js (line 45) that generate " in the column names.

Changing this function in oracle.js (changed return '"' + columnName + '"';
to return columnName;

escapeColumnName: function (columnName) {
//return '"' + columnName + '"';
return columnName;
}

Error:
Error starting at line 25 in command:
INSERT INTO amg_user_interest ("amg_user_id","interest_id") VALUES (1234602,1)
Error at Command Line:25 Column:45
Error report:
SQL Error: ORA-00904: "interest_id": invalid identifier
00904. 00000 - "%s: invalid identifier"

@zorrofox
Copy link
Contributor

zorrofox commented Aug 8, 2013

This issue may just like the #73 and has been resolved. You can update the repo and try again.

@harishchander67
Copy link
Author

That did not help. Version used latest (0.2.7)

@zorrofox
Copy link
Contributor

zorrofox commented Aug 9, 2013

PLS use the last commit 233008d

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants