Connection pool not found

Hi all

We're experiencing problems with Livesite components on one of our webservers, getting a 'connection pool not found' error. franklin_pool_config_factory exists on both servers and contains all the relevant connection info, so I've no idea why one is failing to connect.

Any ideas?

Thanks in advance for your help

Paul

Find more posts tagged with

Comments

nbwoven

Kindly provide your Env. Details .?Livesite,TS Versions +OS ..especially the
Web/App Server details Is this IIS with .Net 2.0 installed ..?

Migrateduser

This is what I got from IWOV on a similar question:


iwhome/local/config/lib/content_center/livesite_customer_src/etc/conf/livesite_customer/resources/customer-resource-config.xml
( this goes INSIDE the <beans> element in that file )


<bean id="customer.db.DefaultPoolFactory"
        parent="db.DefaultPoolFactory"
        init-method="init">
    <property name="pools">
      <map merge="true">       
        <!--

         This is an example of a custom pooled data source, there must be a single entry per pool.
         NOTE: The connection information is standard JDBC.

        <entry key="customer_pool_name">
          <bean class="org.apache.commons.dbcp.BasicDataSource"
                destroy-method="close">
            <property name="driverClassName" value="<classname>"/>
            <property name="url" value="<connectionstring>"/>
            <property name="username" value="<username>"/>
            <property name="password" value="<password>"/>
          </bean>
        </entry>
        -->
      </map>
    </property>
  </bean>

Notice the merge="true" in the <map> node.   This means that any new pools created here will be merged with the existing set.

To retrieve a connection from the pool:

com.interwoven.livesite.runtime.servlet.RequestUtils.getConnection(String poolName);

After you make changes to this file, you must rebuild the livesite_customer toolkit by running build.bat(or .sh) in the toolkit home directory:
iwhome/local/config/lib/content_center/livesite_customer_src