com.partnersoft.v3x.io.sql
Class DatabaseConnectionConfig

java.lang.Object
  com.partnersoft.v3x.io.sql.DatabaseConnectionConfig

All Implemented Interfaces:

java.io.Serializable

public class DatabaseConnectionConfig
extends java.lang.Object
implements java.io.Serializable

Configuration for a database connection - driver, URL, user, password, etc.

See Also:

Serialized Form

Constructor Summary

DatabaseConnectionConfig()
Create a new DatabaseConnectionConfig.

Method Summary

DatabaseConnectionConfig	changeDatabase(java.lang.String newDatabaseName)
java.lang.Object	clone()
java.sql.Connection	createConnection()
java.sql.Connection	createReadOnlyConnection()
java.lang.String	determineURL()
java.lang.String	getDatabaseDriver() Driver of JDBC connection, defaults to "sun.jdbc.odbc.JdbcOdbcDriver"
static java.lang.String	getDatabaseFromURL(java.lang.String url)
java.lang.String	getDatabaseName() Database name for extraction (optional).
java.lang.String	getDatabasePassword() Database password for extraction (optional).
java.lang.String	getDatabasePath() Database path for extraction (optional).
java.lang.String	getDatabaseProperties() Database properties for extraction (optional).
java.lang.String	getDatabaseServer() Database server for extraction (optional).
java.lang.String	getDatabaseType() Database type for extraction (optional).
java.lang.String	getDatabaseURL() URL of JDBC connection, e.g.
java.lang.String	getDatabaseUser() Database user for extraction (optional).
static java.lang.String	getDriverForType(java.lang.String type)
static java.lang.String	getDriverForURL(java.lang.String url)
static java.lang.String	makeURL(java.lang.String type, java.lang.String server, java.lang.String database, java.lang.String databasePath, java.lang.String properties)
void	setDatabaseDriver(java.lang.String newDatabaseDriver)
void	setDatabaseName(java.lang.String newDatabaseName)
void	setDatabasePassword(java.lang.String newDatabasePassword)
void	setDatabasePath(java.lang.String newDatabasePath)
void	setDatabaseProperties(java.lang.String newDatabaseProperties)
void	setDatabaseServer(java.lang.String newDatabaseServer)
void	setDatabaseType(java.lang.String newDatabaseType)
void	setDatabaseURL(java.lang.String newDatabaseURL)
void	setDatabaseUser(java.lang.String newDatabaseUser)

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseConnectionConfig

public DatabaseConnectionConfig()

Create a new DatabaseConnectionConfig.

Method Detail

getDriverForType

public static java.lang.String getDriverForType(java.lang.String type)

getDriverForURL

public static java.lang.String getDriverForURL(java.lang.String url)

getDatabaseFromURL

public static java.lang.String getDatabaseFromURL(java.lang.String url)

makeURL

public static java.lang.String makeURL(java.lang.String type,
                                       java.lang.String server,
                                       java.lang.String database,
                                       java.lang.String databasePath,
                                       java.lang.String properties)

getDatabasePassword

public java.lang.String getDatabasePassword()

Database password for extraction (optional).

setDatabasePassword

public void setDatabasePassword(java.lang.String newDatabasePassword)

getDatabaseURL

public java.lang.String getDatabaseURL()

URL of JDBC connection, e.g. "jdbc:odbc:Accounting", which corresponds to the ODBC database source (see ControlPanel->ODBC) named "Accounting" on a Windows machine.

setDatabaseURL

public void setDatabaseURL(java.lang.String newDatabaseURL)

getDatabaseDriver

public java.lang.String getDatabaseDriver()

Driver of JDBC connection, defaults to "sun.jdbc.odbc.JdbcOdbcDriver"

setDatabaseDriver

public void setDatabaseDriver(java.lang.String newDatabaseDriver)

getDatabaseUser

public java.lang.String getDatabaseUser()

Database user for extraction (optional).

setDatabaseUser

public void setDatabaseUser(java.lang.String newDatabaseUser)

getDatabaseServer

public java.lang.String getDatabaseServer()

Database server for extraction (optional).

setDatabaseServer

public void setDatabaseServer(java.lang.String newDatabaseServer)

getDatabaseType

public java.lang.String getDatabaseType()

Database type for extraction (optional).

setDatabaseType

public void setDatabaseType(java.lang.String newDatabaseType)

getDatabaseName

public java.lang.String getDatabaseName()

Database name for extraction (optional).

setDatabaseName

public void setDatabaseName(java.lang.String newDatabaseName)

getDatabasePath

public java.lang.String getDatabasePath()

Database path for extraction (optional).

setDatabasePath

public void setDatabasePath(java.lang.String newDatabasePath)

getDatabaseProperties

public java.lang.String getDatabaseProperties()

Database properties for extraction (optional).

setDatabaseProperties

public void setDatabaseProperties(java.lang.String newDatabaseProperties)

createReadOnlyConnection

public java.sql.Connection createReadOnlyConnection()
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

createConnection

public java.sql.Connection createConnection()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

determineURL

public java.lang.String determineURL()

changeDatabase

public DatabaseConnectionConfig changeDatabase(java.lang.String newDatabaseName)

clone

public java.lang.Object clone()

Overrides:

clone in class java.lang.Object