therrick_1 Posted July 28, 2015 Share Posted July 28, 2015 I'm working thru the Jaspersoft Studio and JasperReports Server tutorials using the sample data sources. I've tried to look at the data to find Primary/Foreign Keys and also data types such as VarChar, Integer, etc... How do I find that info with the sample data provided? Link to comment Share on other sites More sharing options...
Solution hozawa Posted July 29, 2015 Solution Share Posted July 29, 2015 I think the sample database is using hsql database. Use something like squirrel sql client.ORJust look at my page for the ddl I've converted to use in MySQL database.http://bi.lakeel.com/usersupport/tutorial/download/sampleDB.sql Link to comment Share on other sites More sharing options...
therrick_1 Posted July 31, 2015 Author Share Posted July 31, 2015 I didn't try using squirrel sql client and searching for the hsql database. I talked to a Jasper Rep and they weren't sure of how to find the data defn. So I'll go with the MySql and use hozawa's ddl. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now