[GERONIMO-6714] Use PreparedStatement

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Component/s: databases
• Security Level: public (Regular issues)
• Patch Info: Patch Available
• Assignee: Unassigned
• Reporter: bd2019us
• Created: 04/Mar/19 23:32
• Updated: 11/Apr/19 01:25
• Resolved: 11/Apr/19 01:18

Description

Hello,

Is it a good way to use "PreparedStatement" instead of "createStatement" to improve performance?  "PreparedStatement" is helpful if we are executing a particular parameterized SQL query multiple times ( such as "Delete..." in this case) since "PreparedStatement" can be precompiled and the query is created only once.