-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Robert,
On 2/1/2011 11:32 AM, robert.jen...@surecomp.com wrote: > Update: problem found and corrected.. now working... caused by a > leading space in the url setting url=" > jdbc:sqlserver://allmatch-test:1433;databaseName=system;" Oops. > Update: I have amended the code not to supply a username/password to > getConnection since it is not supported. Filip recently applied a patch that allows a username and password to be supplied. Here's the BZ entry: https://issues.apache.org/bugzilla/show_bug.cgi?id=49543 > I have gotten past that point. But now it is reporting the following; > > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of > cla > ss 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL ' > jdbc:sqlserv > er://allmatch-test:1433;databaseName=system;' Looks like that space is still there. Try re-deploying your webapp completely. If you don't know what that means, then to this: 1. Stop Tomcat 2. Delete the CATALINA_BASE/work directory 3. Delete any files like CATALINA_BASE/conf/[service]/[engine]/[yourweapp].xml 4. Re-start Tomcat Tomcat will copy your META-INF/context.xml file into CATALINA_BASE/conf/[service]/[engine]/[yourweapp].xml during deployment and cache it even if you update the WAR file. This is entirely intentional and allows system administrators to specify configuration that overrides that contained within the WAR file. > the following jar was added to tomcat\lib prior to starting tomcat > > sqljdbc.jar - which is the Microsoft sql server driver That's right where it should be. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk1IlV4ACgkQ9CaO5/Lv0PBWHQCgxF3bReVYroOBepJV2g4QK5Aj x5YAnRE7kSAbNZeDP9zuiwGla17cu3b0 =en2g -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
