You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@synapse.apache.org by "Sunil Tiwari (JIRA)" <ji...@apache.org> on 2009/08/19 07:58:15 UTC
[jira] Created: (SYNAPSE-571) Mediator to support Database stored
procedure
Mediator to support Database stored procedure
---------------------------------------------
Key: SYNAPSE-571
URL: https://issues.apache.org/jira/browse/SYNAPSE-571
Project: Synapse
Issue Type: Improvement
Components: Extension Mediators
Affects Versions: NIGHTLY
Environment: Generic
Reporter: Sunil Tiwari
Fix For: NIGHTLY
Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Commented: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Heshan Suriyaarachchi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12862777#action_12862777 ]
Heshan Suriyaarachchi commented on SYNAPSE-571:
-----------------------------------------------
I have managed to execute a mysql database stored procedure, without doing any modification to the DBLookupMediator codebase. I have written a blogpost[1] on how I managed to do it. Furthermore I think it would be convenient for a user; if we have a sample shipped in with synapse to demonstrate this feature. Therefore shall I go ahead and improve this synapse configuration to use both DBLookup and DBReport mediators and submit as a new sample? How about sample 364? WDYT?
[1] - http://heshans.blogspot.com/2010/04/mediator-to-support-database-stored.html
Thanks,
Heshan.
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Fix For: NIGHTLY
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Assigned: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Hiranya Jayathilaka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hiranya Jayathilaka reassigned SYNAPSE-571:
-------------------------------------------
Assignee: Hiranya Jayathilaka
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Assignee: Hiranya Jayathilaka
> Fix For: NIGHTLY
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Commented: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Heshan Suriyaarachchi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12861378#action_12861378 ]
Heshan Suriyaarachchi commented on SYNAPSE-571:
-----------------------------------------------
I will have look at this issue and come up with a patch.
Thanks,
Heshan.
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Fix For: NIGHTLY
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Updated: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Heshan Suriyaarachchi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Heshan Suriyaarachchi updated SYNAPSE-571:
------------------------------------------
Attachment: SYNAPSE-571-patch.txt
Attach patch contains;
* Synapse configuration for the sample 364
* Documentation on the sample.
* Documentation on setting up mysql server and creating stored procedures.
Regards,
Heshan
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Assignee: Hiranya Jayathilaka
> Fix For: NIGHTLY
>
> Attachments: SYNAPSE-571-patch.txt
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Commented: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Heshan Suriyaarachchi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12862109#action_12862109 ]
Heshan Suriyaarachchi commented on SYNAPSE-571:
-----------------------------------------------
I am looking into DBLookupMediator, DBReportMediator mediators to get an idea of how this can be done. Should this be a new mediator implementation or an improvement to the existing DBLookupMediator?
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Fix For: NIGHTLY
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Commented: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Heshan Suriyaarachchi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12863081#action_12863081 ]
Heshan Suriyaarachchi commented on SYNAPSE-571:
-----------------------------------------------
I am working on the sample. Will submit it as a patch, once I'm done.
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Assignee: Hiranya Jayathilaka
> Fix For: NIGHTLY
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Resolved: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Hiranya Jayathilaka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hiranya Jayathilaka resolved SYNAPSE-571.
-----------------------------------------
Fix Version/s: 2.0
(was: NIGHTLY)
Resolution: Fixed
Checked in the new sample with some minor changes. This sample demonstrates how to invoke stored procedures from Synapse. It seems there's nothing new to be implemented here. Therefore I'm resolving this issue.
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Assignee: Hiranya Jayathilaka
> Fix For: 2.0
>
> Attachments: SYNAPSE-571-patch.txt
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Commented: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Hiranya Jayathilaka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12862142#action_12862142 ]
Hiranya Jayathilaka commented on SYNAPSE-571:
---------------------------------------------
I think it would be good if we can just get this into the existing DBLookup/DBReport mediators. I don't see a point in having a separate mediator just to deal with stored procedures.
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Fix For: NIGHTLY
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Commented: (SYNAPSE-571) Mediator to support Database stored
procedure
Posted by "Hiranya Jayathilaka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12862789#action_12862789 ]
Hiranya Jayathilaka commented on SYNAPSE-571:
---------------------------------------------
By all means, yes. We'd love a new sample :)
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Assignee: Hiranya Jayathilaka
> Fix For: NIGHTLY
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org
[jira] Issue Comment Edited: (SYNAPSE-571) Mediator to support
Database stored procedure
Posted by "Heshan Suriyaarachchi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNAPSE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12862777#action_12862777 ]
Heshan Suriyaarachchi edited comment on SYNAPSE-571 at 5/2/10 12:27 AM:
------------------------------------------------------------------------
I have managed to execute a mysql database stored procedure, without doing any modification to the DBLookupMediator codebase. I have written a blogpost[1] on how I managed to do it. Furthermore I think it would be convenient for a user; if we have a sample shipped in with synapse to demonstrate this feature. Therefore shall I go ahead and improve this synapse configuration and submit as a new sample? How about sample 364? WDYT?
[1] - http://heshans.blogspot.com/2010/04/mediator-to-support-database-stored.html
Thanks,
Heshan.
was (Author: heshan):
I have managed to execute a mysql database stored procedure, without doing any modification to the DBLookupMediator codebase. I have written a blogpost[1] on how I managed to do it. Furthermore I think it would be convenient for a user; if we have a sample shipped in with synapse to demonstrate this feature. Therefore shall I go ahead and improve this synapse configuration to use both DBLookup and DBReport mediators and submit as a new sample? How about sample 364? WDYT?
[1] - http://heshans.blogspot.com/2010/04/mediator-to-support-database-stored.html
Thanks,
Heshan.
> Mediator to support Database stored procedure
> ---------------------------------------------
>
> Key: SYNAPSE-571
> URL: https://issues.apache.org/jira/browse/SYNAPSE-571
> Project: Synapse
> Issue Type: Improvement
> Components: Extension Mediators
> Affects Versions: NIGHTLY
> Environment: Generic
> Reporter: Sunil Tiwari
> Assignee: Hiranya Jayathilaka
> Fix For: NIGHTLY
>
> Attachments: SYNAPSE-571-patch.txt
>
>
> Requirement is to call DB stored procedure from Synapse ESB. Goal is to develop Synapse ESB mediator to call DB stored procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org