title: Python: JDBC Connection Error using JayDeBeApi
body: <p>I'm facing an error while running following code. Please help me solving this issue or suggest an alternative way to connect Vertica server via JDBC.</p>
  
  <p>I have also tried connecting using pyspark. But with pyspark we are not able to execute sql query in vertica server.</p>
  
  <p><em>System Configuration:</em></p>
  
  <p>Linux with python 3.7.0</p>
  
  <p>jaydebeapi version - 1.1.1</p>
  
  <p>jpype version - 0.7.2</p>
  
  <pre><code>import jaydebeapi
  import jpype
  
  jdbc_url = 'jdbc:vertica://XX.XX.XXX.XXX/DATA?XXXXX'
  vertica_properties={"user": "XXXX", "password": "XXXXX"}
  
  jars = ['XXXX/vertica-jdbc-9.3.1-0.jar', 
          'XXXX/vertica-spark2.1_scala2.11.jar', 
          'XXXX/CustomVerticaDialect.jar']
  
  connection = jaydebeapi.connect(jclassname='com.vertica.jdbc.Driver', url=jdbc_url, driver_args=vertica_properties, jars=jars)
  connection
  </code></pre>
  
  <p><strong>ERROR</strong></p>
  
  <pre><code>--------------------------------------------------------------------------
  AttributeError                            Traceback (most recent call last)
  &lt;ipython-input-5-cc7d2752ecd8&gt; in &lt;module&gt;()
  ----&gt; 1 connection = jaydebeapi.connect(jclassname='com.vertica.jdbc.Driver', url=jdbc_url, driver_args=vertica_properties, jars=jars)
        2 connection
  
  /BDAPP/python/anaconda3/lib/python3.7/site-packages/jaydebeapi/__init__.py in connect(jclassname, url, driver_args, jars, libs)
      379     else:
      380         libs = []
  --&gt; 381     jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)
      382     return Connection(jconn, _converters)
      383 
  
  /BDAPP/python/anaconda3/lib/python3.7/site-packages/jaydebeapi/__init__.py in _jdbc_connect_jpype(jclassname, url, driver_args, jars, libs)
      180         types = jpype.java.sql.Types
      181         types_map = {}
  --&gt; 182         for i in types.__javaclass__.getClassFields():
      183             types_map[i.getName()] = i.getStaticAttribute()
      184         _init_types(types_map)
  
  AttributeError: type object 'java.sql.Types' has no attribute '__javaclass__'
  </code></pre>