de.must.dataobj

Class ConnectionSpecification

java.lang.Object

de.must.dataobj.ConnectionSpecification

public class ConnectionSpecification
extends java.lang.Object

The specification needed to create a database connection.

See Also:

ConnectionHolder

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String[]	ACCESS_DRIVER
static boolean	autoCommitStandard Caution: Deadlocks occurred in MS SQL Server with auto-commit off!
static int	CONNECT_JDBC_DIRECT
static int	CONNECT_JDBC_ODBC_BY_DSN
static int	CONNECT_JDBC_ODBC_BY_FILE_PATH

Constructor Summary

Constructors

Constructor and Description
ConnectionSpecification(java.io.File dbFile)
ConnectionSpecification(java.io.File dbFile, java.lang.String userName, java.lang.String password)
ConnectionSpecification(java.lang.String odbcName) Constructs a connection specification for a ODBC connection with blank user and password.
ConnectionSpecification(java.lang.String odbcName, java.lang.String userName, java.lang.String password) Constructs a connection specification for a ODBC connection.
ConnectionSpecification(java.lang.String url, java.lang.String driverName, java.lang.String userName, java.lang.String password) Constructs a connection specification for a direct JDBC connection.

Method Summary

Modifier and Type	Method and Description
java.sql.Connection	getConnection() Returns a connection as specified when constructed.
int	getConnectType() Returns the connect type
java.lang.String	getDriverName() Returns the driver's name
java.lang.String	getOdbcName() Returns the ODBC data source name name
java.lang.String	getPassword() Returns the password of the database user
java.lang.String	getUrl() Returns the URL
java.lang.String	getUserName() Returns the name of the database user
void	setDbCharset(java.lang.String dbCharset) Sets the database character set, e.g.
java.lang.String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

ACCESS_DRIVER

public static final java.lang.String[] ACCESS_DRIVER

CONNECT_JDBC_ODBC_BY_DSN

public static final int CONNECT_JDBC_ODBC_BY_DSN

See Also:

Constant Field Values

CONNECT_JDBC_DIRECT

public static final int CONNECT_JDBC_DIRECT

See Also:

Constant Field Values

CONNECT_JDBC_ODBC_BY_FILE_PATH

public static final int CONNECT_JDBC_ODBC_BY_FILE_PATH

See Also:

Constant Field Values

autoCommitStandard

public static boolean autoCommitStandard

Caution: Deadlocks occurred in MS SQL Server with auto-commit off! Before you set auto-commit off, please check whether all select statements should be extended by 'WITH (NOLOCK)' after each table to avoid deadlocks or find another solution to prevent deadlocks. In the point of view of cameleon's author, transaction is NOT necessary for his use cases.

Constructor Detail

ConnectionSpecification

public ConnectionSpecification(java.lang.String odbcName)

Constructs a connection specification for a ODBC connection with blank user and password.

Parameters:

odbcName - the ODBC data source name name

ConnectionSpecification

public ConnectionSpecification(java.lang.String odbcName,
                               java.lang.String userName,
                               java.lang.String password)

Constructs a connection specification for a ODBC connection.

Parameters:

odbcName - the ODBC data source name

userName - the name of the database user

password - the password of the database user

ConnectionSpecification

public ConnectionSpecification(java.lang.String url,
                               java.lang.String driverName,
                               java.lang.String userName,
                               java.lang.String password)

Constructs a connection specification for a direct JDBC connection.

Parameters:

url - the URL of the database to connect to

driverName - the name of the database drive to use

userName - the name of the database user

password - the password of the database user

ConnectionSpecification

public ConnectionSpecification(java.io.File dbFile)

ConnectionSpecification

public ConnectionSpecification(java.io.File dbFile,
                               java.lang.String userName,
                               java.lang.String password)

Method Detail

setDbCharset

public void setDbCharset(java.lang.String dbCharset)

Sets the database character set, e.g. UTF-8.

Parameters:

dbCharset - the database character set to use

getConnectType

public int getConnectType()

Returns the connect type

Returns:

the connect type

getOdbcName

public java.lang.String getOdbcName()

Returns the ODBC data source name name

Returns:

the ODBC data source name name

getUrl

public java.lang.String getUrl()

Returns the URL

Returns:

the URL

getDriverName

public java.lang.String getDriverName()

Returns the driver's name

Returns:

the driver's name

getUserName

public java.lang.String getUserName()

Returns the name of the database user

Returns:

the name of the database user

getPassword

public java.lang.String getPassword()

Returns the password of the database user

Returns:

the password of the database user

getConnection

public java.sql.Connection getConnection()
                                  throws java.lang.ClassNotFoundException,
                                         java.sql.SQLException

Returns a connection as specified when constructed.

Returns:

a connection as specified when constructed

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object