If a database model does not produce the expected results right away, it can be tricky to figure out what is going wrong. The cause can lie with the application, with the specified properties, with the database, etc. Luckily, there are a number of ways to debug what is going on, at different levels in the application.

LuciadLightspeed

Like any other model decoder, LuciadLightspeed will produce an IOException if it fails to open a spatial database model. The message of the IOException should provide more details on the origin of the problem. Typically, some properties are not set correctly, or the spatial database is not set up properly.

In addition, you can get feedback on the SQL queries that are sent to the database, by switching on logging for the relevant package. See the Logging documentation for more information on setting up logging in a LuciadLightspeed application.

The initial queries that you will see in the logging output generally request some metadata about the spatial tables. Subsequent queries will typically request the actual data, based on spatial bounds and on primary keys. If one of the queries fails, you can try to copy/paste it in an interactive SQL console, to see which part is causing problems. This can be especially useful if you have specified additional selection tables and filters, which are weaved into the SQL query.

JDBC

At a lower level, you can get feedback about any JDBC operations, directly from JDBC. The JDBC API provides a standard hook, which you can set up from your program by calling:

DriverManager.setLogWriter(new PrintWriter(System.out));