Community
Participate
Working Groups
The DTP plugin doesn't seem to properly handle columns of type TIMESTAMP. 1. When viewing table columns, TIMESTAMP columns appear as blanks (see screenshot #3) 2. When trying to enter edit mode via Data -> Edit, error messages appear (screenshot #1 then #2), and edit mode does not activate. Also, exception gets logged in the error log (see attached) 3. When generating DDL for the table, TIMESTAMP columns appear as "null" (see script.sql) The original table DDL is attached as ddl.sql Database is Oracle 9.2.0.4, using JDBC driver ojdbc14.jar Eclipse is 3.3RC1, DTP version 1.5
Created attachment 69699 [details] error message #1
Created attachment 69700 [details] error message #2
Created attachment 69701 [details] table explorer view
Created attachment 69702 [details] original table DDL
Created attachment 69703 [details] DTP-generated DDL
Created attachment 69705 [details] error log export
The exception is coming from SQL tools. As for the TIMESTAMP problem, I think this is an enablement concern (i.e. specialized support for Oracle).
changing target back to 1.5 in case the exception needs to be corrected for europa.
AFAIK, TIMESTAMP is a standard SQL92 data type, not an Oracle-specific feature.
Problem 1-- this is caused by the catalog loader. If there does not exist Oracle SQL Model/catalog loader, then the generic SQL Model/catalog log loader caused this problem. Problem 3-- the DDL gen code is part of the SQL Model framework, unless there exists Oracle SQL Model/Catalog Loader implementations, we cannot expect the generic catalog loader/SQL Model to generate the correct DDL code; need to extend/specialize the base SQL Model/Catalog Loader and implement the DDL Gen code. John, please assign to the proper owner.
Based on Hung's comments, this would require further enablement work for Oracle. For consideration in future versions of DTP Enablement.
Any updates on this issue? Sorry to be persistent, but, without specialized support for real production databases, DTP has near zero usefulness
get http://www.oracle.com/technology/tech/eclipse/dtp
Thanks! Though it looks like there's still a long way to go towards full Oracle support (TIMESTAMP columns are RAW now, foreign keys not picked up, etc.), it's still a huge step in the right direction, as the DTP doesn't bomb out with an error anymore, at least :) Now, did anyone in DTP team ever considered approaching Oracle for the source of their plugin? After all, Oracle itself would probably be interested in updating their plugin from DTP 1.0 to 1.5...
I have a similar problem with the JTA validator, it seems to give up processing a table once it encounters a field of type timestamp. In the Data Source Explorer it also only displays the fields of a table upto the first timestamp field. This means that I have 97 errors in the problems view that are really not errors.
We are closing this as WONTFIX due to lack of resource to work on it. If someone feels strongly that the problem should be fixed, please reopen, preferably with a patch for the fix. Please see comments 13 and later about obtaining updated Oracle enablement plugins directly from Oracle. It would be great if Oracle would contribute those to DTP.