database.properties file

The database.properties file can be used to configure necessary database settings for your installation.  

Note: this functionality is enabled by creating the necessary entries in the database.properties file, which resides in your system's config directory.  You cannot manage this functionality via the user interface.

This file can be viewed/edited with any standard text editor.  

Below are examples depending on the JDBC Driver you are using.  

# =============================================================================

#

# In order to connect to the database, the Unanet application uses a JDBC

# driver.  You will need to configure the appropriate JDBC driver based on the

# database (Oracle or SQL Server) that you are using.

#

# Below are two possible configurations, one for Sql Server (JTDS) and the

# other for Oracle.  Please uncomment (by removing the leading #) the

# appropriate lines, making sure to also specify your host, port, database

# name, username and password entries.

#

# For more information on setting up this file, see the Unanet help

# documentation: https://help.unanet.com (choose your version).

#

# =============================================================================

# JTDS Driver for SQL*Server (Included with Unanet)

# =============================================================================

#

#    host = "myname.thedomain.com"

#    port = "1433"

#

#    Syntax:    unatime.database.url=jdbc:jtds:sqlserver://<<host>>:<<port>>/<<database name>>;sendStringParametersAsUnicode=false

#    Example 1: unatime.database.url=jdbc:jtds:sqlserver://myname.thedomain.com:1433/unanet;sendStringParametersAsUnicode=false

#    Example 2: unatime.database.url=jdbc:jtds:sqlserver://localhost:1433/unanet;sendStringParametersAsUnicode=false

#

# Change unatime.database.url below if database is on a different machine

# or port:

#

unatime.database.driver=net.sourceforge.jtds.jdbc.Driver

unatime.database.url=jdbc:jtds:sqlserver://localhost:1433/unanet;sendStringParametersAsUnicode=false

unatime.database.username=unanet

unatime.database.password=unanet

# NOTE:  If you are using named instances, there are two possible syntax options

#        you can use for the unatime.database.url property (make sure there is only one

#        unatime.database.url property uncommented in this file).  Depending on your

#        installation, you can try:

#

#        Option 1:

#

#        unatime.database.url=jdbc:jtds:sqlserver://<server>[:<port>][/<database>];instance=<instance_name>;sendStringParametersAsUnicode=false

#

#        Option 2: If option 1 doesn't work, try dropping the instance name, and changing the port to

#                  the port used by the named instance.  Note that the port is different from the normal

#                  SQL Server port as each instance listens on a different port:

#

#        unatime.database.url=jdbc:jtds:sqlserver://<server>[:<instance_port>][/<database>];sendStringParametersAsUnicode=false

#

# =============================================================================

#  ORACLE JDBC-THIN Driver (Included with Unanet)

# =============================================================================

#

#     host = "myname.thedomain.com"

#     port = "1521"

#     sid  = "orcl"

#

#     Option 1: Oracle 11g or 12c without CDB/PDB model:

#       Syntax: unatime.database.url=jdbc:oracle:thin:@<<host>>:<<port>>:<<sid>>

#      Example: unatime.database.url=jdbc:oracle:thin:@myname.thedomain.com:1521:orcl

#

#     Option 2: Oracle 12c using CDB/PDB model (Unanet in PDB):

#       Syntax: unatime.database.url=jdbc:oracle:thin:@<<host name>>:<<port>>/<<pdb service name>>

#      Example: unatime.database.url=jdbc:oracle:thin:@myname.thedomain.com:1521/pdborcl.thedomain.com

#

# Change unatime.database.url below and add in your <<host name>> where

# oracle resides.  Also change <<port>> and/or <<sid>> if different from

# these defaults.

#

#unatime.database.driver=oracle.jdbc.driver.OracleDriver

#unatime.database.url=jdbc:oracle:thin:@<<host name>>:1521:orcl

#unatime.database.username=unanet

#unatime.database.password=unanet

#

# =============================================================================

# The following lines apply regardless of the JDBC Driver you are using

# =============================================================================

unatime.database.maxconnections=16

unatime.database.idletimeout=600000

unatime.database.activetimeout=28800000

 

Related Topics