iReport 5.6 : Not able to add Derby database connection

Posted on August 8, 2017 at 4:32am

I am trying to add derby database connection to iReport 5.6v but getting below exception when I click on Test.

ClassNotFoundError! Msg: org.apache.derby.jdbc.ClientDriver Possible not found class: org.apache.derby.jdbc.ClientDriver

1.Tried adding derby client jar from Tools-> Options-> Classpath -> Add jar -Did not work

2.Tried adding jar directly to iReport-5.6.0\ireport\modules\ext -Did not work. I

s there any other configuration that is required?

Joined: Aug 8 2017 - 4:29am

Last seen: 5 years 7 months ago

Its happening for me as well. Any suggestions here.

prashanth7582 - 3 years 4 months ago

1 Answer:

Posted on March 10, 2021 at 6:36pm

Please try with lower versions of Apache Derby DB JDK

Faced similar issue with jasper reports server 7.8.0 community edition, Derby 10.15, compatible with JDK 9+ was not loading.

Workaround: Use Derby 10.14, compatible with JDK 8+, and Derby DB loads.

Error seen in logs: jar file has been built with version 53 and higher, can read only version 52 and lower

shawn.f

Joined: Jan 22 2021 - 9:46am

Last seen: 1 year 8 months ago