Windows XP SP 3 32 bit
Java(TM) Platform 1.6.0_11
Oracle IDE 3.1.07.42
Versioning Support 3.1.07.42
Installed SQL Developer 3.1.07.42 in a fresh directory. Imported Connections from SQL Dev. 3.0. Connected to a 9i/11g-database and did a select on an ordinary table in the worksheet. Get an error in the Logging Page - Log Window:
All NUMBER-Fileds are displayed with "oracle.sql.NUMBER@...", for example "oracle.sql.NUMBER@lb5889c". And everytime i select a field in this table the Logging-Page grows (actually 3674 entries). And it's regardless which table i select. This error occurs also in the table-data-grid.
Can you help?
Ok, I've got it:
in the SQLDev-installation-zip-file there is something missing (?):
the directory "zi" and the file "tzmappings" in C:\SQLDeveloper\jdk\jre\lib
I copied the folder and the file from the old 3.0-Installation and voila now i see numbers in the numbercolumns :-)
I don't know why this is missing. Have I done a mistake while downloading and unzipping? I don't know :-(
I usually download SQL Developer without the JDK, so I had to download sqldeveloper-3.1.07.42.zip to verify. Yes, in fact tzmappings and the zi are there, both when inspecting the archive and after performing unzip.
Something must have gone wrong with your download/unzip. Looking at various Java JDKs I have installed, or the Java that comes with Oracle 184.108.40.206, all have tzmappings and the zi directory. The file timestamps and the number of files in the zi directory may vary, but it should always be there in some form.
SQL Developer Team