java - How to set a MS Access DB (.mdb) in JasperSoft Studio (Eclipse)? -
i have .mdb database , i'm trying design report using jaspersoft studio 6.3.0 (eclipse plug-in).
in java application have used ucanaccess jdbc driver build connection jdbc-odbc bridge no longer supported in java 8.
when creating data adapter, chose "database jdbc connection", , then, ucanaccess not in default list of drivers, added .jar file ucanaccess driver.
screenshot classpath:
then, wrote driver class in jdbc driver (note: standard action choose 1 of drivers in combobox, had add manually, read somewhere in internet must write myself).
screenshot driver setting:
when test connection, stay loading forever , never end.
note: database has no user/pass. connected database java application (using ucanaccess driver); problem connection report.
what can do? suggestions? thanks!
i managed solve question myself. had add 4 .jar in ucanaccess-x.x.x-bin>>lib classpath (commons-lang, commons-logging, hsqldb, jackcess)
Comments
Post a Comment