Package generalDatabase.postgresql

Class PostgreSQLSystem

java.lang.Object

generalDatabase.DBSystem

generalDatabase.ServerBasedSystem

generalDatabase.postgresql.PostgreSQLSystem

All Implemented Interfaces:

PamSettings, SettingsNameProvider

public class PostgreSQLSystem
extends ServerBasedSystem

Field Summary

Fields

Modifier and Type	Field	Description
static final String	SYSTEMNAME

Fields inherited from class generalDatabase.ServerBasedSystem

mySQLParameters

Fields inherited from class generalDatabase.DBSystem

keywords2003

Constructor Summary

Constructors

Constructor	Description
PostgreSQLSystem(DBControl dbControl, int settingsStore)	System for PostgreSQL databases.

Method Summary

Modifier and Type	Method	Description
String	buildDatabaseUrl(String ipAddress, int portNumber, String databaseName)
String	checkAvailableDatabaseResult(ResultSet result)
String	getAvailableDatabaseString()
int	getDefaultPort()
String	getDefaultUser()
String	getDriverClassName()
String	getSchemaName()	Get the database schema name - the name of the databse on the server which manages the other databases
SQLTypes	getSqlTypes()	Get the SQLTypes object which can be used to preform system specific formatting of SQL strings.
String	getSystemName()
String	getUnitType()

Methods inherited from class generalDatabase.ServerBasedSystem

browseDatabases, browseDatabasesFX, canCreate, checkDatabaseExists, create, createNewDatabase, createPamCursor, exists, getConnection, getDatabaseName, getDialogPaneFX, getDialogPanel, getSettingsReference, getSettingsVersion, getUnitName, hasDriver, isServerConnected, makeDefaultParams, restoreSettings

Methods inherited from class generalDatabase.DBSystem

canOpenDatabase, checkDatabaseExists, closeConnection, getConnection, getKeywords, getShortDatabaseName, openCurrentDatabase, reOpenConnection

Methods inherited from class java.lang.Object

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

Field Details

SYSTEMNAME

public static final String SYSTEMNAME

See Also:

• Constant Field Values

Constructor Details

PostgreSQLSystem

public PostgreSQLSystem(DBControl dbControl,
 int settingsStore)

System for PostgreSQL databases. Partially works, but some fundamental problems, e.g. with Types.BIT which just doesn't work. Will need to do a fair bit of work to replace with a more standard Boolean before this can be used.

Parameters:

dbControl -

settingsStore -

Method Details

getDriverClassName

public String getDriverClassName()

Specified by:

getDriverClassName in class ServerBasedSystem

getDefaultUser

public String getDefaultUser()

Specified by:

getDefaultUser in class ServerBasedSystem

getAvailableDatabaseString

public String getAvailableDatabaseString()

Specified by:

getAvailableDatabaseString in class ServerBasedSystem

checkAvailableDatabaseResult

public String checkAvailableDatabaseResult(ResultSet result)

Specified by:

checkAvailableDatabaseResult in class ServerBasedSystem

buildDatabaseUrl

public String buildDatabaseUrl(String ipAddress,
 int portNumber,
 String databaseName)

Specified by:

buildDatabaseUrl in class ServerBasedSystem

getSchemaName

public String getSchemaName()

Description copied from class: ServerBasedSystem

Get the database schema name - the name of the databse on the server which manages the other databases

Specified by:

getSchemaName in class ServerBasedSystem

Returns:

getUnitType

public String getUnitType()

Returns:

A Name specific to the type, e.g. Click detector

getSystemName

public String getSystemName()

Specified by:

getSystemName in class ServerBasedSystem

Returns:

The name of the database system

getDefaultPort

public int getDefaultPort()

Specified by:

getDefaultPort in class ServerBasedSystem

getSqlTypes

public SQLTypes getSqlTypes()

Description copied from class: DBSystem

Get the SQLTypes object which can be used to preform system specific formatting of SQL strings.

Specified by:

getSqlTypes in class DBSystem

Returns: