Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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

    SELECT 1 FROM DUMMY
    Add comment
    10|10000 characters needed characters exceeded