Hi List,
I'm getting the following in my logs.
2014-04-22 14:48:03,547 WARN [geotools.jdbc] - Failure occurred while
> looking up the primary key with finder:
> org.geotools.jdbc.HeuristicPrimaryKeyFinder@e944077
> java.sql.SQLException: ORA-01031: insufficient privileges
> 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.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
> at
> org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
> at
> org.geotools.jdbc.HeuristicPrimaryKeyFinder.getPrimaryKey(HeuristicPrimaryKeyFinder.java:69)
> at
> org.geotools.jdbc.CompositePrimaryKeyFinder.getPrimaryKey(CompositePrimaryKeyFinder.java:52)
I'd like to give my Oracle user the right permissions, but from the error
we (including the DBA's) can't figure out what GeoServer is doing and
therefore what permissions are required. Does anyone know what priviledges
we need to give to the database to get this to disappear?
Thanks,
Jonathan
--
This transmission is intended for the named addressee(s) only and may
contain sensitive or protectively marked material up to RESTRICTED and
should be handled accordingly. Unless you are the named addressee (or
authorised to receive it for the addressee) you may not copy or use it, or
disclose it to anyone else. If you have received this transmission in error
please notify the sender immediately. All email traffic sent to or from us,
including without limitation all GCSX traffic, may be subject to recording
and/or monitoring in accordance with relevant legislation.
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
