java.lang.Object

net.sourceforge.jtds.jdbc.Driver

All Implemented Interfaces:: Driver

public class Driver extends Object implements Driver

jTDS implementation of the java.sql.Driver interface.

Implementation note:

Property text names and descriptions are loaded from an external file resource. This allows the actual names and descriptions to be changed or localised without impacting this code.
The way in which the URL is parsed and converted to properties is rather different from the original jTDS Driver class. See parseURL and Connection.unpackProperties methods for more detail.

Version:

$Id: Driver.java,v 1.70.2.4 2009-12-30 11:19:40 ickzon Exp $

Author:

Brian Heineman, Mike Hutchinson, Alin Sinpalean

See Also:

Field Summary

Fields

Modifier and Type

Field

Description

static final String

APPNAME

static final String

AUTOCOMMIT

static final String

BATCHSIZE

static final String

BINDADDRESS

static final String

BUFFERDIR

static final String

BUFFERMAXMEMORY

static final String

BUFFERMINPACKETS

static final String

CACHEMETA

static final String

CHARSET

static final String

DATABASENAME

static final String

DOMAIN

private static String

driverPrefix

URL prefix used by the driver (i.e jdbc:jtds:).

static final String

INSTANCE

static final String

LANGUAGE

static final String

LASTUPDATECOUNT

static final String

LOBBUFFER

static final String

LOGFILE

static final String

LOGINTIMEOUT

static final String

MACADDRESS

(package private) static final int

MAJOR_VERSION

Driver major version.

static final String

MAXSTATEMENTS

(package private) static final int

MINOR_VERSION

Driver minor version.

(package private) static final String

MISC_VERSION

Driver version miscellanea (e.g "-rc2", ".1" or null).

static final String

NAMEDPIPE

static final String

PACKETSIZE

static final String

PASSWORD

static final String

PORTNUMBER

static final String

PREPARESQL

static final String

PROCESSID

static final String

PROGNAME

static final String

SENDSTRINGPARAMETERSASUNICODE

static final String

SERVERNAME

static final String

SERVERTYPE

static final String

SOKEEPALIVE

static final String

SOTIMEOUT

static final int

SQLSERVER

Microsoft SQL Server.

static final String

SSL

static final int

SYBASE

Sybase ASE.

static final String

TCPNODELAY

static final String

TDS

static final int

TDS42

TDS 4.2 protocol (SQL Server 6.5 and later and Sybase 9 and later).

static final int

TDS50

TDS 5.0 protocol (Sybase 10 and later).

static final int

TDS70

TDS 7.0 protocol (SQL Server 7.0 and later).

static final int

TDS80

TDS 8.0 protocol (SQL Server 2000 and later)

static final int

TDS81

TDS 8.1 protocol (SQL Server 2000 SP1 and later).

static final int

TDS90

TDS 9.0 protocol (SQL Server 2005 and later)

static final String

USECURSORS

static final String

USEJCIFS

static final String

USEKERBEROS

static final String

USELOBS

static final String

USENTLMV2

static final String

USER

static final String

WSID

static final String

XAEMULATION
Constructor Summary

Constructors

Constructor

Description

Driver()
Method Summary

Modifier and Type

Method

Description

boolean

acceptsURL(String url)

Connection

connect(String url, Properties info)

private static Map

createChoicesMap()

Creates a map of driver properties whose choices field should be set when calling getPropertyInfo(String, Properties).

private static Map

createRequiredTrueMap()

Creates a map of driver properties that should be marked as required when calling getPropertyInfo(String, Properties).

int

getMajorVersion()

int

getMinorVersion()

Logger

getParentLogger()

DriverPropertyInfo[]

getPropertyInfo(String url, Properties props)

static final String

getVersion()

Returns the driver version.

boolean

jdbcCompliant()

static void

main(String[] args)

private static int

nextToken(String url, int pos, StringBuilder token)

Extract the next lexical token from the URL.

private static Properties

parseURL(String url, Properties info)

Parse the driver URL and extract the properties.

private Properties

setupConnectProperties(String url, Properties info)

Sets up properties for the connect(String, java.util.Properties) method.

String

toString()

Returns the string form of the object.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details
- driverPrefix
  
  private static String driverPrefix
  
  URL prefix used by the driver (i.e jdbc:jtds:).
- MAJOR_VERSION
  
  static final int MAJOR_VERSION
  
  Driver major version.
  See Also:
  
  Constant Field Values
- MINOR_VERSION
  
  static final int MINOR_VERSION
  
  Driver minor version.
  See Also:
  
  Constant Field Values
- MISC_VERSION
  
  static final String MISC_VERSION
  
  Driver version miscellanea (e.g "-rc2", ".1" or null).
  See Also:
  
  Constant Field Values
- TDS42
  
  public static final int TDS42
  
  TDS 4.2 protocol (SQL Server 6.5 and later and Sybase 9 and later).
  See Also:
  
  Constant Field Values
- TDS50
  
  public static final int TDS50
  
  TDS 5.0 protocol (Sybase 10 and later).
  See Also:
  
  Constant Field Values
