Alfresco 4.2.0.3 on Jboss 6.1.0

[rajeshdk]

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.naming.context.java.module.alfresco.alfresco.env.jdbc.dataSource]


any thoughts?

Thanks in advance.

Rajesh

[mrogers]

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

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

[rajeshdk]

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

[mrogers]

no special configuration.

[rajeshdk]

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

[pinwheel_alfres]

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