database server seeing blank user name

["Scott Cowley" <scott.cowley (at) utah.edu>]

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:dns4 (at) cornell.edu] 
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 (at) tomcat.apache.org To unsubscribe, 
>e-mail: users-unsubscribe (at) tomcat.apache.org
>For additional commands, e-mail: users-help (at) tomcat.apache.org
>


---------------------------------------------------------------------
To start a new topic, e-mail: users (at) tomcat.apache.org To unsubscribe,
e-mail: users-unsubscribe (at) tomcat.apache.org
For additional commands, e-mail: users-help (at) tomcat.apache.org


---------------------------------------------------------------------
To start a new topic, e-mail: users (at) tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe (at) tomcat.apache.org
For additional commands, e-mail: users-help (at) tomcat.apache.org