You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Ioannis Vlachos <io...@gmail.com> on 2016/05/26 09:04:34 UTC
Problems installing openmeetings on Oracle DB
Hi.
I'm trying to install openmeetings on Oracle (through command line admin,
but I have problems. Any ideas would be appreciated.
First I had this exception:
Caused by: org.apache.openjpa.persistence.PersistenceException: ORA-00904:
: invalid identifier
{stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location
VARCHAR2(255), password VARCHAR2(255), is_password_protected NUMBER,
reminder VARCHAR2(20), is_reminder_email_send NUMBER, start TIMESTAMP,
appointmentname VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id
NUMBER, PRIMARY KEY (id))} [code=904, state=42000]
...
I tried to run the create command on sql developer (directly on oracle) and
I had the same error. It turns out that the error was caused by the *start
TIMESTAMP* column. The word "start" is reserved by oracle and needs
special treatment. So I ran the command through sql developer using *"START"
TIMESTAMP* (with the ") and the table was created. I ran again the admin
command line and it seemed to have created the DB.
Unfortunately, it crashes later on with the stacktrace shown at the end of
the mail. It seems to have something to do with the Naviglobal entity. Any
ideas?
2016-05-26 10:56:04,134 [main] ERROR org.apache.openmeetings.cli.Admin -
Install failed
org.springframework.orm.jpa.JpaSystemException: 10; nested exception is
<openjpa-2.4.1-r422266:1730418 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: 10
at
org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
at
org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$b65241b9.addGlobalStructure(<generated>)
at
org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
at
org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
at
org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
Caused by: org.apache.openjpa.persistence.PersistenceException: 10
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
... 13 common frames omitted
Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
at
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
at
oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
at
oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
at
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
at
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
at
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113)
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
at
org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
... 18 common frames omitted
Re: Problems installing openmeetings on Oracle DB
Posted by Maxim Solodovnik <so...@gmail.com>.
great!
please let me know if something else is broken under Oracle
I don't have it installed, so some issues might arise ....
On Fri, May 27, 2016 at 2:45 PM, Ioannis Vlachos <io...@gmail.com>
wrote:
> ok, SUCCESS.
> Downloaded latest build (with the renamed columns), dropped the database,
> rerun command line admin and everything worked ok.
> By the way, I'm using ojdbc7.jar for Oracle driver.
>
> Thanks a lot, great work
>
> 2016-05-26 13:10 GMT+03:00 Maxim Solodovnik <so...@gmail.com>:
>
>> Columns were renamed
>>
>> On Thu, May 26, 2016 at 3:16 PM, Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>> https://issues.apache.org/jira/browse/OPENMEETINGS-1410
>>>
>>> On Thu, May 26, 2016 at 3:10 PM, Maxim Solodovnik <so...@gmail.com>
>>> wrote:
>>>
>>>> According to this:
>>>> http://stackoverflow.com/questions/277744/jdbc-oracle-arrayindexoutofboundsexception
>>>> There seems to be an error in Oracle DB driver
>>>>
>>>> What driver are you using?
>>>>
>>>> On Thu, May 26, 2016 at 3:06 PM, Maxim Solodovnik <solomax666@gmail.com
>>>> > wrote:
>>>>
>>>>> I can fix "CREATE TABLE appointment" by renaming column in DB
>>>>> I need couple of minutes to check the code to understand what is wrong
>>>>> with naviglobal
>>>>>
>>>>> On Thu, May 26, 2016 at 3:04 PM, Ioannis Vlachos <
>>>>> ioannis.vlachos@gmail.com> wrote:
>>>>>
>>>>>> Hi.
>>>>>> I'm trying to install openmeetings on Oracle (through command line
>>>>>> admin, but I have problems. Any ideas would be appreciated.
>>>>>> First I had this exception:
>>>>>>
>>>>>> Caused by: org.apache.openjpa.persistence.PersistenceException:
>>>>>> ORA-00904: : invalid identifier
>>>>>> {stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
>>>>>> is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
>>>>>> icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
>>>>>> isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location
>>>>>> VARCHAR2(255), password VARCHAR2(255), is_password_protected NUMBER,
>>>>>> reminder VARCHAR2(20), is_reminder_email_send NUMBER, start TIMESTAMP,
>>>>>> appointmentname VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id
>>>>>> NUMBER, PRIMARY KEY (id))} [code=904, state=42000]
>>>>>> ...
>>>>>>
>>>>>> I tried to run the create command on sql developer (directly on
>>>>>> oracle) and I had the same error. It turns out that the error was caused by
>>>>>> the *start TIMESTAMP* column. The word "start" is reserved by
>>>>>> oracle and needs special treatment. So I ran the command through sql
>>>>>> developer using *"START" TIMESTAMP* (with the ") and the table was
>>>>>> created. I ran again the admin command line and it seemed to have created
>>>>>> the DB.
>>>>>>
>>>>>> Unfortunately, it crashes later on with the stacktrace shown at the
>>>>>> end of the mail. It seems to have something to do with the Naviglobal
>>>>>> entity. Any ideas?
>>>>>>
>>>>>> 2016-05-26 10:56:04,134 [main] ERROR
>>>>>> org.apache.openmeetings.cli.Admin - Install failed
>>>>>> org.springframework.orm.jpa.JpaSystemException: 10; nested exception
>>>>>> is <openjpa-2.4.1-r422266:1730418 nonfatal general error>
>>>>>> org.apache.openjpa.persistence.PersistenceException: 10
>>>>>> at
>>>>>> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
>>>>>> at
>>>>>> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
>>>>>> at
>>>>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
>>>>>> at
>>>>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
>>>>>> at
>>>>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
>>>>>> at
>>>>>> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
>>>>>> at
>>>>>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>>>>>> at
>>>>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>>>>>> at
>>>>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>>>>>> at
>>>>>> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
>>>>>> at
>>>>>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$b65241b9.addGlobalStructure(<generated>)
>>>>>> at
>>>>>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
>>>>>> at
>>>>>> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
>>>>>> at
>>>>>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
>>>>>> at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
>>>>>> at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
>>>>>> Caused by: org.apache.openjpa.persistence.PersistenceException: 10
>>>>>> at
>>>>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
>>>>>> at
>>>>>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
>>>>>> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
>>>>>> at
>>>>>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
>>>>>> at
>>>>>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
>>>>>> at
>>>>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
>>>>>> ... 13 common frames omitted
>>>>>> Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
>>>>>> at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
>>>>>> at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
>>>>>> at
>>>>>> oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
>>>>>> at
>>>>>> oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
>>>>>> at
>>>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
>>>>>> at
>>>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
>>>>>> at
>>>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
>>>>>> at
>>>>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>>>>> at
>>>>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>>>>> at
>>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
>>>>>> at
>>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
>>>>>> at
>>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>>>>> at
>>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>>>>> at
>>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
>>>>>> at
>>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
>>>>>> at
>>>>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>>>>> at
>>>>>> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
>>>>>> at
>>>>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>>>>> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
>>>>>> at
>>>>>> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
>>>>>> at
>>>>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
>>>>>> ... 18 common frames omitted
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> WBR
>>>>> Maxim aka solomax
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
--
WBR
Maxim aka solomax
Re: Problems installing openmeetings on Oracle DB
Posted by Ioannis Vlachos <io...@gmail.com>.
ok, SUCCESS.
Downloaded latest build (with the renamed columns), dropped the database,
rerun command line admin and everything worked ok.
By the way, I'm using ojdbc7.jar for Oracle driver.
Thanks a lot, great work
2016-05-26 13:10 GMT+03:00 Maxim Solodovnik <so...@gmail.com>:
> Columns were renamed
>
> On Thu, May 26, 2016 at 3:16 PM, Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>> https://issues.apache.org/jira/browse/OPENMEETINGS-1410
>>
>> On Thu, May 26, 2016 at 3:10 PM, Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>> According to this:
>>> http://stackoverflow.com/questions/277744/jdbc-oracle-arrayindexoutofboundsexception
>>> There seems to be an error in Oracle DB driver
>>>
>>> What driver are you using?
>>>
>>> On Thu, May 26, 2016 at 3:06 PM, Maxim Solodovnik <so...@gmail.com>
>>> wrote:
>>>
>>>> I can fix "CREATE TABLE appointment" by renaming column in DB
>>>> I need couple of minutes to check the code to understand what is wrong
>>>> with naviglobal
>>>>
>>>> On Thu, May 26, 2016 at 3:04 PM, Ioannis Vlachos <
>>>> ioannis.vlachos@gmail.com> wrote:
>>>>
>>>>> Hi.
>>>>> I'm trying to install openmeetings on Oracle (through command line
>>>>> admin, but I have problems. Any ideas would be appreciated.
>>>>> First I had this exception:
>>>>>
>>>>> Caused by: org.apache.openjpa.persistence.PersistenceException:
>>>>> ORA-00904: : invalid identifier
>>>>> {stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
>>>>> is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
>>>>> icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
>>>>> isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location
>>>>> VARCHAR2(255), password VARCHAR2(255), is_password_protected NUMBER,
>>>>> reminder VARCHAR2(20), is_reminder_email_send NUMBER, start TIMESTAMP,
>>>>> appointmentname VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id
>>>>> NUMBER, PRIMARY KEY (id))} [code=904, state=42000]
>>>>> ...
>>>>>
>>>>> I tried to run the create command on sql developer (directly on
>>>>> oracle) and I had the same error. It turns out that the error was caused by
>>>>> the *start TIMESTAMP* column. The word "start" is reserved by
>>>>> oracle and needs special treatment. So I ran the command through sql
>>>>> developer using *"START" TIMESTAMP* (with the ") and the table was
>>>>> created. I ran again the admin command line and it seemed to have created
>>>>> the DB.
>>>>>
>>>>> Unfortunately, it crashes later on with the stacktrace shown at the
>>>>> end of the mail. It seems to have something to do with the Naviglobal
>>>>> entity. Any ideas?
>>>>>
>>>>> 2016-05-26 10:56:04,134 [main] ERROR org.apache.openmeetings.cli.Admin
>>>>> - Install failed
>>>>> org.springframework.orm.jpa.JpaSystemException: 10; nested exception
>>>>> is <openjpa-2.4.1-r422266:1730418 nonfatal general error>
>>>>> org.apache.openjpa.persistence.PersistenceException: 10
>>>>> at
>>>>> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
>>>>> at
>>>>> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
>>>>> at
>>>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
>>>>> at
>>>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
>>>>> at
>>>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
>>>>> at
>>>>> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
>>>>> at
>>>>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>>>>> at
>>>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>>>>> at
>>>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>>>>> at
>>>>> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
>>>>> at
>>>>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$b65241b9.addGlobalStructure(<generated>)
>>>>> at
>>>>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
>>>>> at
>>>>> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
>>>>> at
>>>>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
>>>>> at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
>>>>> at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
>>>>> Caused by: org.apache.openjpa.persistence.PersistenceException: 10
>>>>> at
>>>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
>>>>> at
>>>>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
>>>>> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
>>>>> at
>>>>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
>>>>> at
>>>>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
>>>>> at
>>>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
>>>>> ... 13 common frames omitted
>>>>> Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
>>>>> at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
>>>>> at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
>>>>> at
>>>>> oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
>>>>> at
>>>>> oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
>>>>> at
>>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
>>>>> at
>>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
>>>>> at
>>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
>>>>> at
>>>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>>>> at
>>>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
>>>>> at
>>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
>>>>> at
>>>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>>>> at
>>>>> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
>>>>> at
>>>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>>>> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
>>>>> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
>>>>> at
>>>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
>>>>> ... 18 common frames omitted
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>
Re: Problems installing openmeetings on Oracle DB
Posted by Maxim Solodovnik <so...@gmail.com>.
Columns were renamed
On Thu, May 26, 2016 at 3:16 PM, Maxim Solodovnik <so...@gmail.com>
wrote:
> https://issues.apache.org/jira/browse/OPENMEETINGS-1410
>
> On Thu, May 26, 2016 at 3:10 PM, Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>> According to this:
>> http://stackoverflow.com/questions/277744/jdbc-oracle-arrayindexoutofboundsexception
>> There seems to be an error in Oracle DB driver
>>
>> What driver are you using?
>>
>> On Thu, May 26, 2016 at 3:06 PM, Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>> I can fix "CREATE TABLE appointment" by renaming column in DB
>>> I need couple of minutes to check the code to understand what is wrong
>>> with naviglobal
>>>
>>> On Thu, May 26, 2016 at 3:04 PM, Ioannis Vlachos <
>>> ioannis.vlachos@gmail.com> wrote:
>>>
>>>> Hi.
>>>> I'm trying to install openmeetings on Oracle (through command line
>>>> admin, but I have problems. Any ideas would be appreciated.
>>>> First I had this exception:
>>>>
>>>> Caused by: org.apache.openjpa.persistence.PersistenceException:
>>>> ORA-00904: : invalid identifier
>>>> {stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
>>>> is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
>>>> icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
>>>> isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location
>>>> VARCHAR2(255), password VARCHAR2(255), is_password_protected NUMBER,
>>>> reminder VARCHAR2(20), is_reminder_email_send NUMBER, start TIMESTAMP,
>>>> appointmentname VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id
>>>> NUMBER, PRIMARY KEY (id))} [code=904, state=42000]
>>>> ...
>>>>
>>>> I tried to run the create command on sql developer (directly on oracle)
>>>> and I had the same error. It turns out that the error was caused by the *start
>>>> TIMESTAMP* column. The word "start" is reserved by oracle and needs
>>>> special treatment. So I ran the command through sql developer using *"START"
>>>> TIMESTAMP* (with the ") and the table was created. I ran again the
>>>> admin command line and it seemed to have created the DB.
>>>>
>>>> Unfortunately, it crashes later on with the stacktrace shown at the end
>>>> of the mail. It seems to have something to do with the Naviglobal entity.
>>>> Any ideas?
>>>>
>>>> 2016-05-26 10:56:04,134 [main] ERROR org.apache.openmeetings.cli.Admin
>>>> - Install failed
>>>> org.springframework.orm.jpa.JpaSystemException: 10; nested exception is
>>>> <openjpa-2.4.1-r422266:1730418 nonfatal general error>
>>>> org.apache.openjpa.persistence.PersistenceException: 10
>>>> at
>>>> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
>>>> at
>>>> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
>>>> at
>>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
>>>> at
>>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
>>>> at
>>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
>>>> at
>>>> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
>>>> at
>>>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>>>> at
>>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>>>> at
>>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>>>> at
>>>> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
>>>> at
>>>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$b65241b9.addGlobalStructure(<generated>)
>>>> at
>>>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
>>>> at
>>>> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
>>>> at
>>>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
>>>> at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
>>>> at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
>>>> Caused by: org.apache.openjpa.persistence.PersistenceException: 10
>>>> at
>>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
>>>> at
>>>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
>>>> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
>>>> at
>>>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
>>>> at
>>>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
>>>> at
>>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
>>>> ... 13 common frames omitted
>>>> Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
>>>> at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
>>>> at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
>>>> at
>>>> oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
>>>> at
>>>> oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
>>>> at
>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
>>>> at
>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
>>>> at
>>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
>>>> at
>>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>>> at
>>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>>> at
>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
>>>> at
>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
>>>> at
>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>>> at
>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>>> at
>>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
>>>> at
>>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
>>>> at
>>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>>> at
>>>> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
>>>> at
>>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>>> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
>>>> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
>>>> at
>>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
>>>> ... 18 common frames omitted
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Problems installing openmeetings on Oracle DB
Posted by Maxim Solodovnik <so...@gmail.com>.
https://issues.apache.org/jira/browse/OPENMEETINGS-1410
On Thu, May 26, 2016 at 3:10 PM, Maxim Solodovnik <so...@gmail.com>
wrote:
> According to this:
> http://stackoverflow.com/questions/277744/jdbc-oracle-arrayindexoutofboundsexception
> There seems to be an error in Oracle DB driver
>
> What driver are you using?
>
> On Thu, May 26, 2016 at 3:06 PM, Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>> I can fix "CREATE TABLE appointment" by renaming column in DB
>> I need couple of minutes to check the code to understand what is wrong
>> with naviglobal
>>
>> On Thu, May 26, 2016 at 3:04 PM, Ioannis Vlachos <
>> ioannis.vlachos@gmail.com> wrote:
>>
>>> Hi.
>>> I'm trying to install openmeetings on Oracle (through command line
>>> admin, but I have problems. Any ideas would be appreciated.
>>> First I had this exception:
>>>
>>> Caused by: org.apache.openjpa.persistence.PersistenceException:
>>> ORA-00904: : invalid identifier
>>> {stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
>>> is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
>>> icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
>>> isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location
>>> VARCHAR2(255), password VARCHAR2(255), is_password_protected NUMBER,
>>> reminder VARCHAR2(20), is_reminder_email_send NUMBER, start TIMESTAMP,
>>> appointmentname VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id
>>> NUMBER, PRIMARY KEY (id))} [code=904, state=42000]
>>> ...
>>>
>>> I tried to run the create command on sql developer (directly on oracle)
>>> and I had the same error. It turns out that the error was caused by the *start
>>> TIMESTAMP* column. The word "start" is reserved by oracle and needs
>>> special treatment. So I ran the command through sql developer using *"START"
>>> TIMESTAMP* (with the ") and the table was created. I ran again the
>>> admin command line and it seemed to have created the DB.
>>>
>>> Unfortunately, it crashes later on with the stacktrace shown at the end
>>> of the mail. It seems to have something to do with the Naviglobal entity.
>>> Any ideas?
>>>
>>> 2016-05-26 10:56:04,134 [main] ERROR org.apache.openmeetings.cli.Admin -
>>> Install failed
>>> org.springframework.orm.jpa.JpaSystemException: 10; nested exception is
>>> <openjpa-2.4.1-r422266:1730418 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: 10
>>> at
>>> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
>>> at
>>> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
>>> at
>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
>>> at
>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
>>> at
>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
>>> at
>>> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
>>> at
>>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>>> at
>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>>> at
>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>>> at
>>> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
>>> at
>>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$b65241b9.addGlobalStructure(<generated>)
>>> at
>>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
>>> at
>>> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
>>> at
>>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
>>> at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
>>> at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
>>> Caused by: org.apache.openjpa.persistence.PersistenceException: 10
>>> at
>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
>>> at
>>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
>>> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
>>> at
>>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
>>> at
>>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
>>> at
>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
>>> ... 13 common frames omitted
>>> Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
>>> at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
>>> at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
>>> at
>>> oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
>>> at
>>> oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
>>> at
>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
>>> at
>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
>>> at
>>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
>>> at
>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>> at
>>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>>> at
>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
>>> at
>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>> at
>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>>> at
>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
>>> at
>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
>>> at
>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113)
>>> at
>>> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
>>> at
>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
>>> at
>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
>>> at
>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
>>> at
>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
>>> at
>>> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
>>> at
>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
>>> at
>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
>>> at
>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
>>> at
>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>> at
>>> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
>>> at
>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>>> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
>>> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
>>> at
>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
>>> ... 18 common frames omitted
>>>
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Problems installing openmeetings on Oracle DB
Posted by Maxim Solodovnik <so...@gmail.com>.
According to this:
http://stackoverflow.com/questions/277744/jdbc-oracle-arrayindexoutofboundsexception
There seems to be an error in Oracle DB driver
What driver are you using?
On Thu, May 26, 2016 at 3:06 PM, Maxim Solodovnik <so...@gmail.com>
wrote:
> I can fix "CREATE TABLE appointment" by renaming column in DB
> I need couple of minutes to check the code to understand what is wrong
> with naviglobal
>
> On Thu, May 26, 2016 at 3:04 PM, Ioannis Vlachos <
> ioannis.vlachos@gmail.com> wrote:
>
>> Hi.
>> I'm trying to install openmeetings on Oracle (through command line admin,
>> but I have problems. Any ideas would be appreciated.
>> First I had this exception:
>>
>> Caused by: org.apache.openjpa.persistence.PersistenceException:
>> ORA-00904: : invalid identifier
>> {stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
>> is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
>> icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
>> isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location
>> VARCHAR2(255), password VARCHAR2(255), is_password_protected NUMBER,
>> reminder VARCHAR2(20), is_reminder_email_send NUMBER, start TIMESTAMP,
>> appointmentname VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id
>> NUMBER, PRIMARY KEY (id))} [code=904, state=42000]
>> ...
>>
>> I tried to run the create command on sql developer (directly on oracle)
>> and I had the same error. It turns out that the error was caused by the *start
>> TIMESTAMP* column. The word "start" is reserved by oracle and needs
>> special treatment. So I ran the command through sql developer using *"START"
>> TIMESTAMP* (with the ") and the table was created. I ran again the admin
>> command line and it seemed to have created the DB.
>>
>> Unfortunately, it crashes later on with the stacktrace shown at the end
>> of the mail. It seems to have something to do with the Naviglobal entity.
>> Any ideas?
>>
>> 2016-05-26 10:56:04,134 [main] ERROR org.apache.openmeetings.cli.Admin -
>> Install failed
>> org.springframework.orm.jpa.JpaSystemException: 10; nested exception is
>> <openjpa-2.4.1-r422266:1730418 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: 10
>> at
>> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
>> at
>> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
>> at
>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
>> at
>> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
>> at
>> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
>> at
>> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
>> at
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>> at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>> at
>> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
>> at
>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$b65241b9.addGlobalStructure(<generated>)
>> at
>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
>> at
>> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
>> at
>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
>> at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
>> at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
>> Caused by: org.apache.openjpa.persistence.PersistenceException: 10
>> at
>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
>> at
>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
>> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
>> at
>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
>> at
>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
>> at
>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
>> ... 13 common frames omitted
>> Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
>> at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
>> at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
>> at
>> oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
>> at
>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
>> at
>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
>> at
>> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
>> at
>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>> at
>> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
>> at
>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
>> at
>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113)
>> at
>> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
>> at
>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
>> at
>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
>> at
>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
>> at
>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
>> at
>> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
>> at
>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
>> at
>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
>> at
>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
>> at
>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>> at
>> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
>> at
>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
>> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
>> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
>> at
>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
>> ... 18 common frames omitted
>>
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Problems installing openmeetings on Oracle DB
Posted by Maxim Solodovnik <so...@gmail.com>.
I can fix "CREATE TABLE appointment" by renaming column in DB
I need couple of minutes to check the code to understand what is wrong with
naviglobal
On Thu, May 26, 2016 at 3:04 PM, Ioannis Vlachos <io...@gmail.com>
wrote:
> Hi.
> I'm trying to install openmeetings on Oracle (through command line admin,
> but I have problems. Any ideas would be appreciated.
> First I had this exception:
>
> Caused by: org.apache.openjpa.persistence.PersistenceException: ORA-00904:
> : invalid identifier
> {stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
> is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
> icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
> isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location
> VARCHAR2(255), password VARCHAR2(255), is_password_protected NUMBER,
> reminder VARCHAR2(20), is_reminder_email_send NUMBER, start TIMESTAMP,
> appointmentname VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id
> NUMBER, PRIMARY KEY (id))} [code=904, state=42000]
> ...
>
> I tried to run the create command on sql developer (directly on oracle)
> and I had the same error. It turns out that the error was caused by the *start
> TIMESTAMP* column. The word "start" is reserved by oracle and needs
> special treatment. So I ran the command through sql developer using *"START"
> TIMESTAMP* (with the ") and the table was created. I ran again the admin
> command line and it seemed to have created the DB.
>
> Unfortunately, it crashes later on with the stacktrace shown at the end of
> the mail. It seems to have something to do with the Naviglobal entity. Any
> ideas?
>
> 2016-05-26 10:56:04,134 [main] ERROR org.apache.openmeetings.cli.Admin -
> Install failed
> org.springframework.orm.jpa.JpaSystemException: 10; nested exception is
> <openjpa-2.4.1-r422266:1730418 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: 10
> at
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
> at
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
> at
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> at
> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$b65241b9.addGlobalStructure(<generated>)
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
> at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
> at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
> Caused by: org.apache.openjpa.persistence.PersistenceException: 10
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
> at
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
> at
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
> ... 13 common frames omitted
> Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
> at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
> at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
> at
> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
> at
> oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
> at
> oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
> at
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
> at
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
> at
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
> at
> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
> at
> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113)
> at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
> at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> at
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
> ... 18 common frames omitted
>
>
--
WBR
Maxim aka solomax