topic Problem with ORACLE DB in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-oracle-db/m-p/77187#M51016 <HTML><HEAD></HEAD><BODY><SPAN>Hello! Sorry fo mu English..</SPAN><BR /><SPAN>I am installing alfresco 1.4.0 with Jboss 4.0.4..</SPAN><BR /><SPAN>1) install JDK 1.5.0_09</SPAN><BR /><SPAN>2) install install Jboss</SPAN><BR /><SPAN>3) copy WAR file in /opt/jboss/server/default/deploy</SPAN><BR /><SPAN>4) copy extension files in /opt/jboss/server/default/conf/alfresco</SPAN><BR /><SPAN>5) edit files custom-connection-pool-context.xml and custom-hibernate-dialect.properties</SPAN><BR /><SPAN>6) run JBoss and have ERRORS!</SPAN><BR /><SPAN>Please HELP// where my problem???</SPAN><BR /><BR /><SPAN>________________ERROR ___________</SPAN><BR /><SPAN>21:16:47,570 INFO&nbsp; [STDOUT] 21:16:47,551 ERROR [ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanDefinitionStoreException: Line 21 in XML document from file [/opt/jboss/server/default/conf/alfresco/extension/custom-c</SPAN><BR /><SPAN>onnection-pool-context.xml] is invalid; nested exception is org.xml.sax.SAXParseException: The content of element type "property" must match "(description?,(</SPAN><BR /><SPAN>bean|ref|idref|value|null|list|set|map|props)?)".</SPAN><BR /><SPAN>org.xml.sax.SAXParseException: The content of element type "property" must match "(description?,(bean|ref|idref|value|null|list|set|map|props)?)".</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ………………………………</SPAN><BR /><SPAN>__________________________________</SPAN><BR /><SPAN>—————– custom-connection-pool-context.xml—————————-</SPAN><BR /><SPAN>&nbsp; &lt;!– Datasource bean –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– connection settings –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="oracle.jdbc.OracleDriver"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.driver}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>u&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@mtr.stcompany.ru:1521:alfreco"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.url}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="ALFRESCO"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.username}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="alfresco"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.password}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="defaultAutoCommit" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;false&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– pool settings –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="initialSize" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.pool.initial}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="maxActive" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.pool.max}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="timeBetweenEvictionRunsMillis" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;300000&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="minEvictableIdleTimeMillis" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;-1&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="testOnBorrow" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;false&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="maxWait" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;50000&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="testWhileIdle" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;true&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="validationQuery" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;select 1&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&lt;/beans&gt;</SPAN><BR /><SPAN>____________________________________________</SPAN><BR /><SPAN>=============ustom-hibernate-dialect.properties</SPAN><BR /><SPAN>=================</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Oracle dialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.Oracle9Dialect</SPAN><BR /><SPAN>___________________________________</SPAN><BR /><SPAN>HELP!!!</SPAN></BODY></HTML> Mon, 20 Nov 2006 15:13:52 GMT gsv 2006-11-20T15:13:52Z Problem with ORACLE DB https://connect.hyland.com/t5/alfresco-archive/problem-with-oracle-db/m-p/77187#M51016 Hello! Sorry fo mu English..I am installing alfresco 1.4.0 with Jboss 4.0.4..1) install JDK 1.5.0_092) install install Jboss3) copy WAR file in /opt/jboss/server/default/deploy4) copy extension files in /opt/jboss/server/default/conf/alfresco5) edit files custom-connection-pool-context.xml and custo Mon, 20 Nov 2006 15:13:52 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-oracle-db/m-p/77187#M51016 gsv 2006-11-20T15:13:52Z Re: Problem with ORACLE DB https://connect.hyland.com/t5/alfresco-archive/problem-with-oracle-db/m-p/77188#M51017 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>What you should be doing is use the following files instead:</SPAN><BR /><BR /><STRONG>custom-db-and-data-context.xml</STRONG><BR /><STRONG>custom-db-connection.properties</STRONG><BR /><STRONG>custom-hibernate-dialect.properties</STRONG><BR /><BR /><SPAN>In </SPAN><STRONG>custom-db-and-data-context.xml</STRONG><SPAN> make sure you only override the database connection and hibernate dialect properties like so:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>…<BR />&nbsp;&nbsp; &lt;!– Override database connection properties –&gt;<BR />&nbsp;&nbsp; &lt;value&gt;classpath:alfresco/extension/custom-db-connection.properties&lt;/value&gt;<BR />…<BR />&nbsp;&nbsp; &lt;!– Override hibernate dialect –&gt;<BR />&nbsp;&nbsp; &lt;value&gt;classpath:alfresco/extension/custom-hibernate-dialect.properties&lt;/value&gt;<BR />…<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Then edit </SPAN><STRONG>custom-db-connection.properties</STRONG><SPAN> and </SPAN><STRONG>custom-hibernate-dialect.properties</STRONG><SPAN> to fit your DB.</SPAN><BR /><BR /><SPAN>Hope this helps.</SPAN><BR /><BR /><SPAN>–Aladdin</SPAN></BODY></HTML> Wed, 22 Nov 2006 05:39:18 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-oracle-db/m-p/77188#M51017 rivetlogic 2006-11-22T05:39:18Z