Thanks for linking it @hozawa manage to solve it with their answers there. Anyways will share what i have done so maybe it can help someone here. 1.Need to configure META-INF/context.xml (located on JRSERVER_install_path/apache-tomcat/webapps/jasperserver) <Resource name="jdbc/Sqlite" auth="Container" type="javax.sql.DataSource" driverClassName="org.sqlite.JDBC" url="jdbc:sqlite:/${catalina.home}/dbs/Application.db" factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory"></Resource> name= any name you wanturl = the location of your database file - I copied my on the installation folder but no problems where you want to put itfactory = org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory ----> for tomcat 8,if you have lower version kindly search for it 2. Edit WEB-INF/web.xml (located on JRSERVER_install_path/apache-tomcat/webapps/jasperserver)<resource-ref> <description>Reviews Database</description> <res-ref-name>jdbc/Sqlite</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth></resource-ref> 3. Make a new datasource in JRServer Use JNDI Datasource Service name = jdbc/Sqlite or whatever you put on step 1 NAME Test it,Thats all http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/thumbs_up.gif
