You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openmeetings.apache.org by "Maxim Solodovnik (JIRA)" <ji...@apache.org> on 2014/09/18 18:11:34 UTC
[jira] [Commented] (OPENMEETINGS-1088) error installing with mssql
[ https://issues.apache.org/jira/browse/OPENMEETINGS-1088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14139116#comment-14139116 ]
Maxim Solodovnik commented on OPENMEETINGS-1088:
------------------------------------------------
I have started discussion in OpenJPA mailing-list: http://markmail.org/message/2kpalsconfkk7rbn
Will fix column/table name if will get no other choice
Thanks for the report
> error installing with mssql
> ---------------------------
>
> Key: OPENMEETINGS-1088
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-1088
> Project: Openmeetings
> Issue Type: Bug
> Affects Versions: 3.0.3
> Reporter: Miguel Muñoz
>
> Hello,
> I'm having problems installing openmeeting with mssql. The command line installer report this:
> -----
> 2014-09-18 17:41:45,029 [main] ERROR org.apache.openmeetings.cli.Admin - Install failed
> org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.3.0-r422266:1540826 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Sintaxis incorrecta cerca de la palabra clave 'right'. {stmnt 1617652468 CREATE TABLE om_user_right (user_id BIGINT, right VARCHAR(20))} [code=156, state=S0001]
> at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:430) ~[spring-orm-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:420) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:257) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) ~[spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$21e84591.getConfValue(<generated>) ~[spring-core-4.0.6.RELEASE.jar:na]
> at org.apache.openmeetings.db.util.UserHelper.getMinPasswdLength(UserHelper.java:34) ~[openmeetings-db-3.0.3-RELEASE.jar:na]
> at org.apache.openmeetings.db.util.UserHelper.invalidPassword(UserHelper.java:38) ~[openmeetings-db-3.0.3-RELEASE.jar:na]
> at org.apache.openmeetings.cli.Admin.checkAdminDetails(Admin.java:545) [openmeetings-cli-3.0.3-RELEASE.jar:na]
> at org.apache.openmeetings.cli.Admin.process(Admin.java:276) [openmeetings-cli-3.0.3-RELEASE.jar:na]
> at org.apache.openmeetings.cli.Admin.main(Admin.java:649) [openmeetings-cli-3.0.3-RELEASE.jar:na]
> Caused by: org.apache.openjpa.persistence.PersistenceException: Sintaxis incorrecta cerca de la palabra clave 'right'. {stmnt 1617652468 CREATE TABLE om_user_right (user_id BIGINT, right VARCHAR(20))} [code=156, state=S0001]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:155) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:226) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:153) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:59) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:448) ~[spring-orm-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:369) ~[spring-orm-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]
> ... 12 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Sintaxis incorrecta cerca de la palabra clave 'right'. {stmnt 1617652468 CREATE TABLE om_user_right (user_id BIGINT, right VARCHAR(20))} [code=156, state=S0001]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:914) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:118) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1231) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:976) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:552) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:364) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:341) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505) ~[openjpa-bundle-2.3.0.jar:2.3.0]
> ... 23 common frames omitted
> -----
> I think 'right' is a "reserved word" (http://msdn.microsoft.com/en-us/library/ms189822.aspx) and shoud be used between 'right' or [right].
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)