- TDS70
  
  public static final int TDS70
  
  TDS 7.0 protocol (SQL Server 7.0 and later).
  See Also:
  
  Constant Field Values
- TDS80
  
  public static final int TDS80
  
  TDS 8.0 protocol (SQL Server 2000 and later)
  See Also:
  
  Constant Field Values
- TDS81
  
  public static final int TDS81
  
  TDS 8.1 protocol (SQL Server 2000 SP1 and later).
  See Also:
  
  Constant Field Values
- TDS90
  
  public static final int TDS90
  
  TDS 9.0 protocol (SQL Server 2005 and later)
  See Also:
  
  Constant Field Values
- SQLSERVER
  
  public static final int SQLSERVER
  
  Microsoft SQL Server.
  See Also:
  
  Constant Field Values
- SYBASE
  
  public static final int SYBASE
  
  Sybase ASE.
  See Also:
  
  Constant Field Values
- APPNAME
  
  public static final String APPNAME
  See Also:
  
  Constant Field Values
- AUTOCOMMIT
  
  public static final String AUTOCOMMIT
  See Also:
  
  Constant Field Values
- BATCHSIZE
  
  public static final String BATCHSIZE
  See Also:
  
  Constant Field Values
- BINDADDRESS
  
  public static final String BINDADDRESS
  See Also:
  
  Constant Field Values
- BUFFERDIR
  
  public static final String BUFFERDIR
  See Also:
  
  Constant Field Values
- BUFFERMAXMEMORY
  
  public static final String BUFFERMAXMEMORY
  See Also:
  
  Constant Field Values
- BUFFERMINPACKETS
  
  public static final String BUFFERMINPACKETS
  See Also:
  
  Constant Field Values
- CACHEMETA
  
  public static final String CACHEMETA
  See Also:
  
  Constant Field Values
- CHARSET
  
  public static final String CHARSET
  See Also:
  
  Constant Field Values
- DATABASENAME
  
  public static final String DATABASENAME
  See Also:
  
  Constant Field Values
- DOMAIN
  
  public static final String DOMAIN
  See Also:
  
  Constant Field Values
- INSTANCE
  
  public static final String INSTANCE
  See Also:
  
  Constant Field Values
- LANGUAGE
  
  public static final String LANGUAGE
  See Also:
  
  Constant Field Values
- LASTUPDATECOUNT
  
  public static final String LASTUPDATECOUNT
  See Also:
  
  Constant Field Values
- LOBBUFFER
  
  public static final String LOBBUFFER
  See Also:
  
  Constant Field Values
- LOGFILE
  
  public static final String LOGFILE
  See Also:
  
  Constant Field Values
- LOGINTIMEOUT
  
  public static final String LOGINTIMEOUT
  See Also:
  
  Constant Field Values
- MACADDRESS
  
  public static final String MACADDRESS
  See Also:
  
  Constant Field Values
- MAXSTATEMENTS
  
  public static final String MAXSTATEMENTS
  See Also:
  
  Constant Field Values
- NAMEDPIPE
  
  public static final String NAMEDPIPE
  See Also:
  
  Constant Field Values
- PACKETSIZE
  
  public static final String PACKETSIZE
  See Also:
  
  Constant Field Values
- PASSWORD
  
  public static final String PASSWORD
  See Also:
  
  Constant Field Values
- PORTNUMBER
  
  public static final String PORTNUMBER
  See Also:
  
  Constant Field Values
- PREPARESQL
  
  public static final String PREPARESQL
  See Also:
  
  Constant Field Values
- PROGNAME
  
  public static final String PROGNAME
  See Also:
  
  Constant Field Values
- SERVERNAME
  
  public static final String SERVERNAME
  See Also:
  
  Constant Field Values
- SERVERTYPE
  
  public static final String SERVERTYPE
  See Also:
  
  Constant Field Values
- SOTIMEOUT
  
  public static final String SOTIMEOUT
  See Also:
  
  Constant Field Values
- SOKEEPALIVE
  
  public static final String SOKEEPALIVE
  See Also:
  
  Constant Field Values
- PROCESSID
  
  public static final String PROCESSID
  See Also:
  
  Constant Field Values
- SSL
  
  public static final String SSL
  See Also:
  
  Constant Field Values
- TCPNODELAY
  
  public static final String TCPNODELAY
  See Also:
  
  Constant Field Values
- TDS
  
  public static final String TDS
  See Also:
  
  Constant Field Values
- USECURSORS
  
  public static final String USECURSORS
  See Also:
  
  Constant Field Values
- USEJCIFS
  
  public static final String USEJCIFS
  See Also:
  
  Constant Field Values
- USENTLMV2
  
  public static final String USENTLMV2
  See Also:
  
  Constant Field Values
- USEKERBEROS
  
  public static final String USEKERBEROS
  See Also:
  
  Constant Field Values
- USELOBS
  
  public static final String USELOBS
  See Also:
  
  Constant Field Values
- USER
  
  public static final String USER
  See Also:
  
  Constant Field Values
- SENDSTRINGPARAMETERSASUNICODE
  
  public static final String SENDSTRINGPARAMETERSASUNICODE
  See Also:
  
  Constant Field Values
