Database driver locations

System-wide database driver location settings

Setting locations available to all users

When you first use a database connection, depending on the type of database, Omniscope may prompt you to download and locate the database JDBC driver. Omniscope tracks this location, so you don't need to enter it again.

However, if there are more than one user account running Omniscope on the same machine, then when running as a different user account, these settings won't be available and you or other users on the same machine will be prompted again on first use. This may be inconvenient if configuring a system for multiple user accounts, and can prevent a 'headless' Scheduler Server running as a Windows Service from working.

Configuring JDBC driver locations for all users (2.8 b1056+)

In the desktop application

Use this approach if you have multiple users launching Omniscope Desktop on the same system, and/or wish to push out a configuration centrally to many PCs.

  1. Open configuration file: [path to Omniscope installation]\  You may need to run your text editor as Administrator.

  2. Add/uncomment the ADDITIONAL_JVM_ARGS line so it looks like this:
    ADDITIONAL_JVM_ARGS=-DpropName="propValue-Dprop2Name="prop2Value" -Dprop3Name="prop3Value"
    (etc. - see properties, below)

    For example:


In the Windows Service 

Use this approach if you're using the Windows Service to run the Omniscope Scheduler/Mobile Web Server without a logon session.

  1. Open configuration file: [path to Omniscope installation]\service\wrapper.conf.  You may need to run your text editor as Administrator.
  2. Find the "" section, and add additional lines like this:"propValue""prop2Value""prop3Value"
    (etc. - see properties, below)

    For example:"C:\Oracle\product\11.2.0\Db_1\jdbc\lib\ojdbc5.jar"


Database propName Typical propValue 
Ingres/Vectorwise IngresSqlDriverSearch_driverDir C:\Program Files\Ingres JDBC Driver\iijdbc.jar 
MySql MySqlDriverSearch_driverDir C:\Program Files\MySQL JDBC driver 
OracleOracleThinDriverSearch_jarFile C:\Oracle\product\11.2.0\Db_1\jdbc\lib\ojdbc5.jar 
Postgres  PostgreSqlDriverSearch_driverDir C:\Program Files\PostgreSQL JDBC Driver\postgresql-8.4-701.jdbc4.jar 
MS SQL Server SqlServer2008DriverSearch_jarFile C:\Program Files (x86)\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc4.jar