Improve JdbcConnector to delegate calls to the ORM layer

Details

  • Type: Improvement Improvement
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.2
  • Fix Version/s: 1.4.1
  • Component/s: Transport: JDBC
  • Labels:
    None
  • Similar Issues:
    None

Description

Let the JdbcConnector delegate its select/insert/update operations to the DAO. This way we can solve issues with JMS MessageFormatExceptions, when result is mapped to types unsupported by JMS ObjectMessage's type system, and also provide a way to call stored procedures.

Issue Links

relates to

Patch submission - User code to be reviewed and incorporated into the product. MULE-714 Support read queries for outbound JDBC

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Bug - A problem which impairs or prevents the functions of the product. MULE-761 JdbcMessageDispatcher failure when performing a query with null parameters

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Ross Mason added a comment -

Hey Andrew, any news on this? It's a cool feature

Show
Ross Mason added a comment - Hey Andrew, any news on this? It's a cool feature
Hide
Permalink
Travis Carlson added a comment -

Something I've been looking into lately is leveraging the Spring JDBC abstraction layer:
http://today.java.net/pub/a/today/2006/05/09/why-spring-jdbc.html

http://static.springframework.org/spring/docs/2.0.x/reference/jdbc.html

It's got quite a bit of functionality (including, of course, stored procedure calls), good documentation, improved exception handling, hides the details of JDBC calls and would shield Mule from any API version differences/changes.

For Oracle users, it's got some interesting Oracle-specific functionality as well:
http://www.oracle.com/technology/pub/articles/marx_spring.html

Show
Travis Carlson added a comment - Something I've been looking into lately is leveraging the Spring JDBC abstraction layer: http://today.java.net/pub/a/today/2006/05/09/why-spring-jdbc.html http://static.springframework.org/spring/docs/2.0.x/reference/jdbc.html It's got quite a bit of functionality (including, of course, stored procedure calls), good documentation, improved exception handling, hides the details of JDBC calls and would shield Mule from any API version differences/changes. For Oracle users, it's got some interesting Oracle-specific functionality as well: http://www.oracle.com/technology/pub/articles/marx_spring.html
Hide
Permalink
Alan Cassar added a comment -

Hi all,
I am currently handling adding the feature to execute stored procedures to the current jdbc transport

Show
Alan Cassar added a comment - Hi all, I am currently handling adding the feature to execute stored procedures to the current jdbc transport
Hide
Permalink
Alan Cassar added a comment -

executing stored procedures is implemented in revision 8229

Show
Alan Cassar added a comment - executing stored procedures is implemented in revision 8229
Hide
Permalink
Travis Carlson added a comment -

Wow, that was simple! I think the problem used to be that the DBUtils lib didn't support stored procedures. Apparently now it does?

Show
Travis Carlson added a comment - Wow, that was simple! I think the problem used to be that the DBUtils lib didn't support stored procedures. Apparently now it does?
Hide
Permalink
Alan Cassar added a comment -

No clue on that, however I must say that most of the time was spent not adding JAVA code to Mule, but on research about stored procedurs, setting up SQL database and formulating stored procedures...

Show
Alan Cassar added a comment - No clue on that, however I must say that most of the time was spent not adding JAVA code to Mule, but on research about stored procedurs, setting up SQL database and formulating stored procedures...
Hide
Permalink
Alan Cassar added a comment -

should we rename this jira issue to Support for stored procedures and close it?

Show
Alan Cassar added a comment - should we rename this jira issue to Support for stored procedures and close it?
Hide
Permalink
Andrew Perepelytsya added a comment -

No, it's a bit different.

Show
Andrew Perepelytsya added a comment - No, it's a bit different.
Hide
Permalink
Travis Carlson added a comment -

Alan, you can create a new JIRA representing the stored procedures support, make it "related to" this one, and close it so that that gets into the release notes (and leave this one open).

Show
Travis Carlson added a comment - Alan, you can create a new JIRA representing the stored procedures support, make it "related to" this one, and close it so that that gets into the release notes (and leave this one open).
Hide
Permalink
Andrew Perepelytsya added a comment -

A MuleForge project is available with this functionality now: http://mule.mulesource.org/display/HIBERNATE/Home Initially targeted at Mule 1.4.1, thus the fix version set.

Show
Andrew Perepelytsya added a comment - A MuleForge project is available with this functionality now: http://mule.mulesource.org/display/HIBERNATE/Home Initially targeted at Mule 1.4.1, thus the fix version set.

People

  • Assignee:
    Andrew Perepelytsya
    Reporter:
    Andrew Perepelytsya
Vote (3)
Watch (6)

Dates

  • Created:
    Updated:
    Resolved: