tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: help setting up connection pool with sql server
Date Tue, 01 Feb 2011 23:21:02 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Robert,

On 2/1/2011 11:32 AM, Robert.Jenkin@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message