Sun Application Server 9.0 and Alfresco

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

novamxd

Hello Everyone,

I apologize now for any spelling mistakes as at the moment I don't see very clearly as I've been smashing my head into my keyboard from frustration.

But to the point, I have currently installed on a Windows XP SP2 system:

- JDK 6u1 with the runtime environment
- Sun's Application Server v9.0
- MySQL 5.0

And I've been trying for the past two days to deploy the Alfresco 2.0.0 community war file as a web application to this wonderful application server. However as you can imagine (why I'm here) it's not working.

I uploaded the three errors I got to my web server into an appropriately named folder (I think anyway). They are:

- err1.htm
- err2.htm
- err3.htm

If anyone could help me with these errors, I would be most appreciative. And between downloading to deploying the war file, I made no modifications. And yes, I tried Tomcat and JBoss, both I couldn't figure out either so I figured I'd try the more… user friendly? application server. For those who haven't played with it, it comes with an incredibly useful admin website something like Tomcat's except better.

And as I'm sure most can tell, I'm not very versed in Java application servers, servlets, etc, etc. I'm a PHP programmer, web designer, and have been sucked into the world of .NET.

dbaran

Hello,

About your errors:

…
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
   … 67 more
Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1511)
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1292)
   at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Class.java:169)
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You probably forgot to add JDBC driver jar file for MySQL in your classpath. See Database configuration

About GlassFish (SAS 9.0), some other guys have already tried to work Alfresco with it, but it seems Alfresco is not yet fully JaveEE 5.0, and used an older release of JFaces… So, they are some modification to do in sources to use GlassFish.

See other threads on this forum:
http://forums.alfresco.com/viewtopic.php?t=5609&highlight=glassfish
http://forums.alfresco.com/viewtopic.php?t=1433&highlight=glassfish
http://forums.alfresco.com/viewtopic.php?t=559&highlight=glassfish

We are also very impatient to see Alfresco works with GlassFish

PS: Beware about your JDK, I have read some threads about compatibility problems. It's better to use 1.5 until problems are resolved.