2008-09-01

Installing Alfresco on WebLogic 10.3 and Oracle XE

Everybody knows Documentum from EMC² but there is also a free tool, Alfresco, created by the father of Documentum,

which is also an excellent solution for keeping a community live and documented :)

 

As every other interesting tool, I tried to install it on my top application server and my top database !

This time, it wasn't too hard, even if it wasn't over-documented ...

Download Alfresco

Well it sounds obvious but you first have to download it.

Don't take the Tomcat version, but the WAR version. (it comes in a zip ~52Mb)

Make some changes to have it compatible with WebLogic classloader

As usual, this war comes with a variety of libs, and some of them may conflict with those embedded in WebLogic.

Then I recommend in this case to use the Filtering Class Loader mechanism.

To have it configured, you first have to turn you WAR in an EAR like :


image

Note : When I'm debugging some stuff while installing it, I prefer to use the exploded format, which is easier to update config files, adding extra libs and so on.

Configure it to use an Oracle database

I noticed that Alfresco is sensed to use a mySQL database.

To switch to an Oracle DB, you will have to modify some configuration files.

First one : repository.properties (alfresco.war\WEB-INF\classes\alfresco)

Look for the following section and change what's needed.

# Database configuration
db.schema.update=true
db.driver=oracle.jdbc.OracleDriver
db.name=xe
db.url=jdbc:oracle:thin:@localhost:1521:XE
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

Second one : hibernate-cfg.properties (alfresco.war\WEB-INF\classes\alfresco\domain)

It's quite easy : only one line to change to reflect the new Hibernate dialect.

#
# Hibernate configuration
#
# hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.dialect=org.hibernate.dialect.OracleDialect

 

To see whether it's really been taken into account, check the logs :

 

16:41:06,031 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.OracleDialect.

 

If everything went well, your DB schema should have been created. You may take a look using your favorite DB tool :


image

Windows library (optional)

So far, if you're working with Windows, it works, but there is still an error :

 

java.lang.UnsatisfiedLinkError: no Win32NetBIOS in java.library.path

 

As said, you have to add the the lib called "Win32NetBIOS.dll"

(located in the bin directory of your Alfresco distribution) in either the java.library.path or in the Windows DLL directory (Windows/system32).

Enjoy ! :)

image

 

Mots clés Technorati : ,,

7 comments:

Anonymous said...

Hi!

Thanks for this guide, I've succeeded in connecting Alfresco with Oracle.

But I cannot login (/share) and localhost:8080/alfresco throws a http 404 error and the folder is empty.

Do you have any idea what could be wrong? There are no exceptions shown in console when tomcat starts.

Thanks, Claudia

turret said...

Hi All,
I am new to Weblogic 10.3 and hibernate.
My developers want to use hibernate in application. How can i configure weblogic 10.3 for hibernate. And what changes i have to make from application side.

Please help me out.
Thanks in advance.

Sridhar

turret said...

Hi All,

How can i configure weblogic 10.3 for hibernate. Please help me out.
Thanks in advanace.
Turret

Maxence Button said...

Hey Claudia,

Well, unfortunately, I haven't worked with Alfresco on Tomcat so far, then I'm afraid I can't help you.
You should try : http://forums.alfresco.com

But take a closer look at the admin console and see if your app is correctly deployed.

Regards.

Maxence Button said...

Hi Sridhar,

Well, you may use Hibernate or any other framework with WLS 10.3. The only thing you've got to know is that you may encounter some package/class conflicts.
Pbm usually solved by the FilteringClassLoader mechanism.

More information @ :
http://m-button.blogspot.com/2008/08/how-to-use-weblogic-filteringclassloade.html

Hope this helps !

savvas said...

Can you please give us detailed step by step information on how to install alfresco on weblogic 10.3? I tried the above steps but I couldn't manage to install it, and documentation regarding alfresco installation is hard to come by. Thanks in advance.

Adrian Cadena said...

Maxence,

Canyou please post the file weblogic-application.xlm you have already used to deply alfresco??

This will help me a lot let mw know if you can do this , the example of your article just describes a custom weblogic-application.xml but I would like to see a real alfresco deployment file

thanks hope you can help great article!