Extending/Fixing DatabaseDefinitionImpl [message #21243] |
Wed, 06 September 2006 22:50 |
Eclipse User |
|
|
|
Originally posted by: charles.eutsler.ncr.com
I am having trouble generating the DDL for a Table that contains a column
whose PredefinedDataType's PrimitiveType is PrimitiveType.TIME where the
PredefinedDataType supports precision. Basically, I want to generate a
column whose type is "TIME(3)".
The problem comes down to the getPredefinedDataTypeFormattedName method in
org.eclipse.datatools.connectivity.sqm.internal.core.definit ion.DatabaseDefinitionImpl.
That method does not take into account cases where a PrivitiveType.TIME
supports precision. It simply returns predefinedDataType.getName() as the
type's formatted name. It seems to me that it should check if the type
supports precision and, if it does, include the precision in parentheses
(just as is done for TIMESTAMP).
As far as I can tell, I am unable to extend the DatabaseDefinitionImpl
class to work around this problem. The DatabaseDefinitionRegistryImpl
creates instances of the DatabaseDefinitionImpl for each of the plug-ins
that extend the databaseDefinition extension point. That class doesn't
seem to give me the opportunity to provide a class that implements the
DatabaseDefinition interface that provides for my special needs.
A second problem along this line is that I will be wanting to generate
columns whose type is "TIME(n) WITH TIME ZONE". (Also "TIMESTAMP(n) WITH
TIME ZONE".) It seems to me that this would be accomplished if the TIME
and TIMESTAMP cases in the getPredefinedDataTypeFormattedName method would
check to see if the type supports a display name and, if so, inserts the
precision into the display name using the MessageFormat.format method in
the way as is done for the BINARY and INTERVAL types.
Are these problems that should be addressed in the DatabaseDefinitionImpl
class or is there some way that I can provide a class that extends
DatabaseDefinitionImpl (or otherwise implements DatabaseDefinition) so
that I can provide my own support for these types?
Thanks.
--Charles Eutsler
|
|
|
Re: Extending/Fixing DatabaseDefinitionImpl [message #21822 is a reply to message #21243] |
Tue, 26 September 2006 23:49 |
Eclipse User |
|
|
|
Originally posted by: charles.eutsler.ncr.com
I hope I'm not being a pest here by trying to resurrect my question but
I'm still wondering if anybody has suggestions for me. I'm afraid that my
question has gone so far down the list that it is not being seen.
Thanks for any help you can give.
--Charles
|
|
|
Re: Extending/Fixing DatabaseDefinitionImpl [message #21867 is a reply to message #21822] |
Thu, 28 September 2006 11:16 |
Eclipse User |
|
|
|
Originally posted by: merks.ca.ibm.com
Charles,
Your issue seem pretty straightforward and in need of an answer. Perhaps
you should describe it in a bugzilla report. Those are harder to
overlook. ;-)
Charles Eutsler wrote:
> I hope I'm not being a pest here by trying to resurrect my question
> but I'm still wondering if anybody has suggestions for me. I'm afraid
> that my question has gone so far down the list that it is not being seen.
>
> Thanks for any help you can give.
>
> --Charles
>
|
|
|
|
Re: Extending/Fixing DatabaseDefinitionImpl [message #582482 is a reply to message #21822] |
Thu, 28 September 2006 11:16 |
Ed Merks Messages: 33142 Registered: July 2009 |
Senior Member |
|
|
Charles,
Your issue seem pretty straightforward and in need of an answer. Perhaps
you should describe it in a bugzilla report. Those are harder to
overlook. ;-)
Charles Eutsler wrote:
> I hope I'm not being a pest here by trying to resurrect my question
> but I'm still wondering if anybody has suggestions for me. I'm afraid
> that my question has gone so far down the list that it is not being seen.
>
> Thanks for any help you can give.
>
> --Charles
>
Ed Merks
Professional Support: https://www.macromodeling.com/
|
|
|
Powered by
FUDForum. Page generated in 0.02896 seconds