I am using Jaspersoft Studio 6.20 (Community Edition). I am trying to create a new data adapter to point at an AS400 server but after successfully adding the jar file (found jt400-6.4 and jt400-6.7 online) in the Driver Classpath, the Database Location -> JDBC Driver is not showing the newly added jar files. I am currently working with Studio but would eventually move this into Jasper Server, any additional info is appreciated.
Thanks,
Urriah
2 Answers:
Posted on April 20, 2023 at 1:19pm
Hi Urriah.aguilera
Once you add the driver jar in the class "Driver Classpath", you will need to enter the JDBC Driver name, URL, Username and Password manually in "Database Location" tab. You will not see it added to the "JDBC Driver" dropdown field. Please see the setup for the adapter below.
Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.