#14210: JDBC-ODBC is not working with java 1.8

abhishekj(*) reported 2016-01-18T13:38:16Z · last modified 2017-01-21T16:36:29Z

JDBC-ODBC is not working with java 1.8

Dev	SachinPrakash
QA	tomconrad

Priority	Minor
Complexity	Unknown

Component	DB - JDBC - ODBC Bridge
Version	18.0

Product: Aqua Data Studio

Version: 18.0.0-dev-34

Build #: 48208

Build Date: 2016-Jan-13 06:42:56 PM

Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_66-b18

Memory: Max=704,643,072; Total=390,070,272; Free=248,952,552; CPUs=8

Step 1 :

First you need to download odbc driver for the respective database.
Start Aqua Data Studio v18.0.0-dev-34 by executing datastudio.exe file.
Now Try to connect to the generic-odbc server.

Note: Here the default jre in ads home directory is 1.8.

Result:

We will get an error message Missing driver: The ODBC driver is not bundled with Aqua Data Studio.
To use the driver, download JRE 1.7 from AquaFold website http://www.aquafold.com/download/jre/windows/jre1.7-64bit.zip

Please refer to screenshot : step1.png

Step 2:

Download jre1.7-64bit.zip file from the AquaFold website and extract it
Copy jre1.7-64bit folder into the [ADS_HOME] folder
Start Aqua Data Studio v18.0.0-dev-34 by executing datastudio.exe file

Result :

When we try to execute datastudio.exe file we get an error message and ADS does not open.
Please refer to screenshot Error_Message.png & Error_Message.txt
When we perform the same steps in v17,this issue is not observed.

11 attachments

Error_Message.txt

2016-01-18T13:38:16Z

17 KB
step1.png

2016-01-18T13:43:36Z

285 KB
scenario2.png

2016-01-18T13:43:36Z

517 KB
java 1.8.png

2016-05-25T05:01:02Z

9 KB
JDBC-ODBC-Connecion-Successful_1.7-JRE.png

2016-05-25T14:17:43Z

57 KB
datastudio.exe_1.7JRE.png

2016-05-25T14:17:43Z

101 KB
JRE_1.8.png

2017-01-06T14:15:02Z

171 KB
JRE_1.7.png

2017-01-06T14:15:16Z

179 KB
Postgres-ODBC.png

2017-01-07T04:23:10Z

54 KB
Oracle-ODBC.png

2017-01-07T04:23:10Z

48 KB
Screen Shot 2017-01-21 at 8.36.07 AM.png

2017-01-21T16:36:09Z

83 KB

All Comments (8) Change History

SachinPrakash 2016-03-14T20:37:11Z

The error in your screenshot states : UnsupportedClassVersionError. This is occurring b/c you are running jre 1.7 when performing your test. In ADS v18, we are compiling our code w/ jdk 1.8. So you must run jre 1.8 in order to perform a valid test.

Try your test again using the latest ADS v18 build. Run using the ".exe" or datastudio-bundled.bat. If you run using datastudio.bat, then the jre installed in your system path is used. If the jre installed in your system path < 1.8, then you will not be able to run ADS.

abhishekj(*) 2016-04-25T10:11:29Z

Verified in ads 18.0.0-dev-120.

abhishekj(*) 2016-05-25T14:19:29Z · (edited)

Hi Sachin,

I installed java 1.8 on my system and followed the below steps :

Please refer to screenshot : java 1.8.png

I have carried the test on the below build :

Product: Aqua Data Studio

Version: 18.0.0-devi-144

Build #: 49931

Build Date: 2016-May-21 07:49:51 PM

Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_72-b15

Memory: Max=954,728,448; Total=516,947,968; Free=290,787,008; CPUs=8

Step 1 :

First you need to download odbc driver for the respective database.
Go to Programs,select Microsoft ODBC Administrator
Go to "SYSTEM DSN" tab from Microsoft ODBC Administrator
Click on Add button.
Select oracle database driver for which you want to set up a data source.

Fill the below details in the oracle odbc driver configuration.
DataSource Name : Oracle
TNSSERVICE Name : oracle(in my case the tnservice name is oracle)
Click on Test Connection.
Enter ID & Password
Click on Ok Button.
Message will be displayed Connection Successfull.

Note :For more detailed instructions, see How to Install the JDBC-ODBC Bridge Driver

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

Now,

Open ads by executing datastudio.exe or datastudio-bundled.bat
Go to Server,select "Register Server"
Select Generic-ODBC from general pane.
Enter Name : Oracle_ODBC
Enter login name & password.
Go to Datasource,click on Browse button and select ODBC driver
Click on Test Connect button.

Observation :

We will get an error message Missing driver: The ODBC driver is not bundled with Aqua Data Studio.

To use the driver, download JRE 1.7 from AquaFold website http://www.aquafold.com/download/jre/windows/jre1.7-64bit.zip

Note: Here the default jre in ads home directory is 1.8.

Step 2 :

Check the system JRE version is 1.8.
Replace & Copy the system JRE and paste it in ads home directory.
Open ads by executing datastudio.exe or datastudio-bundled.bat or datastudio.bat.

Go to Server,select "Register Server"
Select Generic-ODBC from general pane.
Enter Name : Oracle_ODBC
Enter login name & password.
Go to Datasource,click on Browse button and select ODBC driver
Click on Test Connect button.

Observation :

We will get an error message Missing driver: The ODBC driver is not bundled with Aqua Data Studio.

To use the driver, download JRE 1.7 from AquaFold website http://www.aquafold.com/download/jre/windows/jre1.7-64bit.zip

Step3:

