Bug 65515 - Allow pooling of Prepared Statements in JDBC
Summary: Allow pooling of Prepared Statements in JDBC
Status: RESOLVED FIXED
Alias: None
Product: JMeter
Classification: Unclassified
Component: Main (show other bugs)
Version: 5.4.1
Hardware: All All
: P2 enhancement (vote)
Target Milestone: JMETER_5.5
Assignee: JMeter issues mailing list
URL:
Keywords: FixedInTrunk
Depends on:
Blocks:
 
Reported: 2021-08-21 11:54 UTC by Felix Schumacher
Modified: 2021-10-16 11:27 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Felix Schumacher 2021-08-21 11:54:15 UTC
While JMeter supports Prepared Statements, it does not allow to cache those statements. Therefore every Prepared Statement will be "prepared" before execution, regardless whether it has been prepared before or not.

It would be nice to allow pooling of those statements as the underlying commons-dbcp library supports it.
Comment 1 Felix Schumacher 2021-08-21 11:57:57 UTC
commit c3528555f445cea46919e414731d96ebe6d1111c
AuthorDate: Sat Aug 21 13:56:40 2021 +0200

    Allow pooling of Prepared Statements in JDBC
    
    Bugzilla Id: 65515
---
 .../protocol/jdbc/config/DataSourceElement.java    |  46 +++++++++++++++------
 .../jdbc/config/DataSourceElementBeanInfo.java     |   6 ++-
 .../config/DataSourceElementResources.properties   |   2 +
 xdocs/changes.xml                                  |   1 +
 .../screenshots/jdbc-config/jdbc-conn-config.png   | Bin 37115 -> 19902 bytes
 xdocs/usermanual/component_reference.xml           |   1 +
 6 files changed, 42 insertions(+), 14 deletions(-)