topic Re: How to deploy Explorer WAR in Glassfish 3 with Container Datasources in Alfresco Archive

How to deploy Explorer WAR in Glassfish 3 with Container Datasources

jim_doyle — Thu, 26 Dec 2013 14:18:35 GMT

If you need to deploy Explorer in an EE6 container using formal datasources here's how. It's very easy but will require some minor surgery on the WAR. I'll use Glassfish 3 as an example for you. If you're using Websphere or Weblogic - the steps are very similar BUT you will need to declare a vendor-

Re: How to deploy Explorer WAR in Glassfish 3 with Container Datasources

jim_doyle — Thu, 26 Dec 2013 14:35:03 GMT

Oops - In Step 4 - you are REMOVING this def of 'dataSource' and REPLACING it with a Spring JNDI lookup. So, this is what goes away:


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${jdbc.driver}" />
    <property name="url" value="${jdbc.url}" />
    <property name="username" value="${jdbc.username}" />
    <property name="password" value="${jdbc.password}" />
    <property name="defaultAutoCommit" value="false" />
  </bean>

As a matter of further discussion, you could make the Activiti deploys more portable across the container landscape by using exclusively JNDI lookups of the mail and datasource resources. To keep it Tomcat friendly - you have the option of defining the resources either in
META-INF/context.xml within the WAR, or in $TOMCAT_HOME/conf/server.xml for Global Resources. See below for an example of using Context.xml tricks.


<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" antiResourceLocking="true" path="/activiti-explorer" reloadable="true">
  <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" maxActive="2" maxIdle="3" maxWait="10000" name="jdbc/activiti-demo" password="activitipw" type="javax.sql.DataSource" url="jdbc:smileysurprised:racle:thin:@192.168.11.2:1521/XE" username="activiti"/>
  <Resource auth="Container" mail.smtp.auth="true"
            mail.smtp.host="Your SMTP Provider, i.e. smtp.gmail.com"
            mail.smtp.port="465"
            mail.smtp.socketFactory.class="javax.net.ssl.SSLSocketFactory"
            mail.smtp.starttls.enable="true"
            mail.smtp.user="…. foobar at gmail.com ….. "
            name="mail/Session"
            password="….private password goes here…."
            type="javax.mail.Session"/>
</Context>

Re: How to deploy Explorer WAR in Glassfish 3 with Container Datasources

stepanovsu — Sun, 29 Dec 2013 19:49:01 GMT

jim_doyle:
thanks. it was very helpfull.
But i was try to do that for weblogic 10.3.5. and had exception:
<pre>
rg.springframework.beans.NotWritablePropertyException:Invalid property 'lazyInit' of bean class [org.springframework.jndi.JndiObjectFactoryBean]: Bean property 'lazyInit' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?
</pre>
Could you advice me anything?
Thanks