RE: [JIRA] Commented: (CAY-878) Field names for INSERT are unquoted

From: Scott Anderson (sanderso..irvana.com)
Date: Thu Oct 11 2007 - 11:31:44 EDT

Next message: Andrus Adamchik: "Re: [JIRA] Commented: (CAY-878) Field names for INSERT are unquoted"

Previous message: Scott Anderson (JIRA): "[JIRA] Created: (CAY-878) Field names for INSERT are unquoted"
Next in thread: Andrus Adamchik: "Re: [JIRA] Commented: (CAY-878) Field names for INSERT are unquoted"
Reply: Andrus Adamchik: "Re: [JIRA] Commented: (CAY-878) Field names for INSERT are unquoted"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Looks like CAY-289 wants strings escaped with square brackets. The
standard, for MySQL at least, is backquotes.

I worked around this problem by renaming the field in the database from
`group` to `groupId`

-----Original Message-----
From: Andrus Adamchik (JIRA) [mailto:de..ayenne.apache.org]
Sent: Thursday, October 11, 2007 4:14 AM
To: Scott Anderson
Subject: [JIRA] Commented: (CAY-878) Field names for INSERT are unquoted

[
https://issues.apache.org/cayenne/browse/CAY-878?page=com.atlassian.jira
.plugin.system.issuetabpanels:comment-tabpanel#action_12529 ]

Andrus Adamchik commented on CAY-878:

-------------------------------------

Support for that feature has been requested before (CAY-289)... We
finally need to find time and fix it.

> Field names for INSERT are unquoted

> -----------------------------------

> Key: CAY-878

> URL: https://issues.apache.org/cayenne/browse/CAY-878

> Project: Cayenne

> Issue Type: Bug

> Affects Versions: 3.0

> Environment: MySQL/Tomcat/Cayenne

> Reporter: Scott Anderson

> Assignee: Andrus Adamchik

> My INSERT query fails against MySQL because I have a field named
`group` that is not unquoted.

> Oct 10, 2007 4:12:31 PM org.apache.cayenne.access.QueryLogger logQuery

> INFO: INSERT INTO requests2 (autoengineer, close_time,
completion_comments, completion_passfail, completion_time, group, idx,
lab_action, lab_budget, lab_date_needed, lab_device_id, lab_location,
lab_program, lab_rack_no, lab_requesting_group, lab_serial_no,
model_affecting, model_changes, platform, priority, req_type, request,
rpt_affecting, rpt_changes, state, submission_comments, submit_time,
submitter, testcnt, ui_affecting, ui_changes, version) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?)

> Oct 10, 2007 4:12:31 PM org.apache.cayenne.access.QueryLogger
logQueryParameters

> INFO: [bind: NULL, '2005-11-02 10:51:13.0', '<br>IMPLEMENT COMMENTS:
All do...', NULL, '2005-11-02 10:34:39.0', NULL, 2, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, 'false', NULL, 'ClearQuest Tools',
03, NULL, 'Test Plan Import Problems', 'false', NULL, 'CLOSED', 'Please
update the CQ export to...', '2005-10-12 13:18:42.0', 'ddarrah', 0,
'false', NULL, NULL]

> Oct 10, 2007 4:12:32 PM org.apache.cayenne.access.QueryLogger
logQueryError

> INFO: *** error.

> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error
in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'group, idx, lab_action,
lab_budget, lab_date_needed, lab_device_id, lab_location' at line 1

> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)

> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)

> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)

> at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)

> at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1268)

> at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:15
41)

> at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:14
55)

> at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:14
40)

> at
org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchA
ction.java:191)

> at
org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.jav
a:84)

> at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryActi
on.java:57)

> at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:236)

> at
org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlu
shAction.java:225)

> at
org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAct
ion.java:143)

> at
org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:803)

> at
org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:770)

> at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:82
9)

> at
org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:767)

> at
org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:115
9)

> at
org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:107
2)

> at com.airvana.nmms.autodb.test.main(test.java:91)

> Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
[v.3.0-SNAPSHOT Sep 01 2007 17:06:09] Commit Exception

> at
org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:119
1)

> at
org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:107
2)

> at com.airvana.nmms.autodb.test.main(test.java:91)

> Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'group, idx,
lab_action, lab_budget, lab_date_needed, lab_device_id, lab_location' at
line 1