Difference between revisions of "JavOO"

From Wikili
Jump to: navigation, search
(→‎Installation)
 
(9 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
JavOO is a small multithread secure server written in [[Java]] and working on Windows platform.
 
JavOO is a small multithread secure server written in [[Java]] and working on Windows platform.
  
−
It allows you to share MSAccess and MSExcel resources, which will be accessed through the native
+
It allows you to share Microsoft Access and Excel resources, which will be accessed by a distant client program through the native
−
ODBC driver of Windows.
+
ODBC driver of Windows. The client will be able to do SQL select queries on these resources.
  
 
   For example:
 
   For example:
 
   a laboratory in Madrid has an PC running on Windows and wants to make accessible its Access database to a collaborator in Strasbourg.  
 
   a laboratory in Madrid has an PC running on Windows and wants to make accessible its Access database to a collaborator in Strasbourg.  
−
   For that, install JavOO on the PC in Madrid, configure the path and access rights to the Access file and open the port 18000 (or 18001 for secure connection).
+
   For that, install JavOO on the PC in Madrid, configure the path and access rights to the Access file  
−
   The computer in Strasbourg can now do SQL queries on the remote Access database in Madrid.
+
  and open the port 18000 (and/or 18001 for SSL secure connection).
 +
   The computer in Strasbourg can now do SQL select queries on the remote Access database in Madrid.
  
 
==Download==
 
==Download==
Line 18: Line 19:
 
To get Windows installer of JavOO, please send an email to [mailto:Guillaume.Berthommier@igbmc.u-strasbg.fr Guillaume.Berthommier@igbmc.u-strasbg.fr ]
 
To get Windows installer of JavOO, please send an email to [mailto:Guillaume.Berthommier@igbmc.u-strasbg.fr Guillaume.Berthommier@igbmc.u-strasbg.fr ]
  
−
==Installation==
+
==Installation and Configuration==
 
Double-click on the file ''JavOOsetup.exe'' and follow the instructions.
 
Double-click on the file ''JavOOsetup.exe'' and follow the instructions.
  
 
By default the program will be installed in the directory ''C:\Program Files\JavOO\'' .
 
By default the program will be installed in the directory ''C:\Program Files\JavOO\'' .
  
 +
===Interface Description===
 +
 +
This is what you get when you launch JavOO:
 +
 +
<center>[[Image:JavOO.png]]</center>
 +
 +
; STOP button (<span style="color:#F00;">1</span>) : Stop the server, disconnecting all clients.
 +
; START button (<span style="color:#F00;">2</span>) : Start the server, the server is ready to accept connections from clients.
 +
; Server Log Area (<span style="color:#F00;">3</span>) : Some actions executed by the server are logged in this text area.
 +
; Clear button (<span style="color:#F00;">4</span>) : This button clears the Server Log Area (<span style="color:#F00;font-weight:bold;">3</span>).
 +
; Save button (<span style="color:#F00;">5</span>) : This button is not used at the moment. In further development you will be able to save the content of the Server Log Area (<span style="color:#F00;font-weight:bold;">3</span>).
 +
; Config button (<span style="color:#F00;">6</span>) : This button display the configuration window. It will be described below.
 +
; Test Client button (<span style="color:#F00;">7</span>) : This button is used to test the server, the result output of the test will be shown in the Server Log Area (<span style="color:#F00;font-weight:bold;">3</span>).
 +
 +
 +
<!--
 
Here is the content of the installation directory:
 
Here is the content of the installation directory:
 
*JavOO
 
*JavOO
Line 43: Line 60:
 
**unins000.dat
 
**unins000.dat
 
**unins000.exe
 
**unins000.exe
 +
-->
 +
The first thing you have to do is declaring one or more resources (Excel and/or Access files), which is describe in the Configuration Section.
  
−
==Configuration==
+
===Configuration Section===
 
Now that you've installed JavOO, you need to add your Excel and/or Access resources.
 
Now that you've installed JavOO, you need to add your Excel and/or Access resources.
 +
For that, click on the <b>Config button (<span style="color:#F00;">6</span>)</b>, you get the <b>JavOO Server Configuration</b> window.
 +
 +
<center>[[Image:JavOOServerConfig.png]]</center>
 +
 +
; Resource list (<span style="color:#F00;">1</span>) : All defined resources are declared here. There are already three declared resources in JavOO that are here for testing purpose : see <b>Test Client button (<span style="color:#F00;">7</span>)</b> in the Interface Description section.
 +
; Add New Excel (<span style="color:#F00;">2</span>) : Add a new empty Excel resource. Don't forget to enter a proper name for the resource (see further).
 +
; Add New Access (<span style="color:#F00;">3</span>) : Add a new empty Access resource. Don't forget to enter a proper name for the resource (see further).
 +
; Edit (<span style="color:#F00;">4</span>) : Allows you to edit an existing resource declared in the <b>Resource list (<span style="color:#F00;">1</span>)</b>. For that, select a resource in the list then press the button.
 +
; Clone (<span style="color:#F00;">5</span>) : Allows you to clone an existing resource declared in the <b>Resource list (<span style="color:#F00;">1</span>)</b>. For that, select a resource in the list then press the button.
 +
; Remove (<span style="color:#F00;">6</span>) : Allows you to remove an existing resource declared in the <b>Resource list (<span style="color:#F00;">1</span>)</b>. For that, select a resource in the list then press the button.
  
 +
 +
 +
<!--
 
In the install directory you'll find a file named '''''javooconfig.xml'''''.  
 
In the install directory you'll find a file named '''''javooconfig.xml'''''.  
 
This file is in [[XML]] format. It defines a root element '''''serverconfig''''' in which an element '''''resources''''' is defined.
 
This file is in [[XML]] format. It defines a root element '''''serverconfig''''' in which an element '''''resources''''' is defined.
Line 63: Line 95:
 
                     password="userpassword"  
 
                     password="userpassword"  
 
                     readonly="true" />
 
                     readonly="true" />
 +
 +
-->
 +
 +
====Excel File====
  
 
*Usually people do not define username and password for Excel files, so if your file doesn't have this kind of protection you can leave them blank.
 
*Usually people do not define username and password for Excel files, so if your file doesn't have this kind of protection you can leave them blank.
 
*The declaration of an Excel resource is a bit specific, let's see:
 
*The declaration of an Excel resource is a bit specific, let's see:
 
**An Excel file has one or many sheets, each one has a specific name, depending on the localisation of your computer, ie "Feuil1" in french, "Sheet1" in english, "Tabelle1" in german, etc. These names can be edited. Because many sheets can be accessible, you will have to define the proper name in the '''''sheet''''' attribute of the Excel resource.
 
**An Excel file has one or many sheets, each one has a specific name, depending on the localisation of your computer, ie "Feuil1" in french, "Sheet1" in english, "Tabelle1" in german, etc. These names can be edited. Because many sheets can be accessible, you will have to define the proper name in the '''''sheet''''' attribute of the Excel resource.
−
**Now the tricky part: the '''''selection''''' is a specific zone of you sheet, containing the header line of the table and it's content. Here is an example of a selection:
+
**Now the tricky part: the '''''selection''''' is a specific region of you sheet, containing the header line of the table and it's content. Here is an example of a selection:
  
  
Line 87: Line 123:
 
The nice part here is that you can define one or many selections in the same sheet, but you will have to declare as many Excel resources as the number of selections you want to be accessible.
 
The nice part here is that you can define one or many selections in the same sheet, but you will have to declare as many Excel resources as the number of selections you want to be accessible.
  
−
====How to create a selection in Excel====
+
=====How to create a selection in Excel=====
−
#First select a zone of your sheet containing the '''''header''''' and the '''''data''''' of your table.
+
#First select a region of your sheet containing the '''''header''''' and the '''''data''''' of your table.
 
#Then, in the menu, choose '''Insert''' -> '''Name''' -> '''Define'''.
 
#Then, in the menu, choose '''Insert''' -> '''Name''' -> '''Define'''.
 
#A new window should appear, enter the name you want for the selection, press '''OK''' then '''Close'''.
 
#A new window should appear, enter the name you want for the selection, press '''OK''' then '''Close'''.
 
#Do not forget to save the file.
 
#Do not forget to save the file.
  
−
 
+
====Access file====
−
===Access file===
+
<!--
 
   <access_resource name="testAccess"  
 
   <access_resource name="testAccess"  
 
                     filepath="C:/path/to/the/file.mdb"  
 
                     filepath="C:/path/to/the/file.mdb"  
Line 100: Line 136:
 
                     password="userpassword"  
 
                     password="userpassword"  
 
                     readonly="true" />
 
                     readonly="true" />
−
 
+
-->
−
 
 
−
==Usage==
 
−
Here is a screenshot of the JavOO application: [[Image:JavOO.png]]
 
−
#'''STOP button''': Stop the server, disconnecting all clients.
 
−
#'''START button''': Start the server, the server is ready to accept connections from clients.
 
−
#'''Server Log Area''': Some actions executed by the server are logged in this text area.
 
−
#'''Clear button''': This button clears the Server Log Area ('''3''').
 
−
#'''Save button''': This button will be used for further development.
 
−
#'''Config button''': This button will be used for further development.
 
−
#'''Test Client button''': This button is used to test the server, the result output of the test will be shown in the Server Log Area ('''3''').
 
−
 
 
  
 
==Troubleshooting==
 
==Troubleshooting==
 
If you any problem, please send me an email at [mailto:Guillaume.Berthommier@igbmc.u-strasbg.fr?subject=On%20JavaOO <Guillaume.Berthommier@igbmc.u-strasbg.fr> ] .
 
If you any problem, please send me an email at [mailto:Guillaume.Berthommier@igbmc.u-strasbg.fr?subject=On%20JavaOO <Guillaume.Berthommier@igbmc.u-strasbg.fr> ] .

Latest revision as of 14:49, 31 May 2007

JavOO : Java Odbc for Office.

Introduction

JavOO is a small multithread secure server written in Java and working on Windows platform.

It allows you to share Microsoft Access and Excel resources, which will be accessed by a distant client program through the native ODBC driver of Windows. The client will be able to do SQL select queries on these resources. 

 For example:
 a laboratory in Madrid has an PC running on Windows and wants to make accessible its Access database to a collaborator in Strasbourg. 
 For that, install JavOO on the PC in Madrid, configure the path and access rights to the Access file 
 and open the port 18000 (and/or 18001 for SSL secure connection).
 The computer in Strasbourg can now do SQL select queries on the remote Access database in Madrid.

Download

The actual version is beta 1.0 .

To get Windows installer of JavOO, please send an email to Guillaume.Berthommier@igbmc.u-strasbg.fr

Installation and Configuration

Double-click on the file JavOOsetup.exe and follow the instructions.

By default the program will be installed in the directory C:\Program Files\JavOO\ .

Interface Description

This is what you get when you launch JavOO:

Error creating thumbnail: Unable to save thumbnail to destination
STOP button (1) 
Stop the server, disconnecting all clients.
START button (2) 
Start the server, the server is ready to accept connections from clients.
Server Log Area (3) 
Some actions executed by the server are logged in this text area.
Clear button (4) 
This button clears the Server Log Area (3).
Save button (5) 
This button is not used at the moment. In further development you will be able to save the content of the Server Log Area (3).
Config button (6) 
This button display the configuration window. It will be described below.
Test Client button (7) 
This button is used to test the server, the result output of the test will be shown in the Server Log Area (3).


The first thing you have to do is declaring one or more resources (Excel and/or Access files), which is describe in the Configuration Section.

Configuration Section

Now that you've installed JavOO, you need to add your Excel and/or Access resources. For that, click on the Config button (6), you get the JavOO Server Configuration window.

Error creating thumbnail: Unable to save thumbnail to destination
Resource list (1) 
All defined resources are declared here. There are already three declared resources in JavOO that are here for testing purpose : see Test Client button (7) in the Interface Description section.
Add New Excel (2) 
Add a new empty Excel resource. Don't forget to enter a proper name for the resource (see further).
Add New Access (3) 
Add a new empty Access resource. Don't forget to enter a proper name for the resource (see further).
Edit (4) 
Allows you to edit an existing resource declared in the Resource list (1). For that, select a resource in the list then press the button.
Clone (5) 
Allows you to clone an existing resource declared in the Resource list (1). For that, select a resource in the list then press the button.
Remove (6) 
Allows you to remove an existing resource declared in the Resource list (1). For that, select a resource in the list then press the button.



Excel File

  • Usually people do not define username and password for Excel files, so if your file doesn't have this kind of protection you can leave them blank.
  • The declaration of an Excel resource is a bit specific, let's see:
    • An Excel file has one or many sheets, each one has a specific name, depending on the localisation of your computer, ie "Feuil1" in french, "Sheet1" in english, "Tabelle1" in german, etc. These names can be edited. Because many sheets can be accessible, you will have to define the proper name in the sheet attribute of the Excel resource.
    • Now the tricky part: the selection is a specific region of you sheet, containing the header line of the table and it's content. Here is an example of a selection:


Name Age Gender
Bob 30 Male
Jane 28 Female
Cindy 45 Female


The nice part here is that you can define one or many selections in the same sheet, but you will have to declare as many Excel resources as the number of selections you want to be accessible.

How to create a selection in Excel
  1. First select a region of your sheet containing the header and the data of your table.
  2. Then, in the menu, choose Insert -> Name -> Define.
  3. A new window should appear, enter the name you want for the selection, press OK then Close.
  4. Do not forget to save the file.

Access file

Troubleshooting

If you any problem, please send me an email at <Guillaume.Berthommier@igbmc.u-strasbg.fr> .

Retrieved from "https://lbgi.fr/wikili/index.php?title=JavOO&oldid=1692"