topic Re: Alfresco 4.2.0.3 on Jboss 6.1.0 in Alfresco Archive

Alfresco 4.2.0.3 on Jboss 6.1.0

rajeshdk — Fri, 07 Mar 2014 16:29:37 GMT

Hi,I am trying to install Alfresco 4.2.0.3 on Jboss 6.1.0, Oracle 11g 2.0.3 and Java 7. I am getting the below error while starting up Jboss.JBAS014775: New missing/unsatisfied dependencies: service jboss.naming.context.java.jboss.java:alfresco-datasource (missing) dependents: [service jboss

Re: Alfresco 4.2.0.3 on Jboss 6.1.0

mrogers — Fri, 07 Mar 2014 16:34:36 GMT

Sounds like you need to define alfresco-datasource on JBOSS.

http://wiki.alfresco.com/wiki/Deploying_Alfresco_on_JBoss

Re: Alfresco 4.2.0.3 on Jboss 6.1.0

rajeshdk — Fri, 07 Mar 2014 19:23:54 GMT

Thanks for the reply. We do have an existing Alfresco 4.1.2 install running fine without this configuration on JBoss 5.1.
Also one additional information is we have multiple schemas in one database on a single instance. so the existing 4.1.2 is already connected to schema 1. the new upgrade using Alfresco 4.2.0.3 is trying to connect to another schema in the same database using a different account.
does this multiple schemas require any special configuration?

Thanks

Re: Alfresco 4.2.0.3 on Jboss 6.1.0

mrogers — Fri, 07 Mar 2014 22:01:23 GMT

no special configuration.

Re: Alfresco 4.2.0.3 on Jboss 6.1.0

rajeshdk — Wed, 12 Mar 2014 18:17:46 GMT

Thanks. I do see workflow deployment failed and mysql jdbc errors in the log after deploying alfresco 4.2.0.3 war. Because of this error the server did not start up.

The database I use is oracle 11g and I did not configure mysql in alfresco global properties or standalone.xml jboss configuration. So wondering why still get the mysql error. Also I do see all tables created in oracle without any problem.

here is the log excerpts. Full log is attached.

–
(ServerService Thread Pool – 437) JBWEB000287: Exception sending context initialized event to listener
instance of class org.alfresco.web.app.ContextLoaderListener: org.alfresco.error.AlfrescoRuntimeException:
02120119 Workflow deployment failed
–
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error opening session. Cause: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver
class 'org.gjt.mm.mysql.Driver'
–

Thanks

Re: Alfresco 4.2.0.3 on Jboss 6.1.0

pinwheel_alfres — Thu, 26 Jun 2014 07:29:42 GMT

Hay I am also getting same problem.
I am doing integration with Alfresco 4.2.f and JBoss 6.2.0. I am facing "java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver". PFA my standalone.xml (<%JBoss_Home%>\standalone\configuration), module.xml (<%JBoss_Home%>\modules\com\mysql\main), mysql-connector-java-5.1.17-bin.jar (<%JBoss_Home%>\modules\com\mysql\main) and server.log. OS is Window XP. Let me know if I have missed any configuration. I have copied mysql-connector-java-5.1.17-bin.jar file into "<%JBoss_Home%>\standalone\lib" location. Also "<%JBoss_Home%>\modules\system\layers\base\org\gjt\mm\mysql\main" created and use module.xml and mysql-connector-java-5.1.17-bin.jar file here but issue still persisting.
Also alfresco tables created in mysql without any problem.

Regards,
Sudarshan