[JBoss JIRA] Created: (JBESB-1412) Ability to send message payload as an attachment
by Kenneth Larsen (JIRA)
Ability to send message payload as an attachment
------------------------------------------------
Key: JBESB-1412
URL: http://jira.jboss.com/jira/browse/JBESB-1412
Project: JBoss ESB
Issue Type: Feature Request
Security Level: Public (Everyone can see)
Components: Rosetta
Reporter: Kenneth Larsen
Attachments: NotifyEmailPatch.patch
It would be nice to have the option of sending the message payload as an attachment when using the EMailNotifier instead of always having to include the message payload into the mail body. In some cases the payload might be binary content which is inappropriate in the mail body.
By specifying an additional attribute for the target the payload should be attached to the mail:
<target class="NotifyEmail" from="sender(a)domain.com" sendTo="recipient(a)anotherdomain.com" subject="subject for message" msgAttachmentName="attachmentname.ext">
In the example above a new attribute has been introduced (msgAttachmentName). If specified the payload is created as an attachment with the specified filename instead of being part of the mail body.
--
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
18 years
[JBoss JIRA] Created: (JBESB-1623) NotifySqlTable.java generates SQL with syntax error for NotifySqlTable
by Len DiMaggio (JIRA)
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:
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
18 years
[JBoss JIRA] Created: (JBESB-1671) Merge all CP2 changes over to trunk
by Kevin Conner (JIRA)
Merge all CP2 changes over to trunk
-----------------------------------
Key: JBESB-1671
URL: http://jira.jboss.com/jira/browse/JBESB-1671
Project: JBoss ESB
Issue Type: Task
Security Level: Public (Everyone can see)
Components: Adapters, Build and Release, Configuration, Content Based Routing, Deployment, Documentation, Examples, JBI, Management, Message Store, Process flow, Registry and Repository, Rosetta, Security, Testing, Tooling, Transformation Service, Transports, Web Services
Affects Versions: 4.2.1
Reporter: Kevin Conner
Assigned To: Kevin Conner
Fix For: 4.3
--
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
18 years