Details

    • Type: Feature Request
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.7
    • Fix Version/s: None
    • Component/s: Rosetta
    • Environment:

      JBoss AS jboss-5.1.0.GA, OpenMQ 4.4, Postgres 8.4, CentOS 64 Bit, Jdk 1.6

    • Estimated Difficulty:
      Medium

      Description

      I need to use the the SQLprovider with against a postgres database, with a table structure that doesn't exactly match what the provider expects. I would therefore like to the add the following features to this provider:
      -Message ID can be of any type
      -Status column can be of any type
      -I can specify the different state values for the status column in the esb provider definition in the jboss-esb.xml file
      -The timestamp is optional and can be either bigint or an actual datetime stamp field
      -The message data column can be of any type.

      As part of this I need to ensure that this provider works with Postgres, as currently postgres does not support implicit type casts, which this component seems to use.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                quintona Quinton Anderson
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 3 days
                  3d
                  Remaining:
                  Remaining Estimate - 3 days
                  3d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified