Petals ESB Container

The persistence service should use fetch-array with ResultSet to retrieve data of a request returning several lines

Details

  • Type: Improvement Request Improvement Request
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 3.1.1
  • Fix Version/s: 3.1.2, 4.0.0
  • Component/s: Persistence
  • Security Level: Public
  • Description:
    Hide

    To improve performance, set a fetch size on statements SELECT returning more than one line:

    • to get message exchange properties of a message exchange,
    • to get normalized message of a message exchange,
    • to get message exchange identifiers,
    • to get message exchange history

    Add a parameter to the server.properties to define the fetch size (default value 10)

    Show
    To improve performance, set a fetch size on statements SELECT returning more than one line:
    • to get message exchange properties of a message exchange,
    • to get normalized message of a message exchange,
    • to get message exchange identifiers,
    • to get message exchange history
    Add a parameter to the server.properties to define the fetch size (default value 10)
  • Environment:
    -

Activity

Christophe DENEUX made changes - Tue, 19 Apr 2011 - 08:40:36 +0200
Field Original Value New Value
Status New [ 10000 ] Open [ 10002 ]
Priority Minor [ 4 ]
Assignee Roland Naudin [ rnaudin ] Christophe DENEUX [ cdeneux ]
Christophe DENEUX made changes - Tue, 19 Apr 2011 - 08:40:39 +0200
Status Open [ 10002 ] In Progress [ 10003 ]
Christophe DENEUX made changes - Tue, 19 Apr 2011 - 08:41:02 +0200
Description To improve performance, set a fetch size on statements SELECT returning more than one line:
- to get message exchange properties of a message exchange,
- to get normalized message of a message exchange,
- to get message exchange identifiers,
- to get message exchange history

Add a parameter to the server.properties to define the fetch size (default value 0)

To improve performance, set a fetch size on statements SELECT returning more than one line:
- to get message exchange properties of a message exchange,
- to get normalized message of a message exchange,
- to get message exchange identifiers,
- to get message exchange history

Add a parameter to the server.properties to define the fetch size (default value 10)

Christophe DENEUX made changes - Tue, 19 Apr 2011 - 09:20:32 +0200
Status In Progress [ 10003 ] Resolved [ 10004 ]
Fix Version/s 3.1.2 [ 10156 ]
Resolution Fixed [ 1 ]
Christophe DENEUX made changes - Tue, 19 Apr 2011 - 09:20:40 +0200
Status Resolved [ 10004 ] Open [ 10002 ]
Resolution Fixed [ 1 ]
Adrien Ruffie made changes - Wed, 14 Sep 2011 - 16:59:50 +0200
Assignee Christophe DENEUX [ cdeneux ] Adrien Ruffie [ aruffie ]
Adrien Ruffie made changes - Wed, 14 Sep 2011 - 16:59:52 +0200
Status Open [ 10002 ] In Progress [ 10003 ]
Adrien Ruffie made changes - Wed, 14 Sep 2011 - 16:59:55 +0200
Status In Progress [ 10003 ] Resolved [ 10004 ]
Fix Version/s 4.0.0 [ 10108 ]
Fix Version/s 3.1.2 [ 10156 ]
Resolution Fixed [ 1 ]
Christophe DENEUX made changes - Wed, 14 Sep 2011 - 17:47:48 +0200
Fix Version/s 3.1.2 [ 10156 ]

People

Dates

  • Created:
    Thu, 31 Mar 2011 - 10:36:32 +0200
    Updated:
    Wed, 14 Sep 2011 - 17:47:48 +0200
    Resolved:
    Wed, 14 Sep 2011 - 16:59:55 +0200