Thread: How to get the contents field of a spatiallite sqlitejdbc?

Hi
I have this code:


statement.executeUpdate("SELECT AddGeometryColumn('areas', 'geom', 4326, 'POLYGON', 'XY')");

//Basic square
//String strSt="INSERT INTO areas VALUES (1, 'zoneA', GeomFromText('POINT(1 1)',4326))";
String strSt="INSERT INTO areas VALUES (1, 'zoneA', GeomFromText('POLYGON (0 0, 10 0, 10 10, 0 10)',4326))";
statement.executeUpdate(strSt);



strSt="select geom from areas where areas.label == 'zoneA'";
ResultSet rs=statement.executeQuery(strSt);
if(rs.next())
{

str=rs.getString("geom");


and it says that geom field does not exists.


Then I:

ResultSetMetaData rsmd = rs.getMetaData();
int numColumns = rsmd.getColumnCount();

// Get the column names; column indices start from 1
for (int i=1; i<numColumns+1; i++)
{
String columnName = rsmd.getColumnName(i);
String str= rsmd.getColumnTypeName(i);
int d= rsmd.getColumnType(i);
str2=rsmd.getColumnClassName(i);

columnname is 'geom'
str is null
d is 0
str2 is java.lang.Object


So how to get the value of the field?


Thanks a lot

Alex