Sorry about the previous post. I tested Geotools 2.2 with the PostGIS schema fixes and the schemas now seem to work fine. Thanks -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jody Garnett Sent: Thursday, August 24, 2006 5:17 AM To: [EMAIL PROTECTED] Cc: [email protected]; 'Kari Maijala' Subject: Re: [Geotools-gt2-users] OracleDataStore: schema name omitted in queries
It may of ment that we wanted your confirmation you were happy with the fix :-) Jody > 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 > ------------------------------------------------------------------------- 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
