Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Third Party JDBC Drivers disappearing if attempted to use Data Modeler

Christos Iraklis TsatsoulisFeb 11 2016 — edited Feb 17 2016

Hi all,

I am trying to reproduce the steps in this Oracle blog post: https://blogs.oracle.com/datawarehousing/entry/oracle_sql_developer_data_modeler regarding Hive JDBC connectivity. I can successfully connect to Hive and query Hive tables without a problem. However, if I attempt to use Data Modeler (File -> Data Modeler -> Import -> Data Dictionary), Hive connectivity is no more available, and going back to Third Party JDBC Drivers (via Tools -> Preferences) shows that there are no additional drivers listed (although they had just been added and successfully used in the previous step).

Here are some screenshots

  1. Adding Hive to Third Party JDBC Drivers:

1.PNG

  1. Successful connection to Hive:

2.PNG

  1. Connection properties in Data Modeler ((File -> Data Modeler -> Import -> Data Dictionary) - notice that the Hive tab is now not available:

3.PNG

4\) Going back to Tools -> Preferences, to check Third Party JDBC Drivers - now empty:

4.PNG

This behavior is not confined to Hive - the exact same thing happens with the MySQL driver, too.

Tested in both Windows & OEL 6.6

SQL Developer v 4.1.1.19.59

Any ideas?

Many thanks in advance
This post has been answered by Gary Graham-Oracle on Feb 12 2016
Jump to Answer

Comments

Madhusudhan. M

Office 365 editions require locally installed supported versions of Office applications. See https://support.oracle.com/epmos/faces/DocumentDisplay?id=1581197.1.

Hope you rebooted server after changing heap settings. check out logs for any errors ?

https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s14s02.html

Thanks,

Mady

user9082214

Not sure about the smart view performance issue - but issue #2 - if you are talking about getting the "white screen" when trying to open HFM in Workspace - this fix may help:

Doc ID 2237050.1

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=383744433618875&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

--BRC

ChrisTurnbull

We have an open SR with Oracle for the Smart View issue also, they are looking at running a fiddler trace on it shortly. We have completed a number of tests in regards to all manner of EXCEL and IE Options to no avail. I will post up further if we get anywhere, but just want to confirm that right now 11.1.2.4 and EXCEL 2016 use leads to slower performing refreshes and occasional crashing.

One recommendation is that you stay on the Monthly Channel with EXCEL updates, as we experienced more frequent crashing on 1705 and lower of EXCEL.

I also recommend you lock down your Registry settings for Smart View, to prevent EXCEL pushing the Smart View add in into Disabled items each time it does crash, if you already have not done so.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 16 2016
Added on Feb 11 2016
#jdbc, #sql-developer
3 comments
2,583 views