This forum is now out of date, for our new forum Click Here
Yellowfin and Java 1.8
Frequently Asked Question
The JDBC-ODBC Bridge has been removed from Java with the release of version 1.8.

This means that if you upgrade Java to 1.8 and then try make ODBC connections from Yellowfin to your ODBC databases you will receive an error message about not being able to locate sun.jdbc.odbc.jbcOdbc driver

Yellowfin will eventually be distributed with its own JDBC-ODBC Bridge, however, until then we recommend you don't upgrade to Java 1.8 if you use ODBC connections.


NEWS FLASH!!!!!

it is possible to move the Java 7 JDBC ODBC bridge into Java 8 in just 2 easy steps. For more information on this, please see the following Knowledge Base article on our new Yellowfin Community site (if you don't have a login, just email us at support@yellowfin.bi and we'll set one up for you):

http://community.yellowfin.bi/knowledge-base/article/moving-the-jdbc-odbc-bridge-from-java-7-to-java-8


David

Mon Jul 25, 2016 12:42 PM

Comment
Happy Halloween to all our readers,

I am wanting to sharing with you some of the very very good news for Java 1.8 users who are wanting to be making the ODBC connection to MS ACCESS, I was searching and then I was being lucky in finding a JDBC driver that is being open source (free!).

It is called UCanAccess. I was testing it with Yellowfin and it was performing very well if I may say so.

There is being one minor point of which I would like to make you aware:

It is coming with 5 jars:

ucanaccess-2.0.9.1.jar
commons-lang-2.6.jar
jackcess-2.0.5-f110.jar
commons-logging-1.1.1.jar
hsqldb.jar

the first 3 of these must be placed in
<yellowfin home>/appserver/webapps/ROOT/WEB-INF/lib


and please be careful, Yellowfin is already shipping with commons-lang3-3.1.jar but UCanAccess will NOT work with that jar, so please remove it replace it with
commons-lang-2.6.jar.

(Actually Yellowfin is already also coming with commons-logging-1.0.4.jar
& hsqldb.jar, but do not replace them with the UCanAccess versions because UCanAccess works well with them.
)

IMPORTANT NOTE:
The 'commons-lang-2.6.jar' file cannot be used in Yellowfin if you still wish to export to PDF.
So at this point in time, if you use UCanAccess libraries, you will not be able to export Yellowfin objects to PDF'


regards,
Dave

guest

Thu Apr 30, 2015 11:03 AM

Comment
Another News Flash!!!!!

In Yellowfin 7.2 you do not need to worry about clashing jar files because of the cool new feature call Plugin Management. You simply upload all of the required jar files via this new feature, and don't touch any of the current jar files in the path <yellowfin home>/appserver/webapps/ROOT/WEB-INF/lib, and hey presto!....you'll be able to use the UCanAccess driver.





And of course, because you don't have to remove the commons-lang3-3.1.jar, then this means you will still be able to export to PDF!

regards,
Dave

David

Mon Jul 25, 2016 1:58 PM