[JBoss JIRA] (ISPN-7252) "ORA-00942: table or view does not exist" when starting the server with Oracle cache store
by Gustavo Fernandes (JIRA)
[ https://issues.jboss.org/browse/ISPN-7252?page=com.atlassian.jira.plugin.... ]
Gustavo Fernandes updated ISPN-7252:
------------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request: https://github.com/infinispan/infinispan/pull/4689
> "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
>
> 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)
8 years
[JBoss JIRA] (ISPN-7252) "ORA-00942: table or view does not exist" when starting the server with Oracle cache store
by Gustavo Fernandes (JIRA)
[ https://issues.jboss.org/browse/ISPN-7252?page=com.atlassian.jira.plugin.... ]
Gustavo Fernandes updated ISPN-7252:
------------------------------------
Status: Open (was: New)
> "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
>
> 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)
8 years
[JBoss JIRA] (ISPN-7250) ORA-00928: missing SELECT keyword when inserting entry with Oracle cache store
by Gustavo Fernandes (JIRA)
[ https://issues.jboss.org/browse/ISPN-7250?page=com.atlassian.jira.plugin.... ]
Gustavo Fernandes updated ISPN-7250:
------------------------------------
Status: Open (was: New)
> 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
>
> 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)
8 years
[JBoss JIRA] (ISPN-7215) Administration console - upload of deployment artifact doesn't work
by Vladimir Blagojevic (JIRA)
[ https://issues.jboss.org/browse/ISPN-7215?page=com.atlassian.jira.plugin.... ]
Vladimir Blagojevic commented on ISPN-7215:
-------------------------------------------
[~ryanemerson] please help me here as this one is related to the bundling of our managementConsole.min.js file. This issue is not present in dev setup yet as soon as we move to building a single javascript file for deployment something goes wrong. It would be the best if we could avoid bundling and minifying altogether! At least for now
> Administration console - upload of deployment artifact doesn't work
> -------------------------------------------------------------------
>
> Key: ISPN-7215
> URL: https://issues.jboss.org/browse/ISPN-7215
> Project: Infinispan
> Issue Type: Bug
> Components: JMX, reporting and management
> Affects Versions: 9.0.0.Alpha4
> Reporter: Roman Macor
> Assignee: Ryan Emerson
> Attachments: Screen Shot 2016-11-21 at 8.36.46 AM.png, custom-store.jar
>
>
> Click on cache container -> Configuration -> Deployments -> upload -> Browse... -> select file -> click upload
> Result: nothing happens
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years