Thanks for the reply, David. We made the changes but didn't get rid of the error. (Shouldn't have to restart Tomcat, right? Altho we did.) Any other ideas ? - scott cowley
-----Original Message----- From: David Smith [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 11:48 AM To: Tomcat Users List Subject: Re: database server seeing blank user name Most of your Resource def looks good. You should drop the leading capitalization on DatabaseName="tomcat_test" and SelectMethod="cursor". These will never be set as is. <Resource name="jdbc/tests" auth="Container" type="javax.sql.DataSource" username="testuser" password="testpass" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost:/" databaseName="tomcat_test" selectMethod="cursor" maxActive="8" /> --David Scott Cowley wrote: >Hello, Tomcats! > >What might be the reason for a javax servlet exception such as this? >"Cannot create poolable connection factory (login failed for user ''.)" >It appears that either tomcat or the driver are dropping the user's >name. > >Details: >----------- >OS: MS Win Server 2003 >Tomcat: 5.5.17 > >Application Directory's "Context.xml" -attached. Also added below. > >JDBC driver: (microsoft, from ms support site) sqljdbc 1.0 > >DB server: MSSQL 2005 > >----------------------- context.xml-------------------------------- ><?xml version="1.0" encoding="UTF-8"?> > ><Context> > > <Resource name="jdbc/tests" auth="Container" > type="javax.sql.DataSource" > username="testuser" > password="testpass" > >driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" > url="jdbc:sqlserver://localhost:/" > DatabaseName="tomcat_test" > SelectMethod="cursor" > maxActive="8" > /> > ></Context> > > >----------------------------------------------------------------------- >- > ><?xml version="1.0" encoding="UTF-8"?> > ><Context> > > <Resource name="jdbc/tests" auth="Container" > type="javax.sql.DataSource" > username="testuser" > password="testpass" > driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" > url="jdbc:sqlserver://localhost:/" > DatabaseName="tomcat_test" > SelectMethod="cursor" > maxActive="8" > /> > ></Context> > > >----------------------------------------------------------------------- >- > >--------------------------------------------------------------------- >To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, >e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
