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]