Download JRE 1.7 from AquaFold website http://www.aquafold.com/download/jre/windows/jre1.7-64bit.zip
Copy & Replace the system JRE 1.7 and paste it in ads home directory.
Open ads by executing datastudio.bat.
Go to Server,select "Register Server"
Select Generic-ODBC from general pane.
Enter Name : Oracle_ODBC
Enter login name & password.
Go to Datasource,click on Browse button and select ODBC driver
Click on Test Connect button.

Observation :

Oracle database connected successfully using ODBC-JDBC.
Please refer to screenshot :datastudio.exe_1.7JRE.pn
If we execute datastudio.exe we get an error message "Failed JVM". Please refer datastudio.exe_1.7JRE.pn
If we execute datastudio-bundled.bat,ads window opens and closes.

Is this an expected behavior ?

Hi Sachin,

I installed java 1.8 on my system and followed the below steps :

Please refer to screenshot : java 1.8.png

I have carried the test on the below build :

Product: Aqua Data Studio

Version: 18.0.0-devi-144

Build #: 49931

Build Date: 2016-May-21 07:49:51 PM

Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_72-b15

Memory: Max=954,728,448; Total=516,947,968; Free=290,787,008; CPUs=8

Step 1 :

First you need to download odbc driver for the respective database.
Go to Programs,select Microsoft ODBC Administrator
Go to "SYSTEM DSN" tab from Microsoft ODBC Administrator
Click on Add button.
Select oracle database driver for which you want to set up a data source.

Fill the below details in the oracle odbc driver configuration.
DataSource Name : Oracle
TNSSERVICE Name : oracle(in my case the tnservice name is oracle)
Click on Test Connection.
Enter ID & Password
Click on Ok Button.
Message will be displayed Connection Successfull.

Note :For more detailed instructions, see How to Install the JDBC-ODBC Bridge Driver

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

Now,

Open ads by executing datastudio.exe or datastudio-bundled.bat
Go to Server,select "Register Server"
Select Generic-ODBC from general pane.
Enter Name : Oracle_ODBC
Enter login name & password.
Go to Datasource,click on Browse button and select ODBC driver
Click on Test Connect button.

Observation :

We will get an error message Missing driver: The ODBC driver is not bundled with Aqua Data Studio.

To use the driver, download JRE 1.7 from AquaFold website http://www.aquafold.com/download/jre/windows/jre1.7-64bit.zip

Note: Here the default jre in ads home directory is 1.8.

Step 2 :

Check the system JRE version is 1.8.
Replace & Copy the system JRE and paste it in ads home directory.
Open ads by executing datastudio.exe or datastudio-bundled.bat or datastudio.bat.

Go to Server,select "Register Server"
Select Generic-ODBC from general pane.
Enter Name : Oracle_ODBC
Enter login name & password.
Go to Datasource,click on Browse button and select ODBC driver
Click on Test Connect button.

Observation :

We will get an error message Missing driver: The ODBC driver is not bundled with Aqua Data Studio.

To use the driver, download JRE 1.7 from AquaFold website http://www.aquafold.com/download/jre/windows/jre1.7-64bit.zip

Step3:

Download JRE 1.7 from AquaFold website http://www.aquafold.com/download/jre/windows/jre1.7-64bit.zip
Copy & Replace the system JRE 1.7 and paste it in ads home directory.
Open ads by executing datastudio.bat.
Go to Server,select "Register Server"
Select Generic-ODBC from general pane.
Enter Name : Oracle_ODBC
Enter login name & password.
Go to Datasource,click on Browse button and select ODBC driver
Click on Test Connect button.

Observation :

Oracle database connected successfully using ODBC-JDBC.
Please refer to screenshot :datastudio.exe_1.7JRE.pn
If we execute datastudio.exe we get an error message "Failed JVM". Please refer datastudio.exe_1.7JRE.pn
If we execute datastudio-bundled.bat,ads window opens and closes.

Is this an expected behavior ?

abhishekj(*) 2017-01-04T06:50:26Z

@Tariq:

Can you guide me and let me know the expected behavior asked in this comment

SachinPrakash 2017-01-06T04:52:03Z

@abhishek: can you try w/ another ODBC driver such as PostgreSQL or MS Excel or MS Access

We also have documentation for how this process works:

https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation18/page/111/Generic-ODBC

abhishekj(*) 2017-01-06T18:33:59Z · Edited by

SachinPrakash

Hi Sachin,

Case 1 :

If I connect JDBC-ODBC connection in v18 with default driver 1.8 we get error message

Unable to create connection.

Please refer to the screenshot : JRE_1.8.png

Case 2 :

As per the instruction given in this document,I replaced the default JRE driver 1.8 with the JRE 1.7.

Connect to Server.

Database gets Connected successfully .

Please refer to the screenshot : JRE_1.7.png

Kindly confirm is this an expected behavior ? [SP] Yes. You man verify & close this issue. If yes I will mark the issue as verified and closed.

Also I have gone through this document and it seems that CASE 2 is a valid behavior.

I tried to connect with Postgres Sql ODBC Drivers.

abhishekj(*) 2017-01-07T04:24:44Z · (edited)

Verified and closed in v18.0.0-rc-23

Verified for Oracle db & Postgres Sql db.

Please refer to the below screenshot :

Oracle db :Oracle-ODBC.png

Postgres db :Postgres-ODBC.png

tariqrahiman 2017-01-21T16:36:29Z

Verified in ADS v18.0.0-preview-18

Search Tips

Aqua Data Studio / nhilam

JDBC-ODBC is not working with java 1.8

11 attachments

Issue #14210

Completion

2 issue links

Issue #13279

Issue #13141

Search Tips

Aqua Data Studio / nhilam

Title

JDBC-ODBC is not working with java 1.8

11 attachments

Issue #14210

Completion

2 issue links

Issue #13279

Issue #13141