Pits Paste, has been using the jmeter2.13 version of the Oracle test, changed today to 3.2 version, found to follow the previous method of testing, the JDBC request results always error: Cannot create Poolableconnectionfactory (ora-00923:δ??????? From?????), turned over the post, there is no better solution, and then turned to look at the help document found 2.13 and 3.2 on the JDBC Connection configuration parameters described some changes, as shown in:
Version 2.13 Help documentation Description:
Version 3.2 Help documentation Description:
It is not difficult to discover that the connection to the Oracle database has changed in the Validation Query configuration and is clearly stated, so the default "select 1" should be changed to "Select 1 from dual" When configuring Oracle, as shown in:
Note: The JDBC driver jar used here is Ojdbc6.jar and is loaded in the test plan interface.
JMeter Connect Oracle Error Cannot create poolableconnectionfactory