- WSID
  
  public static final String WSID
  See Also:
  
  Constant Field Values
- XAEMULATION
  
  public static final String XAEMULATION
  See Also:
  
  Constant Field Values
Constructor Details
- Driver
  
  public Driver()
Method Details
- getMajorVersion
  
  public int getMajorVersion()
  
  Specified by:
  
  getMajorVersion in interface Driver
- getMinorVersion
  
  public int getMinorVersion()
  
  Specified by:
  
  getMinorVersion in interface Driver
- getVersion
  
  public static final String getVersion()
  
  Returns the driver version.
  Per [908906] 0.7: Static Version information, please.
  
  Returns:
  
  the driver version
- toString
  
  public String toString()
  
  Returns the string form of the object.
  Per [887120] DriverVersion.getDriverVersion(); this will return a short version name.
  Added back to driver per [1006449] 0.9rc1: Driver version broken
  
  Overrides:
  
  toString in class Object
  
  Returns:
  
  the driver version
- jdbcCompliant
  
  public boolean jdbcCompliant()
  
  Specified by:
  
  jdbcCompliant in interface Driver
- acceptsURL
  
  public boolean acceptsURL(String url) throws SQLException
  
  Specified by:
  
  acceptsURL in interface Driver
  
  Throws:
  
  SQLException
- connect
  
  public Connection connect(String url, Properties info) throws SQLException
  
  Specified by:
  
  connect in interface Driver
  
  Throws:
  
  SQLException
- getPropertyInfo
  
  public DriverPropertyInfo[] getPropertyInfo(String url, Properties props) throws SQLException
  
  Specified by:
  
  getPropertyInfo in interface Driver
  
  Throws:
  
  SQLException
- setupConnectProperties
  
  private Properties setupConnectProperties(String url, Properties info) throws SQLException
  
  Sets up properties for the connect(String, java.util.Properties) method.
  
  Parameters:
  
  url - the URL of the database to which to connect
  
  info - a list of arbitrary string tag/value pairs as connection arguments.
  
  Returns:
  
  the set of properties for the connection
  
  Throws:
  
  SQLException - if an error occurs parsing the URL
- createChoicesMap
  
  private static Map createChoicesMap()
  
  Creates a map of driver properties whose choices field should be set when calling getPropertyInfo(String, Properties).
  The values in the map are the String[] objects that should be set to the choices field.
  
  Returns:
  
  The map of DriverPropertyInfo objects whose choices should be set.
- createRequiredTrueMap
  
  private static Map createRequiredTrueMap()
  
  Creates a map of driver properties that should be marked as required when calling getPropertyInfo(String, Properties).
  Note that only the key of the map is used to determine whether the required field should be set to true. If the key does not exist in the map, then the required field is set to false.
  
  Returns:
  
  The map of DriverPropertyInfo objects where required should be set to true.
- parseURL
  
  private static Properties parseURL(String url, Properties info)
  
  Parse the driver URL and extract the properties.
  
  Parameters:
  
  url - the URL to parse
  
  info - any existing properties already loaded in a Properties object
  
  Returns:
  
  the URL properties as a Properties object
- nextToken
  
  private static int nextToken(String url, int pos, StringBuilder token)
  
  Extract the next lexical token from the URL.
  
  Parameters:
  
  url - The URL being parsed
  
  pos - The current position in the URL string.
  
  token - The buffer containing the extracted token.
  
  Returns:
  
  The updated position as an int.
- main
  
  public static void main(String[] args)
- getParentLogger
  
  public Logger getParentLogger() throws SQLFeatureNotSupportedException
  
  Specified by:
  
  getParentLogger in interface Driver
  
  Throws:
  
  SQLFeatureNotSupportedException

Class Driver

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Details

driverPrefix

MAJOR_VERSION

MINOR_VERSION

MISC_VERSION

TDS42

TDS50

TDS70

TDS80

TDS81

TDS90

SQLSERVER

SYBASE

APPNAME

AUTOCOMMIT

BATCHSIZE

BINDADDRESS

BUFFERDIR

BUFFERMAXMEMORY

BUFFERMINPACKETS

CACHEMETA

CHARSET

DATABASENAME

DOMAIN

INSTANCE

LANGUAGE

LASTUPDATECOUNT

LOBBUFFER

LOGFILE

LOGINTIMEOUT

MACADDRESS

MAXSTATEMENTS

NAMEDPIPE

PACKETSIZE

PASSWORD

PORTNUMBER

PREPARESQL

PROGNAME

SERVERNAME

SERVERTYPE

SOTIMEOUT

SOKEEPALIVE

PROCESSID

SSL

TCPNODELAY

TDS

USECURSORS

USEJCIFS

USENTLMV2

USEKERBEROS

USELOBS

USER

SENDSTRINGPARAMETERSASUNICODE

WSID

XAEMULATION

Constructor Details

Driver

Method Details

getMajorVersion

getMinorVersion

getVersion

toString

jdbcCompliant

acceptsURL

connect

getPropertyInfo

setupConnectProperties

createChoicesMap

createRequiredTrueMap

parseURL

nextToken

main

getParentLogger