Difference between revisions of "Network installation/Older instructions"

From ECHSA Congenital Database
Jump to navigationJump to search
 
 
Line 3: Line 3:
 
Network instalation of Data Collection Software requires four steps to perform.
 
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.
+
#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.
+
#Download and apply the SQL scripts to create necessary database objects and fill the dictionary tables.
−
3. Download and install the JDBC driver:
+
#Download and install the JDBC driver:
−
** system-wide instalation -- copy the driver <pre>jar</pre> file into the <pre>lib/ext</pre> subdirectory of your Java JRE directory
+
#*system-wide instalation -- copy the driver <tt>jar</tt> file into the <tt>lib/ext</tt> subdirectory of your Java JRE directory
−
** local instalation -- copy the driver <pre>jar</pre> file and DataCollectionSoftware-7.x.jar into some directory and prepare shortcut or shell script with command:<br> <pre>
+
#*local instalation -- copy the driver <pre>jar</pre> file and DataCollectionSoftware-7.x.jar into some directory and prepare shortcut or shell script with command:<br> <pre>java -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc</pre><br> or under MS Windows: <pre>javaw -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc</pre>
−
java -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc
+
#Go to the software preferences directory '''<pre>.EactsCongenitalDatabase</pre>''' located in the user home directory (please note the '''dot''' character at the beginning of the directory name). Edit the '''<pre>ecdbc.properties</pre>''' file and set two variables: <pre>dbdriver</pre> and <pre>dburl</pre>. The user name and the '''password''' are to be set inside the <pre>dburl</pre> variable.
−
</pre><br> or under MS Windows: <pre>
 
−
javaw -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc
 
−
</pre>
 
−
4. Go to the software preferences directory '''<pre>
 
−
.EactsCongenitalDatabase
 
−
</pre>''' located in the user home directory (please note the '''dot''' character at the beginning of the directory name). Edit the '''<pre>ecdbc.properties</pre>''' file and set two variables: <pre>dbdriver</pre> and <pre>dburl</pre>. The user name and the '''password''' are to be set inside the <pre>dburl</pre> variable.
 
  
 
Steps 2-4 are database system specific. Look below for details.
 
Steps 2-4 are database system specific. Look below for details.
Line 22: Line 16:
 
== PostgreSQL ==
 
== PostgreSQL ==
  
−
1. SQL scripts:
+
#SQL scripts:
−
** attachment:pgsql_struct.sql
+
#*attachment:pgsql_struct.sql
−
** attachment:pgsql_dict.sql
+
#*attachment:pgsql_dict.sql
−
2. [http://jdbc.postgresql.org/download/postgresql-8.0-310.jdbc3.jar JDBC driver]
+
#[http://jdbc.postgresql.org/download/postgresql-8.0-310.jdbc3.jar JDBC driver]
−
3. <pre>dbdriver</pre> and <pre>dburl</pre> values (replace <pre>user_name</pre> and <pre>users_password</pre> with values corresponding to your database server configuration) <pre>
+
#<pre>dbdriver</pre> and <pre>dburl</pre> values (replace <pre>user_name</pre> and <pre>users_password</pre> with values corresponding to your database server configuration)
 +
<pre>
 
dbdriver=org.postgresql.Driver
 
dbdriver=org.postgresql.Driver
 
dburl=jdbc:postgresql://host_name/database_name?user=user_name&password=users_password
 
dburl=jdbc:postgresql://host_name/database_name?user=user_name&password=users_password
 
</pre>
 
</pre>

Latest revision as of 18:53, 24 September 2005

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
Retrieved from "https://docs.echsacongenitaldb.org/index.php?title=Network_installation/Older_instructions&oldid=1686"