[
https://issues.apache.org/jira/browse/OPENMEETINGS-1410?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15303765#comment-15303765
]
Ioannis Vlachos commented on OPENMEETINGS-1410:
-----------------------------------------------
ok, SUCCESS, problem solved.
Downloaded latest build (with the renamed columns), dropped the database, rerun
command line admin and everything worked ok.
The persistence error didn't show up, it had probably something to do with the
name of the column.
By the way, I'm using ojdbc7.jar for Oracle driver.
Thanks a lot, great work
> Om failed to install using Oracle
> ---------------------------------
>
> Key: OPENMEETINGS-1410
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-1410
> Project: Openmeetings
> Issue Type: Bug
> Components: BuildsAndReleases
> Affects Versions: 3.1.1
> Reporter: Maxim Solodovnik
> Assignee: Maxim Solodovnik
> Fix For: 3.1.2, 3.2.0, 4.0.0
>
>
> According to user list:
> 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?
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
