Well spotted. Yes, we have seen this one before:
https://osgeo-org.atlassian.net/browse/GEOT-4512
On 14/06/15 02:29, Andrea Aime wrote:
> Hi,
> it looks like the Oracle user the tests are connecting with
> does not have sufficient permissions, in particular, the
> following command fails:
>
> run("CREATE SYNONYM ftnsyn FOR ftntable");
>
> with the error:
>
> Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.702
> sec <<< FAILURE! - in
> org.geotools.data.oracle.OracleTypeNamesOnlineTest
> testTypeNames(org.geotools.data.oracle.OracleTypeNamesOnlineTest)
> Time elapsed: 0.7 sec <<< ERROR!
> java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
>
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
> at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
> at
> oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
> at
> oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
> at
> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at
> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at
> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.geotools.jdbc.JDBCTestSetup.run(JDBCTestSetup.java:162)
> at org.geotools.jdbc.JDBCTestSetup.run(JDBCTestSetup.java:127)
> at
> org.geotools.data.oracle.OracleTypeNamesTestSetup.createTypes(OracleTypeNamesTestSetup.java:34)
> at
> org.geotools.jdbc.JDBCTypeNamesTestSetup.setUpData(JDBCTypeNamesTestSetup.java:40)
> at org.geotools.jdbc.JDBCTestSupport.connect(JDBCTestSupport.java:132)
> at org.geotools.test.OnlineTestCase.setUp(OnlineTestCase.java:243)
> at junit.framework.TestCase.runBare(TestCase.java:139)
> at junit.framework.TestResult$1.protect(TestResult.java:122)
> at junit.framework.TestResult.runProtected(TestResult.java:142)
> at junit.framework.TestResult.run(TestResult.java:125)
> at junit.framework.TestCase.run(TestCase.java:129)
> at org.geotools.test.OnlineTestCase.run(OnlineTestCase.java:123)
> at junit.framework.TestSuite.runTest(TestSuite.java:255)
> at junit.framework.TestSuite.run(TestSuite.java:250)
> at
> org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
> at
> org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
> at
> org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
> at
> org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
>
>
> Looks like we're missing a GRANT there.
>
> Cheers
> Andrea
>
>
>
> ------------------------------------------------------------------------------
>
>
>
> _______________________________________________
> GeoTools-Devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
--
Ben Caradoc-Davies <[email protected]>
Director
Transient Software Limited <http://transient.nz/>
New Zealand
------------------------------------------------------------------------------
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
