Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA

lukx — Wed, 12 Nov 2008 09:51:26 GMT

Fisrt of all, thank to anybody that will try to help me on this issue..Secondly: is there anybody that have installed with success Alfresco Labs 3b on JBOSS4.2.3GA (with JavaSE Runtime Environment (build 1.6.0_07-b06)?I've followed the wiki and forums HowTo about deploying Alfresco on Jboss (on Linu

Re: Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA

tkrieger — Tue, 18 Nov 2008 11:51:04 GMT

Hi,

I had the same problem in my first trys to install Alfresco into JBoss. But have a look at: http://wiki.alfresco.com/wiki/Install_On_Jboss_4.2.0
changing the Hibernate from javassist to cglib solved my problem!

Regards

Krieger

Re: Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA

lukx — Wed, 19 Nov 2008 14:22:59 GMT

Thanks, i'had already changed the line you suggested me:
#hibernate.bytecode.provider=javassist
hibernate.bytecode.provider=cglib
But notthing changed and the deploy always fails….
Now i'm trying the enterprise edition 3 and i have the following error:
(i have mysld 5.0.67)
14:59:28,753 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.DerbyDialect-30659.sql (Generated).
14:59:28,762 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL:     create table JBPM_BYTEBLOCK (
        PROCESSFILE_ bigint not null,
        BYTES_ varchar(1024) for bit data,
        INDEX_ integer not null,
        primary key (PROCESSFILE_, INDEX_)
    )
   Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for bit data,
        INDEX_ integer not null,
        primary key (PROCESSFILE_' at line 3
   File: /tmp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.DerbyDialect-30659.sql
   Line: 37
14:59:28,765 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for bit data,
        INDEX_ integer not null,
        primary key (PROCESSFILE_' at line 3
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:944)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:913)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:629)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1123)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4361)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)

Re: Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA

damonsmith — Tue, 24 Nov 2009 14:51:34 GMT

I got the error you listed when I changed:
Alfresco/tomcat/shared/classes/alfresco/extension/custom-repository.properties

to use mysql, but forgot to change:
Alfresco/tomcat/shared/classes/alfresco/extension/custom-hibernate-dialect.properties

also to use mysql hibernate dialect. Is it possible you've done the same?

topic Re: Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA in Alfresco Archive

Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA

Re: Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA

Re: Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA

Re: Unable to install Linux+alfresco-labs-war3b+Jboss4.2.3GA