Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
asdf999
Post subject: Oracle DB timestamp displays <Unknown>  PostPosted: 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
 
 View user's profile Send private message  
Reply with quote Back to top
support-rkalla
Post subject:   PostPosted: Oct 17, 2006 - 06:43 PM
Registered Member
Registered Member


Joined: Jan 06, 2004
Posts: 23855

What JDBC driver did you configure to connect to the Oracle DB? Also which version of Oracle are you using?

_________________
Riyad
MyEclipse Support
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
support-snpe
Post subject:   PostPosted: Oct 18, 2006 - 06:15 PM
Moderator
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
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits