Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
None
Description
When trying to use schema in table cache with oracle.
Received java.sql.SQLException, because in method indexExists is used toString from object TableName, and the drive oracle is validating the name table.
The correct is pass separated schema and table name, even though the ISPN-7252 fix the error table or view not exist, the root this error is because missing quote.
infinispan_1 | 2022-01-27 21:57:12,434 DEBUG (main) [org.infinispan.persistence.manager.PersistenceManagerImpl] PersistenceManagerImpl encountered an exception during startup of stores java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: java.sql.SQLException: Invalid argument(s) in call infinispan_1 | at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314) infinispan_1 | at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319) infinispan_1 | at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1739) infinispan_1 | at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) infinispan_1 | at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1982) infinispan_1 | at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) infinispan_1 | at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) infinispan_1 | at java.base/java.lang.Thread.run(Thread.java:829) infinispan_1 | Caused by: org.infinispan.persistence.spi.PersistenceException: java.sql.SQLException: Invalid argument(s) in call infinispan_1 | at org.infinispan.persistence.jdbc.impl.table.OracleTableManager.indexExists(OracleTableManager.java:64) infinispan_1 | at org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.createIndex(AbstractTableManager.java:158) infinispan_1 | at org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.start(AbstractTableManager.java:90) infinispan_1 | at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.initializeConnectionFactory(JdbcStringBasedStore.java:188) infinispan_1 | at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.start(JdbcStringBasedStore.java:124) infinispan_1 | at org.infinispan.persistence.support.NonBlockingStoreAdapter.lambda$start$0(NonBlockingStoreAdapter.java:108) infinispan_1 | at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1736) infinispan_1 | ... 5 more infinispan_1 | Caused by: java.sql.SQLException: Invalid argument(s) in call infinispan_1 | at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3792) infinispan_1 | at org.infinispan.persistence.jdbc.impl.table.OracleTableManager.indexExists(OracleTableManager.java:56) infinispan_1 | ... 11 more
