Differences between Jaspersoft JDBC drivers and original db jdbc drivers

[hozawa]

In JasperReports Server 5.6.1., there are now several jdbc drivers provided by Jaspersoft. I was wondering what the differences are between them and those provided by database providers. I've tested several open source jdbc drivers and found those from the original database providers offer more stability than those and have reverted back. Nevertheless, if there are additional features that are offered by Jaspersoft JDBC drivers, I sure would like to know about them.

 

BTW, are those jdbc drivers included in Jaspersoft Studio? If not, it should be because it may cause Studio to behave differently from JasperReports Server.

[djohnson53]

The drivers provided in JasperReports Server v5.6.1 originate from the various vendors and have not been modified in any way by Jaspersoft. The only differences that could possibly be encountered are version differences.

[hozawa]

Great! I was just a little bit worried but your answer answered me that using it won't cause problems.

[elizam]

TIBCO uses a version of the DataDirect Progress Drivers.  There are some difference from the vendor drivers.

The full documentation set is here: http://media.datadirect.com/download/docs/jdbc/alljdbc/help.html

In some cases, these drivers provide additional functionality. For example, you can specify a SysLoginRole, and set it to be SYSDBA or SYSOPER.  This allows you to run the database with less privileges.  See this link for a list of available connection properties:

http://media.datadirect.com/download/docs/jdbc/alljdbc/help.html#page/userguide/rfi1359986110785.html

However, these drivers do not always support the same SQL syntax (used in Domains and elsewhere). For example, the following query does not work with the TIBCO JDBC drivers: 

SELECT account_id+account_description AS account_concat from account

The correct syntax for the TIBCO JDBC drivers is as follows:

SELECT {fn CONCAT(account_id,account_description)} AS account_concat from account

See the PROGRESS DataDirect  page on scalar functions for more information:
http://media.datadirect.com/download/docs/jdbc/alljdbc/help.html#page/reference/rfi1359985772456.html

The install guide provides the information you need to use the vendor's driver instead of the TIBCO driver. If you are updating from an earlier version of JasperReports Server, it is probably easier to copy over your existing driver & use your existing default_master.properties. This should install correctly.

The same drivers are available in JSS. You can select them from thedata connection menu after you have selected JDBC connection.

NOTE: The TIBCO JDBC drivers and the vendor drivers can co-exist.

[elizam]

This is not correct. In 5.6.1, we added third-party drivers. However, you are free to revert to the standard vendor driver.

[djohnson53]

Thanks for the correction, Eliza

[hozawa]

Thanks! I think I'll stick with the vendors' drivers for now because we've already developed too many reports using them, and I don't want to increase number of support calls because of sql syntax differences.