[jira] [Resolved] (PHOENIX-5409) Couldn't Connect to Phoenix using JMeter

["Budi (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Budi resolved PHOENIX-5409.
---------------------------
       Resolution: Fixed
    Fix Version/s: 4.7.0

I got it resolved. turns out the driver for phoenix (phoenix-4.7.0.2.6.1.0-129-client) is suitable for JMeter version 2.9. And in order the phoenix driver to work in JMeter, use phoenix-4.7.0.2.6.4.0-91-client, not phoenix-4.7.0.2.6.1.0-129-client. and if you have service mapping enabled problem, extract your jar, find hbase-default file, and add another property for service mapping enabled = true.

> Couldn't Connect to Phoenix using JMeter
> ----------------------------------------
>
>                 Key: PHOENIX-5409
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5409
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.7.0
>            Reporter: Budi
>            Priority: Major
>              Labels: build, performance, usability
>             Fix For: 4.7.0
>
>
> Using JMeter for performance test in MySQL was successfully built. i could use all of the JDBC Request for querying MySQL and the results came.
> However, when i try to configure the JDBC Request and JDBC Connection Configuration to Phoenix, JMeter fails to connect.
> I have add the Phoenix-4.7.jar to the class path in the Test Plan window, configure the database URL (jdbc:phoenix://ip:port:/hbase-unsecure/schema_name, and the driver class (org.apache.phoenix.jdbc.PhoenixDriver) and using the JDBC Request to do a simple select * query.
> when i try to run it, it has various errors such as
> "Cannot create JDBC driver of class 'org.apache.phoenix.jdbc.PhoenixDriver' for connect URL"
> or
> "Couldn't established connection"
> and
> "java.lang.NoClassDefFoungError: Could not initialize class org.apache.phoenix.jdbc.PhoenixDriver"
>  
> i have tried all possible configuration and error still occur.
> Please Help.
>  
> P.S. When i move the phoenix jar to jmeter/lib. I can open the JMeter but i couldnt click anything in the UI. GUI Error.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)