JDBC Data Adapter not showing jar file

[urriah.aguilera]

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

[anish.rai]

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.

[Jitendra Mandalia]

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.

 

[urriah.aguilera]

Thanks @jmand, the hardcoding part was confusing as no guide/tutorial I have seen where the values were hardcoded. Thus I had reservations with doing it. I applied the solution and it worked out since Test Connection was successful.