Hi Henry,
I am not exactly sure what you mean. It sounds like you just want to get
the column_name values of the geometry_columns table? This is done with
a standard result set:
Statement st = ..;
ResultSet rs = st.executeQuery("SELECT column_name from geomtrey_columns");
while(rs.next()) {
rs.getString("column_name");
}
Apologies if i misunderstood the question.
Also take a look at the PostgisDialect class. It uses the same table so
should prove to be a good template.
-Justin
On 3/8/10 8:04 AM, Henry Chow wrote:
> Hi all,
>
> My name is Henry, I am a developer for Ingres working on the UCOSP
> project along with Lim, Anthony, and Xiaoxiao. I am trying to retrieve
> the "column_name" field in the "geometry_columns" table in the
> database. I am calling this from the getMapping method of the
> IngresDialect class. When I use a ResultSet to call getString (i.e.:
> columnMetaData.getString(COLUMN_NAME); where columnMetaData is of
> ResultSet type), I am getting values like "intproperty",
> "doubleproperty", and "stringproperty". When I check the values in the
> database, the value under the "column_name" field is "geometry" or
> "location".
>
> Is there a way that I can retrieve the same values as what I see in the
> database for the column_name field? That is, when I call getString for
> the column_name field, I will get "geometry" or "location" as what I see
> in the database table. Or is there some function I am not aware of that
> does this conversion?
>
> Thanks for your help!
>
> Cheers,
> Henry
>
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
>
>
>
> _______________________________________________
> Geotools-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
