Working with databases

The database support allows you to read from and write to databases using a map.

You can import or read any number of database tables in a single map by creating an enclosing structure that inherits from the desired database table structures. Database lookup functions are provided to find and update values in database tables.

In order to import database tables and use the Test Run feature on a map using the DatabaseLookup function, you need provide the relevant database drivers in the classpath. You can add them in the advanced properties of the database connection wizard. You also need to include this Jar file in your runtime classpath.

JDBC4 drivers are also required at runtime when using the new non-Eclipse runtime.