B.9. Microsoft SQL Server
Prev | Appendix B. Supported Databases | Next

## B.9. Microsoft SQL Server

Example B.9. Example properties for Microsoft SQLServer

    javax.jdo.option.ConnectionDriverName: \
        com.microsoft.jdbc.sqlserver.SQLServerDriver
    javax.jdo.option.ConnectionURL: \
        jdbc:microsoft:sqlserver://SERVER_NAME:1433;DatabaseName=DB_NAME;SelectMethod=cursor

### B.9.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.

- 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.

Prev | Up | Next
B.8. Microsoft Access | Home | B.10. Microsoft FoxPro