Application: gvSIG desktop

	private static final String[] GEOM_SQL_TYPE_NAMES ={

	      "GEOMETRY",

	      "POINT",

	      "LINESTRING",

	      "POLYGON",

	      "MULTIPOINT",

	      "MULTILINESTRING",

	      "MULTIPOLYGON",

	      "GEOMETRYCOLLECTION",

	};

/**

 * Gets the table's possible geometry fields. By default, all fields can be geometry

 * fields. It should be overwritten by subclasses.

 *

 * @param conn conenction object

 * @param table_name table name

 * @return the table's possible geometry fields

 * @throws SQLException

 */

public String[] getGeometryFieldsCandidates(IConnection conn, String table_name) throws DBException {

	try {

		Statement st = ((ConnectionJDBC)conn).getConnection().createStatement();

		ResultSet rs = st.executeQuery("select * from " + table_name + " where false");

		ResultSetMetaData rsmd = rs.getMetaData();

		ArrayList names = new ArrayList();

		ResultSetMetaData rsMeta = rs.getMetaData();

		boolean isGeo;

		for (int i = 0; i < rsMeta.getColumnCount(); i++) {

			isGeo = false;

			System.out.println(rsMeta.getColumnName(i+1));

			for (int j = 0;j< GEOM_SQL_TYPE_NAMES.length;j++){

				rsMeta.getColumnType(i+1);

				System.out.println(rsMeta.getColumnTypeName(i+1));

				if (GEOM_SQL_TYPE_NAMES[j].equalsIgnoreCase(rsMeta.getColumnTypeName(i+1))){

					isGeo = true;

					break;

				}

			}

			if (isGeo || "UNKNOWN".equalsIgnoreCase(rsMeta.getColumnTypeName(i+1))){

				names.add(rsMeta.getColumnName(i+1));

			}

		}

		rsMeta = null;

		rs.close(); st.close();

		return (String[]) names.toArray(new String[names.size()]);

    	} catch (SQLException e) {

			throw new DBException(e);

		}

}