[esb-issues] [JBoss JIRA] Resolved: (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 Assigned To: Mark Little Fix For: 4.3 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); < --- > sbCol.append(sIn).append("\"").append(sCurrCol).append("\""); Without this change, this type of Exception is raised: The colu22:51:38,921 ERROR [NotifySqlTable] SqlException while trying to notify table. Insert statement : insert into notifications ("Column2","Column1","MessageContents") values ('2','1','I have modified message: SQL notifier test - Message to notify') mn 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://localhost:5432/testdb" user-name="soap_user" password="soap_user" table="notifications" dataColumn="MessageContents"> <column name="Column1" value="1"/> <column name="Column2" value="2"/> </target>