How to Fix Aqua Data Studio Crashes and Unstable Behavior

Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior.

Response

Jonathan Powers over 11 years ago
Unstable Behavior and Crashes Using ADS

JRE-related Issues
Please make sure to run ADS with the bundled JRE. ADS requires the Oracle (formerly Sun) JRE. The OpenJDK JREs that come with some OS installations are not adequate. ADS 8.0.x was released with JRE 1.6.0_16, but it is always a good approach to upgrade to the latest JRE version available from Oracle.

The latest JRE for Linux, Solaris, and Windows can be found here:

http://www.oracle.com/technetwork/java/javase/downloads/index.html

Older JREs are available at:

http://java.sun.com/products/archive/

You can update your ADS installation by doing the following:

Exit the ADS application.
Rename \jre to: jre_old
Download the JRE archive file into your folder.
Unzip it into your folder. This will create a folder named “jre” with the new JRE version.
Run ADS and confirm the Java version in Help->About->System:[java.version]
NOTE: Windows 7 GUI Issues – ADS 8.0.x was released with Java 1.6.0_16. Java 1.6.0_16 has minor GUI issues with Windows 7. This has been fixed in Java 1.6.0_18 and above.

On Mac OS X, the full SDK—with the JRE included—is provided with every Mac OS X installation. The file is located in: /System/Library/Frameworks/JavaVM.framework/Versions/1.x/ and is updated from Apple’s Software Update whenever Apple prepares a new version or patch. This means that you DO NOT need to install Java on a Mac. Apple will do this for you as long as you keep your system software up to date.

OpenGL/JOGL related GUI Issues
Aqua Data Studio includes charting functionality that takes advantage of Java bindings for OpenGL. Many GUI issues are related to OpenGL driver implementation with the video driver.

Please make sure you have up-to-date video drivers for your video card. Information about your driver can be found here:

In Windows:
Start – > Settings – > Control Panel – > Display Properties – > Advanced – > Adapter
The latest driver version can be downloaded from the vendor’s website.

You may also try reducing hardware acceleration of the video adapter:

In Windows:
Start – > Settings – > Control Panel – > Display Properties – > Advanced – > Troubleshoot – > [Hardware acceleration]

If reducing hardware acceleration fixes the problem, then the issue is either with the video card, or the video drivers. Please refer to the following ADS online documentation page for instructions on fixing this problem: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation/page/136/1.7+Charts+and+OpenGL+or+JOGL+Configuration
If the problem persists, remove the JOGL libraries and then restart ADS. ADS will be unable to find the libraries and will disable chart functionality.

“Oracle OCI” connections may cause crashes
If you are using an “Oracle OCI” connection, then you need to make sure to update the Oracle JDBC driver in \lib\drivers to the versions that come with the Oracle Client installation.

Please refer to the following documentation for instructions on updating the JDBC drivers:

https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation/page/209/3.4+Oracle+11g+JDBC+Drivers