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 <[email protected]> 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 <[email protected]>: > >> Columns were renamed >> >> On Thu, May 26, 2016 at 3:16 PM, Maxim Solodovnik <[email protected]> >> wrote: >> >>> https://issues.apache.org/jira/browse/OPENMEETINGS-1410 >>> >>> On Thu, May 26, 2016 at 3:10 PM, Maxim Solodovnik <[email protected]> >>> 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 <[email protected] >>>> > 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 < >>>>> [email protected]> 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
