Tomcat and Progress JDBC woes

[chrisw669]

I am unable to make calls to progress jdbc on more than one web application on the same tomcat/windows server. Both applications run java code without problems, and the first application to call the progress jdbc will work but the other application will then be unable to use the progress jdbc.

For example, i have app1 and app2. I boot the windows server and let tomcat start. I access app1 via a webbrowser and call a method that uses the progress jdbc. Works great. All subsequent calls to jdbc from app1 will work also. Now i access app2 and call a method using the progress jdbc. I get:

java.sql.SQLException: No suitable driver found for jdbc:jdbcprogress:T:stimpy:7100:nxt

Now, if i reboot the windows server and access app2 first, jdbc will work for it but not for app1...



server.xml snippet

        <Host name="www.website1.com"  
                  appBase="C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/website1"
            unpackWARs="true" 
               autoDeploy="true"
            xmlValidation="false" 
            xmlNamespaceAware="false">
                </Host>                
                
        <Host name="www.website2.com"  
                  appBase="C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/website2"
            unpackWARs="true" 
               autoDeploy="true"
            xmlValidation="false" 
            xmlNamespaceAware="false">
                </Host>

My system config:

• tomcat 6.0
• windows 2003 server
• progress 9.1E client

classpath:

.;
C:\Program Files\Progress\java\jdbc.jar;
C:\Program Files\Progress\java\progress.jar;
C:\Program Files\Progress\bin\JdbcProgress.dll;
C:\Program Files\Progress\bin\progcli92.dll;
%AXISCLASSPATH%

I hope i'm explaining things well, I just don't get what is going on...