If you have multiple Alfresco instances installed on an Oracle server, you will need to force the database metadata queries to target the schema that each database user is using. Put the following in custom-hibernate-dialect.properties:
Copy the Oracle JDBC driver JAR into \tomcat\common\lib (Tomcat) or \tomcat\lib (on Tomcat 6) or \jboss\server\default\lib (JBoss).
You can now startup the Tomcat or Jboss server
Note: if you get JDBC errors ensure the location for the Oracle JDBC drivers are on the system path, or add them to the relevant lib directory of the app server - the Oracle JDBC drivers can be found in the <orainst>/ora<ver>/jdbc/lib directory (e.g. c:\oracle\ora92\jdbc\lib)
Note: for performance reasons it is recommended that you use the 10g JDBC drivers, even if your Oracle server is 9i.
To use PostgreSQL please follow the steps below.
Copy the appropriate PostgreSQL driver JAR to /tomcat/common/lib (TomCat) or /jboss/server/default/lib (JBoss).
Create a new 'alfresco' user and database. Set this user's password to 'alfresco'.
Ensure that the alfresco user has the required privileges to create and modify tables.
Verify/modify the Alfresco data location in the custom-repository.properties file.
Override following repository properties in custom-repository.properties:
Start the application server to verify your configuration changes.
Note: Hypersonic Database is not supported for Enterprise use
There is no official support for DB2.
Default access to DB2 from Alfresco will use the cursor stability isolation level. This will produce concurrency issues arising from read locks. The following registry variables need to be set to work round this. They do not resolve all issues. See [http://publib.boulder.ibm.com/infocen.../r0005665.html]
db2set DB2_EVALUNCOMMITTED=ON (avaiable from DB2 v8.1.4)
db2Set DB2_SKIPDELETED=ON (avaiable from DB2 v8.1.4)
db2set DB2_SKIPINSERTED=ON (avaiable from DB2 v8.2.2)
Create a DB2 database with a larger page size of 32 K and using UTF8. If you do not do this you will see error SQL0286N (sqlCode -286, sqlstate 42727) as the schema is created for tables that do not fit the page size.
Set up the alfresco user and associated schema. Note DB2 only integrates with the OS security. You can not add a DB user with a password as you can say in oracle.
Alfresco supports Microsoft SQL Server and Sybase but requires custom dialects to be used. The configuration is the same. Make sure the database connector is on the classpath, set the hibernate dialect in the config, set the properties for the database connection in the config, make sure the appropriate user is defined on the database and that they can login, that the holder db/tablespace/... where this user can create tables exists, and that they have rights to create tables etc.
Examples for setting the hibernate dialect are provided here