Network installation/Older instructions

General installation information

Network instalation of Data Collection Software requires four steps to perform.

1. Download and run the latest version of the DataCollectionSoftware. When a dialog appears type in your hospital code and choose the default database path.
2. Download and apply the SQL scripts to create necessary database objects and fill the dictionary tables.
3. Download and install the JDBC driver:

• • system-wide instalation -- copy the driver

    jar

    file into the

    lib/ext

    subdirectory of your Java JRE directory
  • local instalation -- copy the driver

    jar

    file and DataCollectionSoftware-7.x.jar into some directory and prepare shortcut or shell script with command:
    

java -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc

or under MS Windows:

javaw -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc

4. Go to the software preferences directory

.EactsCongenitalDatabase

located in the user home directory (please note the dot character at the beginning of the directory name). Edit the

ecdbc.properties

file and set two variables:

dbdriver

and

dburl

. The user name and the password are to be set inside the

dburl

variable.

Steps 2-4 are database system specific. Look below for details.

Information specific to particular database system

PostgreSQL

1. SQL scripts:

• • attachment:pgsql_struct.sql
  • attachment:pgsql_dict.sql

2. JDBC driver

3.

dbdriver

and

dburl

values (replace

user_name

and

users_password

with values corresponding to your database server configuration)

dbdriver=org.postgresql.Driver
dburl=jdbc:postgresql://host_name/database_name?user=user_name&password=users_password