could the _  character in _default_auditing_options_   be causing issues?

if I tap on My Schema -> Tables   without expanding, the list comes up immediately but _default_auditing_options_   does not appear in the list.  I can only see _default_auditing_options_

  if I expand Tables in the schema browser and look for it.

_default_auditing_options_

will not appear in the quickfilter in the Detail View with Tables selected... however, it does appear in the Schema Browser under Tables when expanded.

If detail view is set to ON after you make the connection the problem does not accur,

but if detail view is set to on before connection is made then you will see the errors in the error log

This accurs on all versions of oracle... I can get a simular problem with TeraData but teradata jdbc but the driver seems to be ok after the first execeptions and then works from there on out.

I believe the error has to be in the jdbc driver but not 100% sure...

andy can you check to see if there is something working incorrectly in ctreenode...

It seems that we might have at lease 3 different issues here:

1. a large number of detail queries gets started - fixed.

2. when rapidly clicking on different nodes (tables, indexes, etc.), the oracle driver goes into inconsistent state:

               java.sql.SQLException: OALL8 is in an inconsistent state

   I've seen that happening before and it seemed at the time that this happens when multiple threads are calling the driver.  Niels says that showing the detail view in a background thread is a requirement (it takes a few seconds sometimes to extract the data), so we can't change that.  (The app seems to be ok after that exception is thrown so perhaps it's not an issue).

3. Missing _default_auditing_options_ table is not being listed in the detail frame.  Sending this to Ivan to investigate - see OraTablesNode.getDetailViewTableModel()

it seems #1 has not been fixed.

To reproduce:

1. Oracle 11g sys

2. enable detail view

3. my schema; click on Tables, wait for detail panel to populate

4. click on Tables' [+] expand icon

--> multiple threads are suddently created...

fixed #1: removed some really old unnecessary code.

Ivan, please investigate missing  _default_auditing_options_  table issue.

after discussion with niels, its ok not to show the _default_auditing_options_ table in the detail view.

fixed as of

Product: Aqua Data Studio
Version: 9.0.0-alpha1.21
Build #: 15148
Build Date: 2010-Jun-27 10:12:21 AM

Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_18-b07
Memory: Max=357,957,632;  Total=229,965,824;  Free=57,705,488;  CPUs=8

Graphics Vendor: NVIDIA Corporation
OpenGL Renderer: Quadro FX 1700/PCI/SSE2
OpenGL Version: 3.0.0
Double-buffering: ON
Anti-aliasing: ON
Anti-aliasing Sample Count: 2
Hardware Acceleration: ON
Hardware PBuffer Available: ON
Use PBuffer: ON
Use Ram Buffer: OFF
Offscreen Rendering: ON
Offscreen Buffer Size: 1600x1200
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 0
Depth Bits: 24
Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16