commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: [DBCP] Microsoft SQL Server and connectionProperties option
Date Sun, 11 Jan 2004 18:45:35 GMT
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


Mime
View raw message