Oracle DB timestamp displays

MyEclipse Archived

>

Bugs

This topic has 2 replies, 3 voices, and was last updated 18 years, 3 months ago by Haris Peco.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
October 17, 2006 at 8:12 am #260544 Reply

asdf999
Member

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

October 17, 2006 at 12:43 pm #260583 Reply

Riyad Kalla
Member

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

October 18, 2006 at 12:15 pm #260638 Reply

Haris Peco
Member

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
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)