[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [dtp-dev] Display options when data types are unknown
|
Hey John,
Perhaps setting the value to something like "unknown" would better for
these types of cases.
Just my two cents.
Rob
dtp-dev-bounces@xxxxxxxxxxx wrote on 02/01/2006 12:44:44 PM:
>
> On the newsgroup it was reported that data types for columns in
PostgreSQL
> tables are not appearing correctly in the DSE (see attached "before"
> image). We've determined that, at least in this case, the value
"_varchar"
> is being passed back from the JDBC driver (not "varchar"), and this type
> does not map to one contained in the predefined models.
>
> Looking into the code, I find the following in
> org.eclipse.datatools.connectivity.sqm.internal.core.rte.jdbc.
> JDBCTable#loadColumns
> [org.eclipse.datatools.connectivity.sqm.core plug-in]:
>
> System.out.println("Unresolved datatype: " + typeName); //$NON-NLS-1$
> Iterator it = databaseDefinition.getPredefinedDataTypes();
> while (it.hasNext()) {
> PredefinedDataTypeDefinition datatype =
> (PredefinedDataTypeDefinition)it.next();
> PredefinedDataType type =
> databaseDefinition.getPredefinedDataType(datatype);
> column.setContainedType(type);
> break;
> }
>
> I'm not sure about the intention of this code. If it is commented out and
> the sample table is explored in DSE, no data type is shown (see attached
> "after" image). It seems to me that no data types being displayed is less
> confusing than the incorrect one.
>
> Any comments?
>
> Regards,
> John Graham
> Staff Software Engineer
> Sybase, Inc.
>
> (See attached file: data_types_after.JPG)(See attached file:
> data_types_before.JPG)[attachment "data_types_after.JPG" deleted by
> Rob Cernich II/SYBASE] [attachment "data_types_before.JPG" deleted
> by Rob Cernich II/SYBASE] _______________________________________________
> dtp-dev mailing list
> dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev