Got me unless MS is being it's usual cryptic self with the error
messages. Check the docs for your jdbc driver to be sure you've put in
the url and other parameters correctly. Also check the logs on the MS
SQL server for any helpful hints on that end.
---David
Scott Cowley wrote:
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]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
