I am using Jaspersoft Studio 6.40 and I am trying to determine the easiest way to connect to a local MySQL DB on a windows machine in order to create reports. The JRXML file will be uploaded Jasperserver running AWS Linux. The MySQL DB is stored in a folder on a Windows 10 machine, that is also running Jasper Studio.
I went to create an adapter, chose the JDBC connection, which I am assuming is the proper Data Adapter.
What is the best driver to use for JDBC? What should be the JDBC Url? For example, if the MySQL DB is located in c:\mydatabase, what would the url be? Do I need to run VMWare or something similar to create a localhost