Search code examples
jmetersnowflake-cloud-data-platformsnowflake-connector

Fail to retrieve row count for first arrow chunk error while connect the snowflake JDBC connector using Jmeter

I'm getting the following error when my jdbc request is executed: Response message:java.sql.SQLException: Cannot create PoolableConnectionFactory (JDBC driver internal error: Fail to retrieve row count for first arrow chunk: null.)

Solution

  • It looks like your snowflake JDBC driver is too old and your JDK is too new, the options are in:

    1. Downgrade to an earlier Java version, the minimum one you can run JMeter 5.4.3 with is Java 8

    2. Upgrade your snowflake JDBC driver to the most recent version

    3. Add the following line to JMeter system.properties file (lives in "bin" folder of your JMeter installation)

      jdk.module.illegalAccess=permit

      JMeter restart will be required to pick the property up