Problem with ORACLE DB

[gsv]

Hello! Sorry fo mu English..
I am installing alfresco 1.4.0 with Jboss 4.0.4..
1) install JDK 1.5.0_09
2) install install Jboss
3) copy WAR file in /opt/jboss/server/default/deploy
4) copy extension files in /opt/jboss/server/default/conf/alfresco
5) edit files custom-connection-pool-context.xml and custom-hibernate-dialect.properties
6) run JBoss and have ERRORS!
Please HELP// where my problem???

________________ERROR ___________
21:16:47,570 INFO  [STDOUT] 21:16:47,551 ERROR [ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanDefinitionStoreException: Line 21 in XML document from file [/opt/jboss/server/default/conf/alfresco/extension/custom-c
onnection-pool-context.xml] is invalid; nested exception is org.xml.sax.SAXParseException: The content of element type "property" must match "(description?,(
bean|ref|idref|value|null|list|set|map|props)?)".
org.xml.sax.SAXParseException: The content of element type "property" must match "(description?,(bean|ref|idref|value|null|list|set|map|props)?)".
        at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
        at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)
        at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
        at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
        at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source)
        ………………………………
__________________________________
—————– custom-connection-pool-context.xml—————————-
  <!– Datasource bean –>
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <!– connection settings –>
        <property name="oracle.jdbc.OracleDriver">
            <value>${db.driver}</value>
        </property>
u       <property name="jdbcracle:thin:@mtr.stcompany.ru:1521:alfreco">
            <value>${db.url}</value>
        </property>
        <property name="ALFRESCO">
            <value>${db.username}</value>
        </property>
        <property name="alfresco">
            <value>${db.password}</value>
        </property>
        <property name="defaultAutoCommit" >
            <value>false</value>
        </property>
        <!– pool settings –>
        <property name="initialSize" >
            <value>${db.pool.initial}</value>
        </property>
        <property name="maxActive" >
            <value>${db.pool.max}</value>
        </property>
        <property name="timeBetweenEvictionRunsMillis" >
            <value>300000</value>
        </property>
        <property name="minEvictableIdleTimeMillis" >
            <value>-1</value>
        </property>
        <property name="testOnBorrow" >
            <value>false</value>
        </property>
        <property name="maxWait" >
            <value>50000</value>
        </property>
        <property name="testWhileIdle" >
            <value>true</value>
        </property>
        <property name="validationQuery" >
            <value>select 1</value>
        </property>
    </bean>

</beans>
____________________________________________
=============ustom-hibernate-dialect.properties
=================
#
# Oracle dialect
#
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
___________________________________
HELP!!!

[rivetlogic]

Hi,

What you should be doing is use the following files instead:

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

In custom-db-and-data-context.xml make sure you only override the database connection and hibernate dialect properties like so:

…
   <!– Override database connection properties –>
   <value>classpath:alfresco/extension/custom-db-connection.properties</value>
…
   <!– Override hibernate dialect –>
   <value>classpath:alfresco/extension/custom-hibernate-dialect.properties</value>
…
‍‍‍‍‍‍‍‍

Then edit custom-db-connection.properties and custom-hibernate-dialect.properties to fit your DB.

Hope this helps.

–Aladdin