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