The ROES Server uses a database to store information about your orders.

Database Types - The ROESServer can connect to many database types; HSQL, MySQL, MSSQL to name a few.

• HSQL - File Mode - This mode only allows a single ROES Server. This is the mode the ROES Server will default to if it can't connect to your specified database.
  Sample connection string: jdbc:hsqldb:file:/Users/mstruble/.ROESServer/ProductionInfo

• HSQL - Server Mode - Allows multiple ROES Servers. Small to medium database size. This db type will support most labs. The checkbox determines which workstation will be serving the db up.
  Sample connection string: jdbc:hsqldb:hsql://192.168.0.195/ProductionInfo.

• MySQL - Allows multiple ROES Servers. medium to large database size. This db type will support all labs.
  Sample connection string: jdbc:mysql://192.168.0.195:3306/ProductionInfo

• MSSQL - Allows multiple ROES Servers. medium to large database size. This db type will support all labs.
  Sample connection string: jdbc:jtds:sqlserver://192.168.0.195:1433/ProductionInfo

Documentation version 4.1,2015/03.