samira.haroun Posted August 15, 2014 Share Posted August 15, 2014 hi experts,my first day with jasperi downloaded and installed jasperreports-server-5.6 & jaspersoftstudiopro-5.60i can't find a way to add new data source to my sql DB and create the report (jaspersoft Studio Professional).if anyone has a link to show steps for beginners, it would be perfect.the tutorial here doesn't have the same interface i have. i tried to add snapshoot of my jasper but upolading picture here is so slow.thanks in advance,Samira Link to comment Share on other sites More sharing options...
989989272c Posted August 15, 2014 Share Posted August 15, 2014 http://community-static.jaspersoft.com/sites/default/files/docs/jaspersoft-studio-user-guide.pdfThis is your best friend. I don't remember exactly how to do it. It should prompt you in studio while you are setting up a new report. Link to comment Share on other sites More sharing options...
Solution elizam Posted August 15, 2014 Solution Share Posted August 15, 2014 IN the doc http://community-static.jaspersoft.com/sites/default/files/docs/jaspersoft-studio-user-guide_0.pdf, look at the section 10.1, create Data Adapters, and select Database JDBC connection. Then look at section 10.2 Creating Database JDBC Connections.One thing that might confuse you is that Jaspersoft products don't include the native MySQL driver, because of licensing issues. So unfortunately you will need to download and install a MySQL driver. Here's a modified version of the instructions in the doc:WhatyouhavetodoistoaddtheJDBCdriverforOracle,whichisafilenamedojdbc14.jar(orclasses12.ziporclasses11.zipforolderversions)totheclasspath(whichiswheretheJVMsearchesforclasses).AsJaspersoftStudiousesitsownclassloader,it'senoughaddtheojdbc14.jarfiletotheJaspersoftStudioclasspath,whichisdefinedinyourEclipseproject;thesamecanbedonefordirectoriescontainingclassesandotherresources.Toedittheclasspath,clickProject>Properties>JavaBuildPath>Libraries,andclickAddJARs.Ifyouonlyneedtousethedriverforthisspecificdataadapter,youcaninsteadaddthedriveronthedataadapter'sDriverClasspathtab.Add the JDBC driver for MySQL, which is a jar file, to the classpath (which is where the JVM searches for classes). As Jaspersoft Studio uses its own class loader, it will be enough add the driver jar file to the Jaspersoft Studio classpath in the Options window (Tools→Options); the same can be done for directories containing classes and other resources. Link to comment Share on other sites More sharing options...
elizam Posted August 15, 2014 Share Posted August 15, 2014 You can also put a jdbc driver on the Build Path for the project. (or via Window -> Preferences -> Java -> build path) Link to comment Share on other sites More sharing options...
djohnson53 Posted August 15, 2014 Share Posted August 15, 2014 What tutorial were you looking at that confused you? 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