This content has been marked as final. Show 8 replies
You probably need to elaborate a bit more about the precise test case and your environment (OS, Java version). On Windows 7 64-bit, using 32-bit 3.2.10.09.57 and jdk1.6.0_35 the test case
select count(*) from dualseems to work fine.
One other issue with script output has been reported, but it probably is not related to the behavior you are experiencing:
Re: Bug with latest SQLDeveloper with numbers beyond Java's MAXINT
SQL Developer Team
This is part of Help->About->Version->Export->To Clipboard action.
Oracle SQL Developer 3.2.10.09
Copyright © 2005, 2012 Oracle. All Rights Reserved.
IDE Version: 18.104.22.168.37.59.48
Product ID: oracle.sqldeveloper
Product Version: 11.2.0.09.57
Java(TM) Platform 1.6.0_24
Oracle IDE 3.2.10.09.57
Versioning Support 3.2.10.09.57
OS is Ubuntu 12.10 64bit, java is from openjdk-6-jdk of version 6b24-1.11.4-3ubuntu1.
Searching the forum, I see a similar complaint noted against 3.1.07.42. Run statement produces query results showing oracle.sql.NUMBER, possibly due to a corrupt install (either due to unzip issues, or possibly not unzipping into an empty directory). See the following thread:
SQLDev 3.1: Number-Fields in tables show "oracle.sql.NUMBER@..."
Hope this helps,
SQL Developer Team
I will try to reinstall it carefully and then provide a feedback.
It seems that this is exactly my issue.
But I'm thinking now how to fix it. There is only one download option for Ubuntu and it is downloaded and unpacked correctly I'm sure.
openjdk has no file tzmappings and zi directory and I see no other options to get them rather than installing of Sun's java or coping them from Windows machine...
Among my various Sun/Oracle java installs, I also have openjdk-6.0.21 for Windows. Its jre\lib contains the zi directory and the tzmappings file. I started up SQL Developer 3.2.1 directly with its java.exe (bypassing our own sqldeveloper.exe which blocks start-up due to a version checking (format) issue with openjdk).
With this configuration I was not able to reproduce the oracle.sql.NUMBER issue using "select count(*) from dual".
So I'm not sure if your environment poses any special obstacles, but there must be some way for you to get the correct combination of items installed to overcome this issue. Hope it will not be too painful.
It appears as though you'll need the official oracle java. I installed oracle-java7-installer from a ppa (http://www.webupd8.org/2012/01/install-oracle-java-jdk-7-in-ubuntu-via.html), and the number nonsense is fixed.1 person found this helpful
You might want to actually use java6, but java7 is working for me.
That's it, I've copied those files from my Win7 java installation and it works now.