Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-7252

"ORA-00942: table or view does not exist" when starting the server with Oracle cache store

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.0.0.Beta1
    • 9.0.0.Alpha4
    • Loaders and Stores
    • None

    Description

      Exception thrown during start. The tables are created successfully on Oracle, but during the index check it throws:

      Caused by: org.infinispan.persistence.spi.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.timestampIndexExists(AbstractTableManager.java:151)
	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.createTimestampIndex(AbstractTableManager.java:127)
	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.start(AbstractTableManager.java:61)
	at org.infinispan.persistence.jdbc.common.AbstractJdbcStore.initializeConnectionFactory(AbstractJdbcStore.java:163)
	at org.infinispan.persistence.jdbc.common.AbstractJdbcStore.start(AbstractJdbcStore.java:55)
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.start(JdbcStringBasedStore.java:95)
	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$start$0(PersistenceManagerImpl.java:156)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.infinispan.persistence.manager.PersistenceManagerImpl.start(PersistenceManagerImpl.java:172)

      Attachments

        Activity

          People

            gfernand@redhat.com Gustavo Fernandes (Inactive)
            gfernand@redhat.com Gustavo Fernandes (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: