We run a JSP (Tomcat) development and production environment where I work and we are having problems when we "flip the switch" to go to production. I am wondering if this is a JSP specific issue or if it a server behavior issue with all the development models.

I have a set of pages that returns a record set setup in the development area. All is tested QA'd approved and tested. I switch my database to point to the production database (it is on a separate server but is an exact copy of what we had in development for testing.) by editing the database connection (I only change one thing and that is the ip address of the production database) than when I go back into the page that returns the record set the link to the table is gone and I have to rewrite (okay, refill out the parameters in a window) for my record set pages.

I called Macromedia and they said the would not support me since they do not support Tomcat and the datadirect drive I am using even though the tech ran a test using JRUN and the JDBC/ODBC bridge and had the same problem. <img src=../images/dmxzone/forum/icon_smile_dead.gif border=0 align=middle>

Any insight would be grateful

Thanks,


JustTrey