B.11. Microsoft SQL Server

B.11.1. Known issues with SQL Server

Example B.11. Example properties for Microsoft SQLServer

javax.jdo.option.ConnectionDriverName: \
javax.jdo.option.ConnectionURL: \

B.11.1. Known issues with SQL Server

  • SQL Server date fields are accurate only to the nearest 3 milliseconds, possibly resulting in precision loss in stored dates.

  • The ConnectionURL must always contain the "selectMethod=cursor" string.

  • Adding sendStringParametersAsUnicode=false to the ConnectionURL may significantly increase performance.

  • The Microsoft SQL Server driver only emulates batch updates. The DataDirect JDBC driver has true support for batch updates, and may result in a significant performance gain.

  • Floats and doubles may lose precision when stored.

  • TEXT columns cannot be used in queries.