>Database components not bringing through the values in the new environment
We have the livesite runtime environment comprising of : LS2.2.1 OD6.2.1 JDK1.4 and we are able to connect to SQL 2000 using SQL driver in our existing environment. We tested the existing runtime machine to connect to SQL2005 using jDTS driver and it worked. Using the same driver we are able to connect to SQL2000 as well.
We are in the midst of migrating to a new datacenter. In our new datacenter the dcr components and external components(except database related ones) are appearing fine in the pages.
But the components related to database doesn’t bring through the values. We have the same customer.jar file moved here. We have ensured the connection strings given in franklin_pool_factory_config.xml are correct.
To get an idea about this problem we wrote a separate test java and was called in a new test component (the connection string was hardcoded) to trace the database connections and we were able to fetch the values from the db. Whenever we hit the page containing the test component, the values from db were printed in the logs. So we are clear now that there is no problem in connectivity to the db.
How to find if franklin_pool_factory_config.xml is being read or not, checked the registry it has entries of this file . Could be helpful if we are given advice on the possible causes of this problem.
The logs don’t state any errors even if we give a wrong connection string in franklin_pool_factory_config.xml.
No upgrade advices please as I am requesting help in an older version....! It's not in my hands I am just a worker bee and need to get this fixed
