Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | App - General |
| Version | 17.0 |
Aqua Data Studio 17.0.0-dev-18
Build #: 43680
Built on: 2015-Apr-22 06:02:48 PM
OS: Ubuntu 14.04 LTS
Linux (3.13.0-32-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=4,432,855,040; Total=1,147,142,144; Free=958,708,184; CPUs=8
JDBC Driver : Google BigQuery- bqjdbc-1.4.jar [6.5MB]
Issue: Throws exception java.lang.NoSuchMethodError: org.apache.commons.codec.binary.Hex.encodeHex([BZ)[C on opening query analyzer, query builder, when 3rd party JDBC driver is used.
Precondition: download and copy google bigquery jdbc bqjdbc-1.4.jar file[starschema] to ADS directory /datastudio/lib/drivers/
Steps to reproduce the issue:
1. Launch ADS, In ADS schema tree node, Right click on any connected database [Excel, MySQL], and select 'Query Analyzer' option.
2. Query Analyzer doesn't open and in view log it throws exception
java.lang.NoSuchMethodError: org.apache.commons.codec.binary.Hex.encodeHex([BZ)[C
1] This issue is specific to linux OS. On Windows OS, this issue is not observed.
2] Launch Query Analyzer, Query Builder, Exit ADS operation[File->Exit] , it throws same exception
3] Broken build: ADS 17.0.0-dev-18
|
|
185 KB
Stack Trace:
The error seems to indicate that there is a jar dependency issue. Have you tried the "Starschema JDBC for BigQuery 1.4 without dependencies" bqjdbc-1.4-standalone.jar?
The error seems to indicate that there is a jar dependency issue. Have you tried the "Starschema JDBC for BigQuery 1.4 without dependencies" bqjdbc-1.4-standalone.jar?
@Jenny
The error seems to indicate that there is a jar dependency issue. Have you tried the "Starschema JDBC for BigQuery 1.4 without dependencies" bqjdbc-1.4-standalone.jar?
>> Tried with and without the "bqjdbc-1.4-standalone.jar" file, still it shows exception for latest build[ADS 17.0.0-dev-18]. The exception is not observed for previous build- ADS 17.0.0-dev-15.
@Jenny
The error seems to indicate that there is a jar dependency issue. Have you tried the "Starschema JDBC for BigQuery 1.4 without dependencies" bqjdbc-1.4-standalone.jar?
>> Tried with and without the "bqjdbc-1.4-standalone.jar" file, still it shows exception for latest build[ADS 17.0.0-dev-18]. The exception is not observed for previous build- ADS 17.0.0-dev-15.
ADS bundles the Apache Commons Codec library :
https://commons.apache.org/proper/commons-codec/index.html
The latest version is 1.10. On 11/13/2008 I checked in version 1.3 into distribution. On 12/13/2011 Kin-Hong checked in a new version but didn't indicate the version (he should have). He checked it in as part of the Apache Solr 3.5 update.
The error message "java.lang.NoSuchMethodError: org.apache.commons.codec.binary.Hex.encodeHex" leads me to beleive that BigQuery relys on a different version of Apache Codec than the version we have bundled. Asif just worked on Apache Codec. Sachin, Asif and Kin-Hong should coordinate to find the version of Codec we are using and what version BigQuery is using so that we can updated the library version to one which is compatible with all the use cases we have.
Here are the Codec versions and dates :
https://commons.apache.org/proper/commons-codec/changes-report.html
ADS bundles the Apache Commons Codec library :
https://commons.apache.org/proper/commons-codec/index.html
The latest version is 1.10. On 11/13/2008 I checked in version 1.3 into distribution. On 12/13/2011 Kin-Hong checked in a new version but didn't indicate the version (he should have). He checked it in as part of the Apache Solr 3.5 update.
The error message "java.lang.NoSuchMethodError: org.apache.commons.codec.binary.Hex.encodeHex" leads me to beleive that BigQuery relys on a different version of Apache Codec than the version we have bundled. Asif just worked on Apache Codec. Sachin, Asif and Kin-Hong should coordinate to find the version of Codec we are using and what version BigQuery is using so that we can updated the library version to one which is compatible with all the use cases we have.
Here are the Codec versions and dates :
https://commons.apache.org/proper/commons-codec/changes-report.html
Update: The Manifest.MF file from commons-codec.jar (bundled with ADS) indicate that the version is 1.5.
Update: The Manifest.MF file from commons-codec.jar (bundled with ADS) indicate that the version is 1.5.
@asif: Upgrade to apache codec version 1.7 which is the one bundled w/ the apache phoenix driver. Upgrade to apache code 1.9 b/c that is used by apache POI. Remove the bundled apche codec 1.7 in phoenix jar.
@anil: we don't support the starschema google bigquery jdbc driver. Instead, we're creating our own JDBC driver. The google big query java JAR (which is what we'll use to provide our JDBC support) do not appear to have a dependency on apache codec.
@asif: Upgrade to apache codec version 1.7 which is the one bundled w/ the apache phoenix driver. Upgrade to apache code 1.9 b/c that is used by apache POI. Remove the bundled apche codec 1.7 in phoenix jar.
@anil: we don't support the starschema google bigquery jdbc driver. Instead, we're creating our own JDBC driver. The google big query java JAR (which is what we'll use to provide our JDBC support) do not appear to have a dependency on apache codec.
Issue #13277 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Stack Trace: