For some of our testing we need to be able to set the transaction isolation level of the JDBC connection. This request thus asks to enhance the JDBC Connection Configuration bean to allow for setting the Transaction Isolation Level.
Created attachment 27855 [details] Patch to nightly build revision 1182604 for porposed enhancement
Applied part of patch and changed the following: - Restricted combo box to the only accepted values + DEFAULT(don't set transactionLevel) - Removed constants from Resource file - Used a HashMap instead of 2 tables Date: Thu Oct 27 20:40:43 2011 New Revision: 1190010 URL: http://svn.apache.org/viewvc?rev=1190010&view=rev Log: Bug 52099 - Allow to set the transaction isolation in the JDBC Connection Configuration Modified: jakarta/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/config/DataSourceElement.java jakarta/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/config/DataSourceElementBeanInfo.java jakarta/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/config/DataSourceElementResources.properties jakarta/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/config/DataSourceElementResources_fr.properties jakarta/jmeter/trunk/xdocs/changes.xml
Please do not restrict the list to "valid" entries! Some drivers support transaction isolation levels that are not part of predefined JDBC isolation modes. We for instance require to run our transactions in snapshot isolation mode which is specific to MS SQL Server (code 4096). Thus you should remove the NOT_OTHER setting or set it to true.
Of course this also requires you to change the implementation of getTransactionIsolationMode to parse the potential number enterd by the user.
Created attachment 27858 [details] Proposed fix for Revision 1190010 of DataSourceElementBeanInfo.java
Date: Fri Oct 28 11:40:04 2011 New Revision: 1190256 URL: http://svn.apache.org/viewvc?rev=1190256&view=rev Log: Bug 52099 - Allow to set the transaction isolation in the JDBC Connection Configuration Modified: jakarta/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/config/DataSourceElementBeanInfo.java
This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/2626