Hi, Create public synonyms for those objects and they should work.
-Jukka Rahkonen- -----Alkuperäinen viesti----- Lähettäjä: Bart van den Eijnden (OSGIS) [mailto:bart...@osgis.nl] Lähetetty: ti 31.8.2010 14:51 Vastaanottaja: Andrea Aime Kopio: geoserver-users@lists.sourceforge.net Aihe: Re: [Geoserver-users] accessing Oracle table under a different user Ah right, does this work this way, I did not know. I did not specify any schema in the datastore, and it's not really a viable option for our setup, since that read-only user accesses about 25 different schemas (or even more) .... I'll open up a JIRA enhancement issue if there is none for this already. Best regards, Bart > Bart van den Eijnden (OSGIS) ha scritto: >> Hi list, >> >> I am trying to publish an Oracle table (using NG datastore) which is in >> schema WEGEN (so full name of my table is >> WEGEN. SPOORWEGEN_TREINSTATIONS), however I am trying to access the >> table >> through an Oracle user which has sufficient rights to read the table >> (the >> user is called RWS_LEZEN). > > What schema did you pass to the Oracle store? > It should be able to read the tables within that schema fine, the moment > you start trying to access tables outside of it trouble arises, the > code is not really well setup to read from multiple schemas (as we don't > store the schema in which each table was found atm) > > Cheers > Andrea > >> This setup does not seem to work in Geoserver 2.0.2? Am I missing >> something? >> >> It can find the actual table, but when trying to publish it I get an >> exception: >> >> Caused by: java.io.IOException: Error looking up primary key >> at >> org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:825) >> at >> org.geotools.jdbc.JDBCFeatureSource.<init>(JDBCFeatureSource.java:76) >> at >> org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:709) >> at >> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:383) >> at >> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:348) >> at >> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:647) >> at >> org.geoserver.catalog.CatalogBuilder.buildFeatureType(CatalogBuilder.java:324) >> at >> org.geoserver.web.data.layer.NewLayerPage.buildLayerInfo(NewLayerPage.java:198) >> ... 71 more >> Caused by: java.sql.SQLException: ORA-00942: table or view does not >> exist >> >> at >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) >> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) >> at >> oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) >> at >> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) >> at >> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) >> at >> oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614) >> at >> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579) >> at >> oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3485) >> at >> org.geotools.jdbc.HeuristicPrimaryKeyFinder.getPrimaryKey(HeuristicPrimaryKeyFinder.java:65) >> at >> org.geotools.jdbc.CompositePrimaryKeyFinder.getPrimaryKey(CompositePrimaryKeyFinder.java:42) >> at >> org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:813) >> ... 78 more >> >> TIA. >> >> Best regards, >> Bart >> >> >> ------------------------------------------------------------------------------ >> This SF.net Dev2Dev email is sponsored by: >> >> Show off your parallel programming skills. >> Enter the Intel(R) Threading Challenge 2010. >> http://p.sf.net/sfu/intel-thread-sfd >> _______________________________________________ >> Geoserver-users mailing list >> Geoserver-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > -- > Andrea Aime > OpenGeo - http://opengeo.org > Expert service straight from the developers. > ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users