[
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);
<
---
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>
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);
<
---
sbCol.append(sIn).append("\"").append(sCurrCol).append("\"");
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>
> 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);
> <
> ---
>
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>
--
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