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!

SQL Dev + Mountain Lion, can't view data

1043586Sep 26 2013 — edited Sep 30 2013

I just upgraded to Mountain Lion (from Snow Leopard) and I'm having all kinds of issues.  I can connect to my databases (via same tnsnames file) but I can't run queries or view data.  I can even view table listings, but not their data, or meta data (constraints etc).  Anyone else having this issue?  I'm running v4, but I've also downgraded and tried running 3.2 with the exact same issue.  Here's some info:

Error:

Source: oracle.dbtools.raptor.utils.Connections

Message: For input string: ""

System info:

$ java -versionjava version "1.7.0_40"

Java(TM) SE Runtime Environment (build 1.7.0_40-b43)

Java HotSpot(TM) 64-Bit Server VM (build 24.0-b56, mixed mode)

/usr/libexec/java_home -V

Matching Java Virtual Machines (3):

    1.7.0_40, x86_64:   "Java SE 7"     /Library/Java/JavaVirtualMachines/jdk1.7.0_40.jdk/Contents/Home

    1.6.0_51-b11-457, x86_64:   "Java SE 6"     /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home

    1.6.0_51-b11-457, i386:     "Java SE 6"     /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home

/Library/Java/JavaVirtualMachines/jdk1.7.0_40.jdk/Contents/Home

I've tried several things like specifying the SetJavaHome value inside sqldeveler-Darwin.conf (for both v4 and 3.2) but again always this same issue.  Help and thanks!
This post has been answered by 1043586 on Sep 30 2013
Jump to Answer

Comments

1043586
Answer

Solved:

My SQL Array Fetch Size value was blank.  (Pref -> Database -> Advanced).  I had set it to 1000 or so a while back (2+ years), but apparently more than 500 crashes now.

Posting resolution here in case this ever happens to someone else. 

Marked as Answer by 1043586 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 28 2013
Added on Sep 26 2013
#developer, #sql, #sql-developer
1 comment
255 views