I wonder if recipients can advise me what Windows user account would be used by an external process triggered by a JSP app running on Tomcat?
We have an JSP application, served up by Tomcat, with a MySQL back-end database. At intervals it is necessary to do a bulk update of the database. We intend eventually to do this via the app through the JDBC interface but for the time being we have taken a short cut. Calling this shortcut from within the app closes down Tomcat on the server and launches a batch file, which in turn calls .sql script files which load data files into the database. The the batch file restarts the Tomcat service. The user (who is is on a remote PC, not the server) is advised to close their browser, leave it a couple of minutes, then restart. Messy, I know, but within the time it's the best we've been able to do. Tested on a Windows XP Pro 'server' this all works fine, but in situ at the customer's site we are getting errors that suggest that there may be permissions issues arising. So the question is: when we shutdown the Tomcat service and launch the batch files, under which Windows account would this be running? The customer has a Windows 2003 server, and has a Windows 2003 AD environment, though I believe the accounts we are using on the server are machine accounts. In fact, under what Windows account does Tomcat execute anyway? Does it create its own machine account when it is installed, or does it take the permissions of whoever first installed it? Tom Burke
