when I run a query in jmeter via jdbc, I get an error Cannot create PoolableConnectionFactory

[Former Member]

I want to write a load script to connect to sap hana express 2 VM, but I encounter a problem, I send a simple query to the database that works in HANA Studio, but returns the following error in Jmeter - Can not create a PoolableConnectionFactory (SAP DBTech JDBC: [ 257]: sql syntax error: line 1 col 8 (at pos 8)). The database is deployed in a virtual machine

[lbreddemann · Accepted solution]

The test query in your settings is not a valid HANA query.

Try replacing it with something like

SELECT 1 FROM DUMMY

[Former Member · Accepted solution]

thank you very much, this works!