aspose file tools*
The moose likes Tomcat and the fly likes Tomcat service wont start - jdbc driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat service wont start - jdbc driver" Watch "Tomcat service wont start - jdbc driver" New topic
Author

Tomcat service wont start - jdbc driver

Nick Harvey
Greenhorn

Joined: Nov 17, 2011
Posts: 2
Hi,

I have been having a problem with my tomcat installation which suddenly stopped working a couple of weeks ago. I have been trying to find a solution ever since but have had no luck so thought I would try to reach out for help.

Whenever I start my Tomcat service i get the following in the catalina.log file:

17-Nov-2011 16:37:36 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
17-Nov-2011 16:37:36 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2208 ms
17-Nov-2011 16:37:36 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
17-Nov-2011 16:37:36 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.33
17-Nov-2011 16:37:36 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled


And that is the last line it logs. From checking old logs from a few months ago I notice that I miss several lines including the final Server startup successfully line.

I narrowed it down to my jdbc driver. If I remove the following file from my lib folder then the service starts up without a problem.

sqljdbc4.jar

The jar file itself is fine as the same one works on my other environments. Does this indicate a problem with my SQL 2008 installation perhaps (considering my Tomcat installation has not changed since it was last working).

Thanks for any help or advice anyone can provide.
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16305
    
  21

Welcome to the JavaRanchm Nick!

When the catalina.out file comes up short, it's often useful to look in the localhost logs. Some of the real show-stoppers appear there, instead of in catalina.out.

There are alternative JDBC drivers for MS SQL Server, and, in fact, I switched to the SourceForge one because it was better at handling gnarly transactions than Microsoft's own driver was. So one option is to try one of the other drivers. Although any properly-installed JDBC driver should not be keeping Tomcat from coming up.

Here's another thought, though - is Tomcat dying, or is it hanging? If it's hanging, there may be a firewall problem or SQL Server configuration problem that keeps the system from being able to establish a connection to MS SQL Server.


Customer surveys are for companies who didn't pay proper attention to begin with.
Nick Harvey
Greenhorn

Joined: Nov 17, 2011
Posts: 2
Thanks for your reply Tim.

I will try a different jdbc driver as you suggest.

By the way my localhost logs are empty, and I checked all of the other log files too without noticing any errors.

Tomcat isn't dying, it is just waiting because it believes that it has successfully started the service - the icon changes to the 'started' icon. Your firewall theory sounded like a good suggested so I deactivated it and uninstalled my anti virus but unfortunately it didn't help.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Tomcat service wont start - jdbc driver