Petals ESB Container

Use preparedStatement instead of simple statement to improve performance and security

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:

    Several SQL requests are executed using JDBC statements instead of prepared statements.
    Use prepares statement to improve performances (SQL requests have not to be parsed each time)

  • Environment:
    -

Activity

Ascending order - Click to sort in descending order
Christophe DENEUX made changes - Tue, 29 Mar 2011 - 16:50:07 +0200
Field Original Value New Value
Status New [ 10000 ] Open [ 10002 ]
Priority Minor [ 4 ]
Christophe DENEUX made changes - Tue, 29 Mar 2011 - 16:50:10 +0200
Assignee Roland Naudin [ rnaudin ] Christophe DENEUX [ cdeneux ]
Christophe DENEUX made changes - Tue, 29 Mar 2011 - 16:50:16 +0200
Status Open [ 10002 ] In Progress [ 10003 ]
Hide
Permalink
Christophe DENEUX added a comment - Thu, 31 Mar 2011 - 10:09:15 +0200 - edited

Fix in branch 3.1.x (https://svn.petalslink.org/svnroot/branches-legacy/petals-enterprise-3.1.x):

  • All statements are prepared statements and use bind variables,
  • Source code has been refactored to be more readable
Show
Christophe DENEUX added a comment - Thu, 31 Mar 2011 - 10:09:15 +0200 - edited Fix in branch 3.1.x (https://svn.petalslink.org/svnroot/branches-legacy/petals-enterprise-3.1.x):
  • All statements are prepared statements and use bind variables,
  • Source code has been refactored to be more readable
Christophe DENEUX made changes - Thu, 31 Mar 2011 - 10:09:15 +0200
Status In Progress [ 10003 ] Resolved [ 10004 ]
Fix Version/s 3.1.2 [ 10156 ]
Resolution Fixed [ 1 ]
Hide
Permalink
Christophe DENEUX added a comment - Thu, 31 Mar 2011 - 10:09:27 +0200

To merge in trunk

Show
Christophe DENEUX added a comment - Thu, 31 Mar 2011 - 10:09:27 +0200 To merge in trunk
Christophe DENEUX made changes - Thu, 31 Mar 2011 - 10:11:04 +0200
Status Resolved [ 10004 ] Open [ 10002 ]
Resolution Fixed [ 1 ]
Adrien Ruffie made changes - Thu, 15 Sep 2011 - 08:36:54 +0200
Assignee Christophe DENEUX [ cdeneux ] Adrien Ruffie [ aruffie ]
Adrien Ruffie made changes - Thu, 15 Sep 2011 - 08:36:58 +0200
Status Open [ 10002 ] In Progress [ 10003 ]
Adrien Ruffie made changes - Fri, 23 Sep 2011 - 09:35:46 +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 - Fri, 23 Sep 2011 - 09:55:24 +0200
Fix Version/s 3.1.2 [ 10156 ]
Transition Status Change Time Execution Times Last Executer Last Execution Date
New New Open Open
38d 5h 16m
1
Christophe DENEUX
Tue, 29 Mar 2011 - 16:50:07 +0200
Open Open In Progress In Progress
9s
1
Christophe DENEUX
Tue, 29 Mar 2011 - 16:50:16 +0200
In Progress In Progress Resolved Resolved
1d 17h 18m
1
Christophe DENEUX
Thu, 31 Mar 2011 - 10:09:15 +0200
Resolved Resolved Open Open
1m 49s
1
Christophe DENEUX
Thu, 31 Mar 2011 - 10:11:04 +0200
Open Open In Progress In Progress
167d 22h 25m
1
Adrien Ruffie
Thu, 15 Sep 2011 - 08:36:58 +0200
In Progress In Progress Resolved Resolved
8d 58m
1
Adrien Ruffie
Fri, 23 Sep 2011 - 09:35:46 +0200



People

Dates

  • Created:
    Sat, 19 Feb 2011 - 10:33:22 +0100
    Updated:
    Fri, 23 Sep 2011 - 09:55:24 +0200
    Resolved:
    Fri, 23 Sep 2011 - 09:35:46 +0200
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Petals ESB. Try JIRA - bug tracking software for your team.