Folks,
I've created a featuretype based on this View in DSB2:
create view meteomarino1
as select zonemarine.SE_ROW_ID AS SE_ROW_ID, zonemarine.shape AS SHAPE, "site"."name" AS NOME, "sea_info"."seaInfo_id_OWN" AS ID,
"sea_info"."strength" AS MARE, "sea_info"."windStrength" AS VENTO,
"sea_info"."windDirection" AS DIREZIONE
from zonemarine, "site", "sea_info"
where
"site"."id" = "sea_info"."seaInfo_id_OWN" and
UPPER("site"."name") = UPPER(zonemarine.nome) and
"sea_info"."date" = 1;
But I'm not able to see its data view GetFeature (though it was created correctly and is shown in the WFS capabilities), since a strange "NULL" column appears in the SQL statement:
Oct 2, 2006 7:19:45 PM org.geotools.data.db2.DB2DataStore executeQuery
FINE: About to execute query: SELECT "null", "SE_ROW_ID", "SHAPE"..ST_AsText(), "NOME", "ID", "MARE", "VENTO", "DIREZIONE" FROM "LDASDB"."METEOMARINO1"
Oct 2, 2006 7:19:45 PM org.geotools.data.jdbc.ConnectionPool getConnection
FINE: Getting available connection.
Oct 2, 2006 7:19:45 PM org.geotools.data.db2.DB2DataStore executeQuery
SEVERE: Error Performing SQL query: SELECT "null", "SE_ROW_ID", "SHAPE"..ST_AsText(), "NOME", "ID", "MARE", "VENTO", "DIREZIONE" FROM "LDASDB"."METEOMARINO1"
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: null
at com.ibm.db2.jcc.b.zc.e(zc.java:1606)
at com.ibm.db2.jcc.b.zc.a(zc.java:1206)
at com.ibm.db2.jcc.a.db.h(db.java:149)
at com.ibm.db2.jcc.a.db.a(db.java:43)
at com.ibm.db2.jcc.a.r.a(r.java:30)
at com.ibm.db2.jcc.a.sb.g(sb.java:152)
at com.ibm.db2.jcc.b.zc.n(zc.java:1186)
at com.ibm.db2.jcc.b.zc.a(zc.java:1857)
at com.ibm.db2.jcc.b.zc.a(zc.java:497)
at com.ibm.db2.jcc.b.zc.executeQuery(zc.java:481)
at org.geotools.data.db2.DB2DataStore.executeQuery(DB2DataStore.java:396)
Regards,
--------------------
Luca Morandini
www.lucamorandini.it
--------------------