You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by Derek Mahar <DM...@penson.ca> on 2004/01/08 19:26:04 UTC
[DBCP] Microsoft SQL Server and connectionProperties option
How do I set Microsoft SQL Server JDBC driver properties using the DBCP
connectionProperties option? Presently, in order to set the
SelectMethod and DatabaseName properties of my Tomcat connection pool,
my Tomcat server.xml file uses the following JDBC driver URL:
jdbc:microsoft:sqlserver://SSMTL001:1433;SelectMethod=cursor;DatabaseNam
e=Bond
How do I move these to the connectionProperties option?
Thank you,
Derek
-------------------------------------
Derek Mahar
Software Developer
Penson Financial Services Canada
360 St-Jacques St West, 12th Floor
Montreal QC H2Y 1P5
514.841.9665 x212 Phone
514.841.3750 Fax
-------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
Re: [DBCP] Microsoft SQL Server and connectionProperties option
Posted by Dirk Verbeeck <di...@pandora.be>.
You can use ";" as separator in the connectionProperties option.
<connectionProperties>SelectMethod=cursor;DatabaseName=Bond</connectionProperties>
-- Dirk
Derek Mahar wrote:
> How do I set Microsoft SQL Server JDBC driver properties using the DBCP
> connectionProperties option? Presently, in order to set the
> SelectMethod and DatabaseName properties of my Tomcat connection pool,
> my Tomcat server.xml file uses the following JDBC driver URL:
>
> jdbc:microsoft:sqlserver://SSMTL001:1433;SelectMethod=cursor;DatabaseNam
> e=Bond
>
> How do I move these to the connectionProperties option?
>
> Thank you,
>
> Derek
>
> -------------------------------------
> Derek Mahar
> Software Developer
> Penson Financial Services Canada
> 360 St-Jacques St West, 12th Floor
> Montreal QC H2Y 1P5
> 514.841.9665 x212 Phone
> 514.841.3750 Fax
> -------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org