Using JDBC Data Adapters
Posted on November 19, 2018 at 5:13am
I have an application that uses an in memory database to fill reports. Being in memory it has to be created each time. Users will create reports based on this database and I want to provide the Data Adapter to them for use in Jasper Studio.
Is there a way of creating an Adapter with the fields already defined without creating a physical database?
Joined: Mar 28 2015 - 8:46am
Last seen: 2 years 1 month ago
Posted on November 19, 2018 at 2:34pm
Have you tried creating an adapter and using Dataset and Query Dialog to define columns. Just press "Add" button located at the lower right hand side and type "Field Name" and "Class Type".
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 9 months ago
I was trying to avoid having to input the fields by hand. I have to create an SQL script to create the database, I didn't want to repeat the exercise within Studio. Ideally I could create the Adapter by reading the SQL script. The short cut is to run the script on a physical database and then creating the adapters from that database.