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

[ http://jira.jboss.com/jira/browse/JBESB-1623?page=all ] Len DiMaggio updated JBESB-1623: -------------------------------- Description: 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://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> was: 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> > 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://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> -- 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