https://docs.echsacongenitaldb.org/index.php?action=history&feed=atom&title=Network_installation%2FOlder_instructions
Network installation/Older instructions - Revision history
2026-04-19T06:33:44Z
Revision history for this page on the wiki
MediaWiki 1.32.0
https://docs.echsacongenitaldb.org/index.php?title=Network_installation/Older_instructions&diff=1686&oldid=prev
MaciejBlizinski at 16:53, 24 September 2005
2005-09-24T16:53:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 16:53, 24 September 2005</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3" >Line 3:</td>
<td colspan="2" class="diff-lineno">Line 3:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Network instalation of Data Collection Software requires four steps to perform.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Network instalation of Data Collection Software requires four steps to perform.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> 1. </del>Download and run the latest version of the DataCollectionSoftware. When a dialog appears type in your hospital code and choose the default database path.</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>Download and run the latest version of the DataCollectionSoftware. When a dialog appears type in your hospital code and choose the default database path.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> 2. </del>Download and apply the SQL scripts to create necessary database objects and fill the dictionary tables.</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>Download and apply the SQL scripts to create necessary database objects and fill the dictionary tables.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> 3. </del>Download and install the JDBC driver:</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>Download and install the JDBC driver:</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">*</del>* system-wide instalation -- copy the driver <<del class="diffchange diffchange-inline">pre</del>>jar</<del class="diffchange diffchange-inline">pre</del>> file into the <<del class="diffchange diffchange-inline">pre</del>>lib/ext</<del class="diffchange diffchange-inline">pre</del>> subdirectory of your Java JRE directory</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>*system-wide instalation -- copy the driver <<ins class="diffchange diffchange-inline">tt</ins>>jar</<ins class="diffchange diffchange-inline">tt</ins>> file into the <<ins class="diffchange diffchange-inline">tt</ins>>lib/ext</<ins class="diffchange diffchange-inline">tt</ins>> subdirectory of your Java JRE directory</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">*</del>* 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></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>*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></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>java -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>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.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div></pre><br> or under MS Windows: <pre></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>javaw -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc</div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> 4. </del>Go to the software preferences directory '''<pre></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>.EactsCongenitalDatabase</div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div></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.</div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Steps 2-4 are database system specific. Look below for details.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Steps 2-4 are database system specific. Look below for details.</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l22" >Line 22:</td>
<td colspan="2" class="diff-lineno">Line 16:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== PostgreSQL ==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== PostgreSQL ==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> 1. </del>SQL scripts:</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>SQL scripts:</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">*</del>* attachment:pgsql_struct.sql</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>*attachment:pgsql_struct.sql</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">*</del>* attachment:pgsql_dict.sql</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>*attachment:pgsql_dict.sql</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> 2. </del>[http://jdbc.postgresql.org/download/postgresql-8.0-310.jdbc3.jar JDBC driver]</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins>[http://jdbc.postgresql.org/download/postgresql-8.0-310.jdbc3.jar JDBC driver]</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> 3. </del><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></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#</ins><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)</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>dbdriver=org.postgresql.Driver</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>dbdriver=org.postgresql.Driver</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>dburl=jdbc:postgresql://host_name/database_name?user=user_name&password=users_password</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>dburl=jdbc:postgresql://host_name/database_name?user=user_name&password=users_password</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
</table>
MaciejBlizinski
https://docs.echsacongenitaldb.org/index.php?title=Network_installation/Older_instructions&diff=1530&oldid=prev
MaciejBlizinski at 08:39, 24 September 2005
2005-09-24T08:39:05Z
<p></p>
<p><b>New page</b></p><div>= General installation information =<br />
<br />
Network instalation of Data Collection Software requires four steps to perform.<br />
<br />
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.<br />
2. Download and apply the SQL scripts to create necessary database objects and fill the dictionary tables.<br />
3. Download and install the JDBC driver:<br />
** system-wide instalation -- copy the driver <pre>jar</pre> file into the <pre>lib/ext</pre> subdirectory of your Java JRE directory<br />
** 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><br />
java -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc<br />
</pre><br> or under MS Windows: <pre><br />
javaw -cp driver_file_name.jar;DataCollectionSoftware-7.x.jar pl.magnum2.ecdbc.Ecdbc<br />
</pre><br />
4. Go to the software preferences directory '''<pre><br />
.EactsCongenitalDatabase<br />
</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.<br />
<br />
Steps 2-4 are database system specific. Look below for details.<br />
<br />
= Information specific to particular database system =<br />
<br />
== PostgreSQL ==<br />
<br />
1. SQL scripts:<br />
** attachment:pgsql_struct.sql<br />
** attachment:pgsql_dict.sql<br />
2. [http://jdbc.postgresql.org/download/postgresql-8.0-310.jdbc3.jar JDBC driver]<br />
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><br />
dbdriver=org.postgresql.Driver<br />
dburl=jdbc:postgresql://host_name/database_name?user=user_name&password=users_password<br />
</pre></div>
MaciejBlizinski