Using this dialog you can configure user-defined datasources for drivers unknown to i-net Clear Reports. To receive more information about the configuration of your driver, please refer to your driver's documentation. If you provide us with the necessary information, we can also add your driver to the list of known drivers for i-net Clear Reports.
There are special dialogs for the tested drivers. If one of these drivers is in the classpath, it is shown in the list of drivers in the Data Source Manager.
The following parameters can be set:
Data Source Name | The name of the configuration |
JDBC Driver | The fully qualified class name of the JDBC driver, e.g. com.myvendor.jdbc.XyzDriver. If no class is specified, the Database class must return false for the method useJdbcDriver(). |
DataFactory Class | (Optional) The name of the class extending from com.inet.report.Database. If no class is specified, com.inet.report.Database itself is used. |
Library | (Optional) Provides the path to necessary *.jar files. It is better to include this *.jar file in the class path. |
JDBC Driver URL | Must be provided, if a JDBC driver is to be used. (e.g. jdbc:xyz://host) |
User / Password | If your JDBC driver requires a login, this must specify a valid account for the database. |
Catalog | (Optional) Some DBMS support "catalogs" (e.g. MS SQL Server, DB2). This term can have different names, for example "database" or "schema". You can provide the "catalog" here. |
escapeEverything, identifierQuoteString, quotesLowerCase, supportsOrderBy, supportsParenthesesForJoin, supportsSQL92, supportsWhere | These properties configure the compatibility of the supported SQL. For most databases, the default settings will be correct. |
Add New Property | Here (at the bottom of the property list) the so-called Vendor Properties of the JDBC Driver can be added. These often control the driver's performance. |