Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Dec 14, 2018, 9:11 AM

No suitable driver. There was a java error. Generic JDBC error. JDBC (Imply 2.8+ and Tableau 2018.3+)

Hi All,

 

Appreciate your help on this!

 

Scenario: I am following the below steps to connect tableau desktop (2018.3) to druid 2.8 using Other Databases(JDBC) which works fine but when i publish the report on server, i gives be the below error.

 

Error message:

com.tableausoftware.jdbc.TableauJDBCException: java.sql.SQLException: No suitable driver

No suitable driver

There was a Java error.

Generic JDBC connection error

com.tableausoftware.jdbc.TableauJDBCException: java.sql.SQLException: No suitable driver

No suitable driver

There was a Java error.

---------------------------------------------------------------------------------------------------------------------------------------------

 

In Tableau Desktop i have followed the steps:

 

JDBC (Imply 2.8+ and Tableau 2018.3+)

Tableau 2018.3 introduced support for JDBC connections, which you can use to connect to Druid. This offers improved compatibility and more robust integration versus the previously-recommended PostgreSQL emulation method. For information about integrating older versions of Imply and Tableau, see the "Earlier versions" section below.

Please note that not all Tableau functions have been fully tested and verified.

To do this, you will need:

Once you have this software installed, follow these steps:

  1. Place the "avatica-1.12.0.jar" file in Tableau's Drivers folder. On Windows this is C:\Program Files\Tableau\Drivers. On Mac it is ~/Library/Tableau/Drivers.
  2. Launch Tableau and choose the "Other databases (JDBC)" connection option.
  3. Enter the URL "jdbc:avatica:remote:url=http://DRUID-QUERY-SERVER:8082/druid/v2/sql/avatica/" (replacing DRUID-QUERY-SERVER with the hostname or IP address of your Druid query broker).
  4. Select the dialect "SQL92".
  5. Enter a username and password if you have enabled authentication on your Druid cluster. Otherwise, leave them blank.
  6. You can set connection context parameters through a properties file, if you like. If you do not need any special context parameters, leave this section blank.
  7. Click "Sign In".
3 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Apr 12, 2019, 5:20 PM

    Hi,

     

    I am following the above steps and there is no error message for drivers. But it is not displaying the Database list.

     

    Hi, I am following the above steps and there is no error message for drivers. But it is not displaying the Database list. saw the below error in My Tableau Repository\Logs\tabprotosrv.txt.

     

    saw the below error in My Tableau Repository\Logs\tabprotosrv.txt.

     

    {"cols":0,"elapsed":0.085,"exception-msg":"com.tableausoftware.jdbc.TableauJDBCException: Exception in runQuery for query: CREATE LOCAL TEMPORARY TABLE \"XT__BCBB_______C___F_____AA___FF_AA__D___1_Connect\" (\n\t\"COL\" INTEGER\n\t) ON COMMIT PRESERVE ROWS\nError -1 (00000) : Error while executing SQL \"CREATE LOCAL TEMPORARY TABLE \"XT__BCBB_______C___F_____AA___FF_AA__D___1_Connect\" (\n\t\"COL\" INTEGER\n\t) ON COMMIT PRESERVE ROWS\": Remote driver error: RuntimeException: org.apache.calcite.sql.parser.SqlParseException: Encountered \"CREATE\" at line 1, column 1.\nWas expecting one of:\n    \"SET\" ...\n    \"RESET\" ...\n    \"ALTER\" ...\n    \"WITH\" ...\n    \"+\" ...\n    \"-\" ...\n    \"NOT\" ...\n    \"EXISTS\" ...\n    <UNSIGNED_INTEGER_LITERAL> ...\n    <DECIMAL_NUMERIC_LITERAL> ...\n    <APPROX_NUMERIC_LITERAL> ...\n    <BINARY_STRING_LITERAL> ...\n    <PREFIXED_STRING_LITERAL> ...\n    <QUOTED_STRING> ...\n    <UNICODE_STRING_LITERAL> ...\n    \"TRUE\" ...\n    \"FALSE\" ...\n    \"UNKNOWN\" .

     

    Thanks

Write an answer...
0/9000