Cannot connect to Oracle database using jmeter JDBC Connection Configuration

2
votes

Thread Group Jdbc request JDBC Connection Configuration

and i have added two listeners I am trying to connect to the data base without success getting the following error: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected )

can anyone help on this issue? thanks

1
oraclejdbcjmeter

1 Answers

3
votes

You most probably didn't change the Validation Query in JDBC Connection Configuration

enter image description here Change :

Select 1

to

select 1 from DUAL