[esb-issues] [JBoss JIRA] Created: (JBESB-1623) NotifySqlTable.java generates SQL with syntax error for NotifySqlTable

NotifySqlTable.java generates SQL with syntax error for NotifySqlTable ---------------------------------------------------------------------- Key: JBESB-1623 URL: http://jira.jboss.com/jira/browse/JBESB-1623 Project: JBoss ESB Issue Type: Bug Security Level: Public (Everyone can see) Components: Rosetta Affects Versions: 4.2.1 CP1 Environment: revision 19254 Reporter: Len DiMaggio JBESB_4_2_1_SOA_4_2/product/rosetta/src/org/jboss/soa/esb/notification/NotifySqlTable.java At revision 19254. [ldimaggi@ldimaggi notification]$ diff NotifySqlTable.java.new NotifySqlTable.java 66a67 126,127c127 < sbCol.append(sIn).append(sCurrCol); < --- Without this change, this type of Exception is raised: 15:58:55,176 ERROR [NotifySqlTable] SqlException while trying to notify table. Insert statement : insert into notifications ("Column2","Column1","MessageContents") values ('2','1','Hello from ESB-unaware JMS Client') The column names cannot be enclosed in "" (verified this with both MySQL and PostgreSQL). ===================== Notifiers used - from SOA-P notifications QuickStart: MySQL <!-- send notification to database table --> <!-- This requires a database table with columns (Column1, Column2, MessageContents)--> <!-- and appropriate user access --> <target class="NotifySqlTable" driver-class="com.mysql.jdbc.Driver" connection-url="jdbc:mysql://localhost:3306/notifytest" user-name="soaesb1" password="soaesb1" table="notifications" dataColumn="MessageContents" <column name="Column1" value="1"/> <column name="Column2" value="2"/> </target> PostgreSQL <!-- send notification to database table --> <!-- This requires a database table with columns (Column1, Column2, MessageContents)--> <!-- and appropriate user access --> <target class="NotifySqlTable" driver-class="org.postgresql.Driver" connection-url="jdbc:postgresql:testdb" user-name="soap_user" password="soap_user" table="notifications" dataColumn="MessageContents" <column name="Column1" value="1"/> <column name="Column2" value="2"/> </target> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira