-----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
|