RTC Login Fails when Tomcat runs as Windows service
I installed RTC Express-C a few weeks ago and was able to get it running with Tomcat installed as a Windows service. I've since uninstalled Express-C and its version of Tomcat and installed RTC Standard as the 60-day trial.
When I start Tomcat from the command line, I'm able to bring up RTC and log in as normal. When I install Tomcat as a Windows service (using the config info in TN0010), the log in page displays (after the SSL warning), but when I enter my ID and password, the page displays "Loading..." forever. The stdout_20081119.log file indicates that the SQL Server JDBC driver is not loading. Two of us have gone over the config data multiple times and we're not seeing where the problem is. The sqljdbc.jar is located in the directory specified in the install instructions and we've also set SQLSERVER_ABSPATH, just to be sure. The gist of the error log is as follows: 14:37:29,150 ERROR t.internal.registry.AbstractActivationManagerOwner - CRJAZ1093I Service failed to activate. ... Caused by: java.lang.IllegalStateException: CRJAZ0808I The driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" could not be loaded and registered. Support for some database vendors requires that the JDBC driver JAR be provided in a path configured by the server scripts. If you are experiencing problems changing the database vendor, refer to the product setup instructions for more information. ... Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver This is running on a Windows XP SP2 box with 1GB RAM. Any ideas of what to look for would be appreciated. John |
3 answers
When you say that you have set SQLSERVER_ABSPATH, how have you set it?
If you are running Jazz/RTC as a service, then the path you specify should be an absolute path to the directory. - Matt Lavin Jazz Server Team On Wed, 2008-11-19 at 21:27 +0000, sawyerjw wrote: > SQLSERVER_ABSPATH |
When you say that you have set SQLSERVER_ABSPATH, how have you set it? Hi, Matt, SQLSERVER_ABSPATH is set to the following value: C:\Program Files\IBM\JazzTeamServer\server\sqlserver The .jar file resides in that same folder. According to the docs, one or the other should be sufficient. We did both just to be sure. Thanks. |
It sounds like you have configured things correctly, so I'm not sure
that the solution is. The last thing I can think of is the ' ' in your path might be causing trouble. Would it be possible for you to try putting the .jar files in a directory other than one with a ' ' (like "C:\sql-drivers") and try again? - Matt Lavin Jazz Server Team On Fri, 2008-11-21 at 20:17 +0000, sawyerjw wrote: lavinmwrote: |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.