MyEclipse: Oracle DB timestamp displays <Unknown> asdf999 - Oct 17, 2006 - 02:12 PM Post subject: Oracle DB timestamp displays <Unknown>
In DBExplorer from Oracle DB timestamp is not dipslayed(Unknown) when in DB is defined as TIMESTAMP WITH TIMEZONE. TIMESTAMP alone displays OK.
MyE:
Version: 5.0.0
Build id: 20060805-5.0-GA
E:
wt.toolkit=sun.awt.windows.WToolkit
eclipse.buildId=M20060629-1905
eclipse.commands=-os
win32
-ws
win32
-arch
x86
-launchersupport-rkalla - Oct 17, 2006 - 06:43 PM Post subject:
What JDBC driver did you configure to connect to the Oracle DB? Also which version of Oracle are you using?support-snpe - Oct 18, 2006 - 06:15 PM Post subject:
asdf999 ,
Oracle's JDBC driver return correct type for TIMESTAMP (TIMESTAMP=93) and nonstandard jdbc values -101,-102 for TIMESTAMP WITH TIMEZONE and
TIMESTAMP WITH LOCAL TIMEZONE.MyEclipse return 'Unknown' for every nonstandard type (or types OTHER=1001).I will file internal request for enhancement and we will try fix this.