Issue with connection pool using JDBC Driver on tomcat 5.0

Hi,

I am facing problem in configuring and using connection pooling on tomcat 5.0. I am using JDBC Driver v.1.1 for SQL Server 2005.

Can anybody point me to appropriate samle code or guideline?

Thanks & Regards,

Bhavin P Panchal

Hi Bhavin,

Please elaborate on what you are having trouble with. Is there any error messages/exceptions raised? If so, please post the error message so we can assist you.

Thanks,

Jimmy

|||

I was getting Invalid Username "sa" for SQL server 2005. I am looking forward for step by step guide on How to configure Connection Pool with latest version of sqljdbc.jar with tomcat 5.0

Thanks & Regards,

Bhavin

|||

It sounds like you would like to connect from tomcat to SQL Server using SQL Server user authentication instead of Windows Integrated authentication. Can you confirm that you can use the "SQL Server Management Studio" (SSMS) application to connect to the SQL Server using the "sa" user account?

If SSMS also reports an error, you can use SSMS to connect using Windows Integrated authentication and modify the configuration to support SQL Server user authentication. Right click on the SQL Server and open the server properties. Under the "Security" option, you can change "Server Authentication" mode to "SQL Server and Windows Authentication mode". You will need to restart SQL Server.

If you can connect use SSMS to SQL Server with the "sa" account, then please provide the connection string in which you are trying to connect with.

For connection pooling, please refer to the following topic http://msdn2.microsoft.com/en-us/library/ms378721.aspx for additional information regarding Microsoft SQL Server 2005 JDBC driver's support.

HTH,

Jimmy

|||

Nope.. I am not using integrated security option to do connection pooling. This username and password are specified in context.xml file of web application developed in java/jsp.

However, thanks for your valuable help.

regards,

Bhavin

|||

Hi Bhavin,

Did you resolve this yet? If so, can you post your sample context.xml file for everyone's benefit.

Thanks,

Jaaved