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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
