database.properties file

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

#

# 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