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
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
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

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.