Hi,
I'm trying to call methods getFeatureSource or
getFeatureReader belonging to OracleDataStore class.
The calls fail to ORA-00942. This is because
OracleDatastore omits schema name from the sql query
and refers to the table name without schema name.
I have set the schema name correctly:
dstore = new OracleDataStore(cPool, my_schema_name,
new HashMap());
I have gt2-2.2.0.
Here is part of the stack trace.
ORA-00942: table or view does not exist
...
at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:922)
at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:672)
at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
at
org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:225)
at
org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:201)
...
The error message was like
SEVERE: Error Performing SQL query: SELECT "ABC",
"CDE", "EFG" FROM "MY_TABLE"
Note the missing schema name before "MY_TABLE". There
should be "THE_SCHEMA"."MY_TABLE".
Should I file a bug or am I doing something wrong?
Regards,
Kari M
___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" The
Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
