Uploaded image for project: 'Geronimo'
  1. Geronimo
  2. GERONIMO-6714

Use PreparedStatement

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: databases
    • Security Level: public (Regular issues)
    • Labels:
      None
    • Patch Info:
      Patch Available

      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. 

        Attachments

        1. patch.txt
          2 kB
          bd2019us

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              bd2019us bd2019us
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: