 |
|
|
 |
|
 |
|
| Author |
Message |
|
|
Post subject: Oracle DB timestamp displays <Unknown>
 Posted: Oct 17, 2006 - 02:12 PM
|
|
Joined: Nov 05, 2004
Posts: 14
|
|
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
-launcher |
|
|
| |
|
|
|
 |
|
|
|
Post subject:
Posted: Oct 17, 2006 - 06:43 PM
|
|
Moderator
Joined: Jan 06, 2004
Posts: 23459
|
|
| What JDBC driver did you configure to connect to the Oracle DB? Also which version of Oracle are you using? |
_________________
Riyad
MyEclipse Support
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Oct 18, 2006 - 06:15 PM
|
|
Moderator
Joined: Feb 03, 2006
Posts: 1117
|
|
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.
Regards,
Peco |
|
|
| |
|
|
|
|
|
|
| |
|
|
 |
|
 |
|
|
|
|
Search
Register
Log in to check your private messages
