cancel
Showing results for 
Search instead for 
Did you mean: 

Custom DB Setup

tcordova
Champ in-the-making
Champ in-the-making
Ok…  I;ve read the wiki for database configuration and for Repository Configuration http://wiki.alfresco.com/wiki/Repository_Configuration .  It looks like I'm supposed to create some files in:

<JBOSS-HOME>/server/default/conf/alfresco/extension

The files it says to create are:

~ custom-db-and-data-context.xml
~ custom-db-connection.properties
~ custom-hibernate-dialect.properties
~ custom-data-location.properties

It also says I should be able to find samples of these in the <JBOSS_HOME>/server/default/conf/ directory.  I looked there and in <JBOSS_HOME>/server/default/conf/alfresco/extension and couldn't find the samples anywhere.

I've created 2 of the files:

<JBOSS-HOME>/server/default/conf/alfresco/extension/custom-db-connection.properties

db.driver=com.sybase.jdbc2.jdbc.SybDataSource
db.name=alfresco
db.url=jdbc:sybase:Tds:devdb1:4100/alfresco?JCONNECT_VERSION=6
db.username=alfresco
db.password=alfresco

<JBOSS-HOME>/server/default/conf/alfresco/extension/custom-hibernate-dialect.properties

hibernate.dialect=org.hibernate.dialect.SybaseDialect

I don't know what to do for the others, and the server is generating an error on startup because it's still looking for mysql.

HELP!!!
21 REPLIES 21

tcordova
Champ in-the-making
Champ in-the-making
Unfortunately, this is an existing portal.  This portal is running on MyFaces 1.1.3

I modified the FacesServlet to not be Final and changed the myfaces api jar file on the server.

tcordova
Champ in-the-making
Champ in-the-making
It turns out that you may not have to have the same JSF libraries in the JBoss server library as your applications.

In other words, I'm currently running JBoss Portal with the Alfresco myfaces jar files, and my custom applications with MyFaces 1.1.3 jar files, they seem to be cohabitating just fine for now.

Thanks for everyone's help.