Bug 65515

Summary: Allow pooling of Prepared Statements in JDBC
Product: JMeter Reporter: Felix Schumacher <felix.schumacher>
Component: MainAssignee: JMeter issues mailing list <issues>
Status: RESOLVED FIXED    
Severity: enhancement Keywords: FixedInTrunk
Priority: P2    
Version: 5.4.1   
Target Milestone: JMETER_5.5   
Hardware: All   
OS: All   

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