<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to deploy Explorer WAR in Glassfish 3 with Container Datasources in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/how-to-deploy-explorer-war-in-glassfish-3-with-container/m-p/163757#M117538</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;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-specific deployment descriptor for your container. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;1. In your EE6 Container Admin Console, define a new Connection Pool and a new JNDI Resource for that pool. Make sure you test your connection using the "Ping" features in your console to open the pool and force a database signon.&amp;nbsp; Note that I've installed a Global JNDI resource named 'jdbc/activiti-demo'.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;2. Unpack the Activiti Explorer WAR in a CLEAN, new directory:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; bash$&amp;nbsp; mkdir explorer ; cd explorer ;&amp;nbsp; jar xf ../activity-explorer.war&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;3. Add a deployment descriptor for your container.&amp;nbsp; In my case, I added &lt;/SPAN&gt;&lt;STRONG&gt;WEB-INF/glassfish-web.xml&lt;/STRONG&gt;&lt;SPAN&gt; to the unpacked explorer files.&amp;nbsp; This deployment descriptor adds a &amp;lt;resource-ref&amp;gt; to the global JNDI resource jdbc/activity-demo that we installed in Step 1.&amp;nbsp; This allows the deployed web app to find the JDBC resource in the local JNDI namescape - so spring can find it.&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;!DOCTYPE glassfish-web-app PUBLIC "-//&lt;A href="http://GlassFish.org//DTD" rel="nofollow noopener noreferrer"&gt;GlassFish.org//DTD&lt;/A&gt; GlassFish Application Server 3.1 Servlet 3.0//EN" "&lt;A href="http://glassfish.or/dtds/glassfish-web-app_3_0-1.dtd" rel="nofollow noopener noreferrer"&gt;http://glassfish.or/dtds/glassfish-web-app_3_0-1.dtd&lt;/A&gt;"&amp;gt;&lt;BR /&gt;&amp;lt;glassfish-web-app&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;resource-ref&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;res-ref-name&amp;gt;jdbc/activiti-demo&amp;lt;/res-ref-name&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;jndi-name&amp;gt;jdbc/activiti-demo&amp;lt;/jndi-name&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/resource-ref&amp;gt;&lt;BR /&gt;&amp;lt;/glassfish-web-app&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;4. Edit &lt;/SPAN&gt;&lt;STRONG&gt;WEB-INF/activiti-standalone-context.xml&lt;/STRONG&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; * REMOVE the &amp;lt;bean id="dataSource" ….&amp;gt;&amp;nbsp; definition.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; * REPLACE AND ADD the following: &lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;jee:jndi-lookup id="dataSource" jndi-name="jdbc/activiti-demo" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;bean id="sqlExceptionTranslator" class="org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;property name="dataSource" ref="dataSource"/&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/bean&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;5. Edit &lt;/SPAN&gt;&lt;STRONG&gt;WEB-INF/classes/db.properties&lt;/STRONG&gt;&lt;SPAN&gt; - remove the username and password entries, leaving behind the vendor selector, i.e.:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; db=oracle&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;6. Surgery done.&amp;nbsp; Pack up the modified WAR.&amp;nbsp; Make sure you do the packing while in the directory that holds WEB-INF, META-INF, lib, api, etc:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; bash$&amp;nbsp;&amp;nbsp; jar cf ../activiti-explorer-gf.war .&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;SPAN&gt;7. Deploy activiti-explorer-gf.war in the admin console.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 26 Dec 2013 14:18:35 GMT</pubDate>
    <dc:creator>jim_doyle</dc:creator>
    <dc:date>2013-12-26T14:18:35Z</dc:date>
    <item>
      <title>How to deploy Explorer WAR in Glassfish 3 with Container Datasources</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/how-to-deploy-explorer-war-in-glassfish-3-with-container/m-p/163757#M117538</link>
      <description>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-</description>
      <pubDate>Thu, 26 Dec 2013 14:18:35 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/how-to-deploy-explorer-war-in-glassfish-3-with-container/m-p/163757#M117538</guid>
      <dc:creator>jim_doyle</dc:creator>
      <dc:date>2013-12-26T14:18:35Z</dc:date>
    </item>
    <item>
      <title>Re: How to deploy Explorer WAR in Glassfish 3 with Container Datasources</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/how-to-deploy-explorer-war-in-glassfish-3-with-container/m-p/163758#M117539</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Oops - In Step 4 - you are REMOVING this def of 'dataSource' and REPLACING it with a Spring JNDI lookup.&amp;nbsp; So, this is what goes away:&lt;/SPAN&gt;&lt;BR /&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;property name="driverClassName" value="${jdbc.driver}" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;property name="url" value="${jdbc.url}" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;property name="username" value="${jdbc.username}" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;property name="password" value="${jdbc.password}" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;property name="defaultAutoCommit" value="false" /&amp;gt;&lt;BR /&gt;&amp;nbsp; &amp;lt;/bean&amp;gt;&lt;BR /&gt;&lt;/CODE&gt;&lt;BR /&gt;&lt;SPAN&gt;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.&amp;nbsp;&amp;nbsp; To keep it Tomcat friendly - you have the option of defining the resources either in &lt;/SPAN&gt;&lt;BR /&gt;&lt;STRONG&gt;META-INF/context.xml&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp; within the WAR,&amp;nbsp; or in &lt;/SPAN&gt;&lt;STRONG&gt;$TOMCAT_HOME/conf/server.xml&lt;/STRONG&gt;&lt;SPAN&gt; for Global Resources. See below for an example of using Context.xml tricks.&lt;/SPAN&gt;&lt;BR /&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;?xml version="1.0" encoding="UTF-8"?&amp;gt;&lt;BR /&gt;&amp;lt;Context antiJARLocking="true" antiResourceLocking="true" path="/activiti-explorer" reloadable="true"&amp;gt;&lt;BR /&gt;&amp;nbsp; &amp;lt;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"/&amp;gt;&lt;BR /&gt;&amp;nbsp; &amp;lt;Resource auth="Container" mail.smtp.auth="true"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; mail.smtp.host="Your SMTP Provider, i.e. smtp.gmail.com"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; mail.smtp.port="465"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; mail.smtp.socketFactory.class="javax.net.ssl.SSLSocketFactory"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; mail.smtp.starttls.enable="true"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; mail.smtp.user="…. foobar at gmail.com ….. "&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; name="mail/Session"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; password="….private password goes here…."&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; type="javax.mail.Session"/&amp;gt;&lt;BR /&gt;&amp;lt;/Context&amp;gt;&lt;BR /&gt;&lt;/CODE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Dec 2013 14:35:03 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/how-to-deploy-explorer-war-in-glassfish-3-with-container/m-p/163758#M117539</guid>
      <dc:creator>jim_doyle</dc:creator>
      <dc:date>2013-12-26T14:35:03Z</dc:date>
    </item>
    <item>
      <title>Re: How to deploy Explorer WAR in Glassfish 3 with Container Datasources</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/how-to-deploy-explorer-war-in-glassfish-3-with-container/m-p/163759#M117540</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;jim_doyle: &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;thanks. it was very helpfull.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;But i was try to&amp;nbsp; do that for weblogic 10.3.5. and had exception:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;pre&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&lt;img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;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?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/pre&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Could you advice me anything?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 29 Dec 2013 19:49:01 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/how-to-deploy-explorer-war-in-glassfish-3-with-container/m-p/163759#M117540</guid>
      <dc:creator>stepanovsu</dc:creator>
      <dc:date>2013-12-29T19:49:01Z</dc:date>
    </item>
  </channel>
</rss>

