Pour info, la base de données actuelle n'est pas une base de données MySQL mais HSQL. Alors si tu souhaites passer sur une base de données MySQL, tu devras alors modifier quelques fichiers de configurations. Dans ce cas de figure, tu perdras toutes les informations stockés dans la base HSQL et donc ton repository actuel. Si cela t'importe peu, je le suggère de purger le contenu de ton repository (répertoire alf_data) puis de modifier tes fichiers de configuration comme suis. Avant cela, tu devras également télécharger le drivers JDBC MySQL et le placer dans le répertoire $CATALINA_HOME/libs.Pour info je te donnes mes fichiers de configurations.fichier shared/alfresco/extension/custom-services-context.xml<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
<beans>
<!– import further configurations –>
<import resource="file:D:/Development/Root-Server-Integration/etc/alfresco/config/more-config.xml" />
</beans>
fichier D:/Development/Root-Server-Integration/etc/alfresco/config/more-config.xml<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
<beans>
<!– overriding to point to custom properties –>
<bean id="repository-properties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="ignoreUnresolvablePlaceholders">
<value>true</value>
</property>
<property name="locations">
<list>
<value>classpath:alfresco/repository.properties</value>
<value>classpath:alfresco/version.properties</value>
<value>classpath:alfresco/domain/transaction.properties</value>
<value>file:D:/Development/Root-Server-Integration/etc/alfresco/config/live.repository.properties</value> <!– override core properties –>
</list>
</property>
</bean>
<!– override Hibernate properties –>
<bean id="hibernateConfigProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="locations">
<list>
<value>classpath:alfresco/domain/hibernate-cfg.properties</value>
<value>file:D:/Development/Root-Server-Integration/etc/alfresco/config/hibernate.properties</value>
</list>
</property>
</bean>
<!– overriding the mail action to remove it as a public action –>
<bean id="mail" class="org.alfresco.repo.action.executer.MailActionExecuter" parent="action-executer">
<property name="publicAction">
<value>false</value> <!– setting to false –>
</property>
<property name="mailService">
<ref bean="mailService"></ref>
</property>
</bean>
</beans>
fichier D:/Development/Root-Server-Integration/etc/live.repository.properties# Directory configuration
dir.root=D:/Development/Root-Server-Integration/u01/data-repositories/alf_data
dir.contentstore=${dir.root}/contentstore
dir.contentstore.deleted=${dir.root}/contentstore.deleted
dir.auditcontentstore=${dir.root}/audit.contentstore
# The location for lucene index files
dir.indexes=${dir.root}/lucene-indexes
# The location for lucene index locks
dir.indexes.lock=${dir.indexes}/locks
# The index recovery mode (NONE, VALIDATE, AUTO, FULL)
index.recovery.mode=VALIDATE
# Change the failure behaviour of the configuration checker
system.bootstrap.config_check.strict=true
#
# Properties to limit resources spent on individual searches
#
# The maximum time spent pruning results
system.acl.maxPermissionCheckTimeMillis=10000
# The maximum number of results to perform permission checks against
system.acl.maxPermissionChecks=1000
# #################### #
# Lucene configuration #
# #################### #
#
# Millisecond threshold for text transformations
# Slower transformers will force the text extraction to be asynchronous
#
lucene.maxAtomicTransformationTime=20
#
# The maximum number of clauses that are allowed in a lucene query
#
lucene.query.maxClauses=10000
#
# The size of the queue of nodes waiting for index
# Events are generated as nodes are changed, this is the maximum size of the queue used to coalesce event
# When this size is reached the lists of nodes will be indexed
#
lucene.indexer.batchSize=1000
#
# Lucene index min merge docs - the in memory size of the index
#
lucene.indexer.minMergeDocs=1000
#
# When lucene index files are merged together - it will try to keep this number of segments/files in
#
lucene.indexer.mergeFactor=10
#
# Roughly the maximum number of nodes indexed in one file/segment
#
lucene.indexer.maxMergeDocs=100000
#
# The number of terms from a document that will be indexed
#
lucene.indexer.maxFieldLength=10000
lucene.write.lock.timeout=10000
lucene.commit.lock.timeout=100000
lucene.lock.poll.interval=100
# Database configuration
db.schema.update=true
db.driver=org.gjt.mm.mysql.Driver
db.name=alfresco
db.url=jdbc:mysql:///${db.name}
db.username=alfresco
db.password=password
db.pool.initial=10
db.pool.max=20
# Email configuration
mail.host=smtp
mail.port=25
mail.username=anonymous
mail.password=
# Set this value to UTF-8 or similar for encoding of email messages as required
mail.encoding=UTF-8
# Set this value to 7bit or similar for Asian encoding of email headers as required
mail.header=
mail.from.default=alfresco@localhost
# System Configuration
system.store=system://system
system.descriptor.childname=sys:descriptor
system.descriptor.current.childname=sys:descriptor-current
# User config
alfresco_user_store.store=user://alfrescoUserStore
alfresco_user_store.system_container.childname=sys:system
alfresco_user_store.user_container.childname=sys:people
alfresco_user_store.authorities_container.childname=sys:authorities
# Spaces Archive Configuration
spaces.archive.store=archive://SpacesStore
# Spaces Configuration
spaces.store=workspace://SpacesStore
spaces.company_home.childname=app:company_home
spaces.guest_home.childname=app:guest_home
spaces.dictionary.childname=app:dictionary
spaces.templates.childname=app:space_templates
spaces.templates.content.childname=app:content_templates
spaces.templates.email.childname=app:email_templates
spaces.templates.rss.childname=app:rss_templates
spaces.savedsearches.childname=app:saved_searches
spaces.scripts.childname=app:scripts
spaces.wcm.childname=app:wcm
spaces.content_forms.childname=app:wcm_forms
spaces.user_homes.childname=app:user_homes
# Folders for storing people
system.system_container.childname=sys:system
system.people_container.childname=sys:people
# Folders for storing workflow related info
system.workflow_container.childname=sys:workflow
# Are user names case sensitive?
# ==============================
#
# NOTE: If you are using mysql you must have case sensitive collation
#
# You can do this when creating the alfresco database at the start
# CREATE DATABASE alfresco CHARACTER SET utf8 COLLATION utf8_bin;
# If you want to do this later this is a dump and load fix as it is done when the database, tables and columns are created.
#
# Must other databases are case sensitive by default.
#
user.name.caseSensitive=false
# AVM Specific properties.
avm.remote.idlestream.timeout=30000
la ligne suivante, te permettra de définir le lieu de stockage de ton repository, càd l'endroit où seront stockés tes données (documents).dir.root=D:/Development/Root-Server-Integration/u01/data-repositories/alf_data
l'ensemble de lignes suivantes, te permettront de configurer l'accès à ta base de donnée MySQL# Database configuration
db.schema.update=true
db.driver=org.gjt.mm.mysql.Driver
db.name=alfresco
db.url=jdbc:mysql:///${db.name}
db.username=alfresco
db.password=password
db.pool.initial=10
db.pool.max=20
fichier D:/Development/Root-Server-Integration/etc/hibernate.properties#hibernate.dialect=org.hibernate.dialect.MySQLDialect
#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
#
# Hibernate configuration
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.jdbc.use_streams_for_binary=true
hibernate.show_sql=false
hibernate.cache.use_query_cache=true
hibernate.max_fetch_depth=10
hibernate.cache.provider_class=org.alfresco.repo.cache.InternalEhCacheManagerFactoryBean
hibernate.cache.use_second_level_cache=true
hibernate.default_batch_fetch_size=1
hibernate.jdbc.batch_size=32
hibernate.connection.release_mode=auto
hibernate.connection.isolation=2
Ces fichiers de configurations sont ceux de ma plateforme. Si tu souhaites plus d'informations à leur sujet, je t'invite à lire ceci : http://wiki.alfresco.com/wiki/Repository_Configuration ainsi que ce post http://forum.alfresco-fr.org/viewtopic.php?f=11&t=665Pour ce qui est de l'accès à la base de données, tout dépend de ce que tu souhaites faire. Pour un simple accès avec connection + lecture des informations dans la base de données MySQL, il y a quelques bouts de code java qui trainent sur ce forum dont cet exemple sur lequel j'ai commencé http://forum.alfresco-fr.org/viewtopic.php?f=11&t=646
