I assume this is related to the bug I submitted a while back, but for PostGIS: http://jira.codehaus.org/browse/GEOT-896
I thought it was fixed in the 2.2 release, as it was listed in the release notes. Upon inspecting Jira, though, it appears the bug wasn't closed. Don't know what that means. I haven't downloaded the 2.2 final release yet to test the PostGIS version of schemas to verify the fix. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kari Maijala Sent: Tuesday, August 22, 2006 2:09 AM To: [email protected] Subject: [Geotools-gt2-users] OracleDataStore: schema name omitted in queries 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:6 72) at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.ja va:78) at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollec tion.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 ------------------------------------------------------------------------- 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
