Skip to Content

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

Dec 04, 2017 at 12:48 PM


avatar image

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

jmeter1.png (46.3 kB)
jmeter2.png (63.1 kB)
jmeter3.png (56.6 kB)
hanastudio.png (62.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Dec 04, 2017 at 08:25 PM

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

Try replacing it with something like

Show 1 Share
10 |10000 characters needed characters left characters exceeded

thank you very much, this works!