[macohen]

I’m running MyEclipse 3.8.4 on Eclipse version 3.01 and I’m trying to use the SQL Editor to see Oracle 10g tables that include “timestamp with

timezone” and “Interval Day to Time” data types. I am on Windows 2000 5.00.2195. I am using the Oracle 10g jdbc driver: ojdbc14.jar.

Here is the table definition:

Create Table Mikey(
TSTAMP TIMESTAMP(6) WITH TIME ZONE,
IDAYTOSEC INTERVAL DAY(9) TO SECOND(6))”

I put a row into the table with this command:

Insert into mikey values (sysdate,’+000000000 01:05:21.234000′);

When I run “Select * from Mikey” in the SQL Editor, I get “<Unknown>” in the results section. The only way I can see the data is if I change

my query to use “to_char” for each data type, like so:

select to_char(tstamp),to_char(idaytosec) from mikey

Then I see the correct data in the results pane:

16-MAY-05 05.00.06.000000 PM -07:00 +000000000 01:05:21.234000

Does anyone know how to fix this without having to use the “to_char” workaround?

[Riyad Kalla]

I am looking into this.

[support-jeff]

What JDK version are you running? Wondering if this requires some funky JDBC3 support? I would check around the Oracle support sites as well.

[macohen]

I think it’s 1.4.2, based on the Guidepost startup command: “C:\Program Files\guidepost\eclipse\..\j2sdk1.4.2_05\jre\bin\javaw.exe” Oracle also ships the 1.4.2 jdk with 10g.

[Riyad Kalla]

I checkd a few google results of the Oracle 10g date commands and it seems that unknown is returned any time there is ambiguity with the decoding of the results (when using dates)… like Jeff suggested you might check the oracle support sites for more accurate help with this.

[Author]

Posts