Enter Name
e.g. 'Gauss, Johann'

Search within
records.
Current matches:
Requests sent:
Items received:
Items cached:
Name
Born:
Place of birth
Died:
Place of death:
Description:
Requests sent:
Status:

Autocompletion of name data from an Oracle database.

- The demo is connected to the Oracle database via Crossbar.io.
- All client logic is local to the browser, all business logic is in the database. Crossbar.io manages only the messaging interaction between the two.
- Each change of the search string in the autocomplete box results in a call to the Oracle database.
- Requests for full person details are separate.
- Since this demo uses person data from DBPedia, it requires setting up the demo data
  1. Download the pre-peared person data as a CSV file, as well as the SQL instructions file to generate the index.
  2. Import the data into your Oracle database:

               sqlldr crossbardemo/crossbardemo@192.168.1.100:1521/orcl
                              control=persondata.ctl data=persondata_en.csv

     (single line, change to the IP of your Oracle (or Crossbar.io with Oracle XE) instance, adjust file paths if necessary)
  3. Generate the index:

               sqlplus crossbardemo/crossbardemo@192.168.1.118:1521/orcl @person_index.sql

     (adjust the IP and file path if necessary)

The necessary connection to an Oracle database with an installed demo schema could not be established.

Please make sure that the following requirements are met:

- an Oracle connect has been created
- there is a remote for this connect
- the Oracle database is reachable
- the repository schema and the demo schema have been installed

Whether the Oracle database is reachable and the necessary schemas have been installed can easily be checked by using the 'Test' buttons next to the respective schema login data on the Oracle Connects tab.

To check whether any changes you've made have solved the encountered problem(s) just reload the page.

Insert link to hostd demo on the Crossbar website once this is up.