[JBoss JIRA] (ISPN-7250) ORA-00928: missing SELECT keyword when inserting entry with Oracle cache store
by Ryan Emerson (JIRA)
[ https://issues.jboss.org/browse/ISPN-7250?page=com.atlassian.jira.plugin.... ]
Ryan Emerson resolved ISPN-7250.
--------------------------------
Fix Version/s: 9.0.0.Beta1
Resolution: Done
> ORA-00928: missing SELECT keyword when inserting entry with Oracle cache store
> ------------------------------------------------------------------------------
>
> Key: ISPN-7250
> URL: https://issues.jboss.org/browse/ISPN-7250
> Project: Infinispan
> Issue Type: Bug
> Components: Loaders and Stores
> Affects Versions: 9.0.0.Alpha4
> Reporter: Gustavo Fernandes
> Assignee: Gustavo Fernandes
> Fix For: 9.0.0.Beta1
>
>
> Tested with Oracle 11g express edition
> Example of query currently sent to Oracle:
> {code:sql}
> MERGE INTO "ISPN_cache" USING (VALUES ('Az4s','030',1)) AS tmp (datum, version, id) ON (datum = tmp.datum) WHEN MATCHED THEN UPDATE SET version = tmp.version, id = tmp.id WHEN NOT MATCHED THEN INSERT (datum, version, id) VALUES (tmp.datum, tmp.version, tmp.id)
> {code}
> which does not seem valid
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (ISPN-7252) "ORA-00942: table or view does not exist" when starting the server with Oracle cache store
by Ryan Emerson (JIRA)
[ https://issues.jboss.org/browse/ISPN-7252?page=com.atlassian.jira.plugin.... ]
Ryan Emerson resolved ISPN-7252.
--------------------------------
Fix Version/s: 9.0.0.Beta1
Resolution: Done
> "ORA-00942: table or view does not exist" when starting the server with Oracle cache store
> ------------------------------------------------------------------------------------------
>
> Key: ISPN-7252
> URL: https://issues.jboss.org/browse/ISPN-7252
> Project: Infinispan
> Issue Type: Bug
> Components: Loaders and Stores
> Affects Versions: 9.0.0.Alpha4
> Reporter: Gustavo Fernandes
> Assignee: Gustavo Fernandes
> Fix For: 9.0.0.Beta1
>
>
> Exception thrown during start. The tables are created successfully on Oracle, but during the index check it throws:
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months