PostgreSQL

Note:

Although other versions are available commercially, the Together company supports the open-source version of PostgreSQL for the Linux operating system for use with DODS

PostgreSQL is a popular open-source database used with DODS however, DODS requires a special column named OID in each table. However, OID is a reserved word in PostgreSQL.

Fortunately, the column names used for OID and VERSION are configurable. To configure these names, add the following lines to your application configuration file:

DatabaseManager.ObjectIdColumnName = "<ColName_for_ObjectId>"
DatabaseManager.VersionColumnName = "<ColName_for_Version>"

where <ColName_for_ObjectId> and <ColName_for_Version> are the column names you want to use instead of OID and VERSION.

Configuration example:

#-------------------------------------------------------------------
# Database Manager Configuration
#-------------------------------------------------------------------

DatabaseManager.Databases[] = <database_id>
DatabaseManager.DefaultDatabase = <database_id>
DatabaseManager.Debug = true
DatabaseManager.DB.<database_id>.ClassType = Standard
DatabaseManager.DB.<database_id>.Connection.User = <username>
DatabaseManager.DB.<database_id>.Connection.Password = <password>
DatabaseManager.DB.<database_id>.Connection.MaxPoolSize = 5
DatabaseManager.DB.<database_id>.Connection.AllocationTimeout = 10000
DatabaseManager.DB.<database_id>.Connection.Logging = true
DatabaseManager.DB.<database_id>.ObjectId.CacheSize = 1024
DatabaseManager.DB.<database_id>.ObjectId.MinValue = 100
DatabaseManager.DB.<database_id>.JdbcDriver = "org.postgresql.Driver"
DatabaseManager.DB.<database_id>.Connection.Url ="jdbc:postgresql://<host>/<db_instance>"

To specify character encoding for Postgresql you can specify the 'charSet' parameter within the connection URL.

DatabaseManager.DB.example.Connection.Url =
       "jdbc:postgresql://192.168.1.1/yourDbName?charSet=iso-8859-1"

This is the link where you can find all needed information and downloads for PostgreSQL database:

http://www.postgresql.org