Getting Started
What are the class names of the Driver, DataSource, ConnectionPoolDataSource and XADataSource implementations?
Interface
JTDS Implementation
Java. SQL. Driver
Net. sourceforge. jtds. jdbc. Driver
Javax. SQL. DataSource
Net. sourceforge. jtds. jdbcx. JtdsDataSource
Javax. SQL. ConnectionPoolDataSource
Net. sourceforge. jtds. jdbcx. JtdsDataSource
Javax. SQL. XADataSource
Net. sourceforge. jtds. jdbcx. JtdsDataSource
^ Top ^
What is the URL format used by jTDS?
The URL format for jTDS is: jdbc: jtds: <server_type >://< server> [: <port>] [/<database>] [; <property >=< value> [;...]
Where <server_type> is one of either 'sqlserver 'or 'sybase' (their meaning is quite obvious ), <port> is the port the database server is listening to (default is 1433 for SQL Server and 7100 for Sybase) and <database> is the database name -- JDBC term: catalog -- (if not specified, the user's default database is used ). the set of properties supported by jTDS is:
User (required)
User name to use for login. when using getConnection (String url, String user, String password) it's not required to set this property as it is passed as parameter, but you will have to set it when using getConnection (String url, Properties info) or TdsDataSource.
Password (required)
Password to use for login. when using getConnection (String url, String user, String password) it's not required to set this property as it is passed as parameter, but you will have to set it when using getConnection (String url, Properties info) or TdsDataSource.
TDS (default-"8.0" for SQL Server; "5.0" for Sybase)
The version of TDS to be used. TDS (Tabular Data Stream) is the protocol used by Microsoft SQL Server and Sybase to communicate with database clients. jTDS can use TDS 4.2, 5.0, 7.0 and 8.0. version 4.2 is used by SQL Server 6.5 and Sybase 10. version 5.0 is used with Sybase 11 onwards. version 7.0 is used by SQL Server 7.0; this protocol also works with SQL Server 2000. version 8.0 is used by SQL Server 2000 and SQL Server 2005.
