{"id":224,"date":"2015-01-22T22:03:38","date_gmt":"2015-01-22T15:03:38","guid":{"rendered":"https:\/\/sanmaharjan.com\/?p=224"},"modified":"2015-01-30T09:57:31","modified_gmt":"2015-01-30T02:57:31","slug":"installing-jasperserver-pro-with-oracle","status":"publish","type":"post","link":"https:\/\/sanmaharjan.com\/installing-jasperserver-pro-with-oracle\/","title":{"rendered":"Installing Jasperserver pro (Evaluation) with Oracle"},"content":{"rendered":"<p>Installing Jasperserver pro with Oracle in Evaluation period is bit tricky, because bundle we download from server can only installer with Postgres\u00a0SQL.<\/p>\n<p>Below steps explain how to install platform independent Jasperserver pro in your system with Oracle repository.<\/p>\n<ol>\n<li>Download the Jaspersoft pro evaluation from <a href=\"http:\/\/www.jaspersoft.com\">here<\/a> (Lets say we downloaded windows version)<a href=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/download.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-228\" src=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/download.png\" alt=\"download\" width=\"442\" height=\"212\" srcset=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/download.png 442w, https:\/\/sanmaharjan.com\/uploads\/2015\/01\/download-300x144.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/a><\/li>\n<li>Install jaspersoft pro in windows machine, by default it will install with Postgres SQL\u00a0 <a href=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Install.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-229\" src=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Install.png\" alt=\"Install\" width=\"606\" height=\"449\" srcset=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Install.png 606w, https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Install-300x222.png 300w\" sizes=\"(max-width: 606px) 100vw, 606px\" \/><\/a><\/li>\n<li>Once it\u2019s installed with Postgres SQL, now it\u2019s time to rebuild the war file and pointing it to oracle.<br \/>\n<span style=\"color: #ff0000;\">Note:- we tried to reconfigure just configuration files as in other website told but it doesn\u2019t work 100%, you will get some error like invalid characters and some more errors. So please follow below steps for 100% success.<\/span><\/li>\n<li>First lets\u00a0 tweak and fix the path before building ant.\n<ul>\n<li>Copy the folder %JASEPER_HOME%\\apache-tomcat\\webapps\\jasperserver-pro into %JASPER_HOME%\\buildomatic\\install_resources\\war\\jasperserver-pro (create the folder war if it doesn&#8217;t exists)<\/li>\n<li>Delete the folder %JASER_HOME%\\buildomatic\\build_conf<\/li>\n<\/ul>\n<\/li>\n<li>Copy and rename the file inside %JASPER_HOME%\\buildomatic\\sample_conf\\oracle_master.properties into %JASPER_HOME%\\buildomatic\\ and rename the file into <strong>default_master.properties<\/strong><\/li>\n<li>edit the file <strong>default_master.properties<\/strong> file tomcat version, location of tomcat(different location than that is in %JASPER_HOME%), connection parameter of oracle, system username and password and jasperserver schema name and password you want to create like as in the attached file <a href=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/default_master.properties.txt\">default_master.properties<\/a><\/li>\n<li>Once you followed everything as per above, its time to build the oracle database repository and war file for oracle.\n<ul>\n<li>\n<table class=\"TableStyle-Table\" style=\"height: 938px;\" border=\"1\" width=\"735\" cellspacing=\"0\">\n<thead>\n<tr class=\"Head-Header1\">\n<td>Commands<\/td>\n<td>Description<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"Body-Body1\">\n<td><span class=\"Code\">cd %JASPER_HOME\\buildomatic<\/span><\/td>\n<td>Makes the buildomatic directory your current directory.<\/td>\n<\/tr>\n<tr class=\"Body-Body1\">\n<td><span class=\"Code\">js-ant create-js-db<\/span><\/td>\n<td>Creates the JasperReports Server repository database.<\/td>\n<\/tr>\n<tr class=\"Body-Body1\">\n<td><span class=\"Code\">js-ant create-sugarcrm-db<\/span><span class=\"Code\">js-ant create-foodmart-db<\/span><\/td>\n<td>(Optional) Creates the sample databases.<\/td>\n<\/tr>\n<tr class=\"Body-Body1\">\n<td><span class=\"Code\">js-ant load-sugarcrm-db<\/span><span class=\"Code\">js-ant load-foodmart-db<\/span><\/td>\n<td>(Optional) Loads sample data into the sample databases.<\/td>\n<\/tr>\n<tr class=\"Body-Body1\">\n<td><span class=\"Code\">js-ant init-js-db-pro<\/span><span class=\"Code\">js-ant import-minimal-pro<\/span><\/td>\n<td>Initializes the <span class=\"Code\">jasperserver<\/span> database, loads core application data. Running js-ant import-minimal-pro is mandatory. The server cannot function without this data.<\/td>\n<\/tr>\n<tr class=\"Body-Body1\">\n<td><span class=\"Code\">js-ant import-sample-data-pro<\/span><\/td>\n<td>(Optional) Loads the demos that use the sample data.<\/td>\n<\/tr>\n<tr class=\"Body-Body1\">\n<td><span class=\"Code\">js-ant deploy-webapp-pro<\/span><\/td>\n<td>Configures and deploys the WAR file to Tomcat, JBoss, or Glassfish.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Reference: <a href=\"http:\/\/community.jaspersoft.com\/documentation\/tibco-jasperreports-server-installation-guide-community-edition\/v60\/installing-war-1\">Jasperserver Site<\/a><br \/>\nNormally, minimal(excluding optional options) is enough and it makes Jasperserver clean from unnecessary objects being created.<\/li>\n<li>Output: &#8211; <a href=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Untitled.png\"><img loading=\"lazy\" class=\"alignnone  wp-image-232\" src=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Untitled-449x1024.png\" alt=\"Installation\" width=\"177\" height=\"404\" srcset=\"https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Untitled-449x1024.png 449w, https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Untitled-131x300.png 131w, https:\/\/sanmaharjan.com\/uploads\/2015\/01\/Untitled.png 1386w\" sizes=\"(max-width: 177px) 100vw, 177px\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>After following all above steps without any error. its time to install the jasperserver license.\n<ul>\n<li>Copy %JASPER_HOME%\\jasperserver.license to home directory<br \/>\n<table border=\"1\" cellspacing=\"0\">\n<tbody>\n<tr>\n<td width=\"340\"><strong><em>Operating System<\/em><\/strong><\/td>\n<td width=\"340\"><strong><em>Location<\/em><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"340\">Linux<\/td>\n<td width=\"340\">\/home\/&lt;user&gt;\/\u00a0 or ~\/<\/td>\n<\/tr>\n<tr>\n<td width=\"340\">Windows<\/td>\n<td width=\"340\">C:\\Users\\&lt;user&gt;\\<\/td>\n<\/tr>\n<tr>\n<td width=\"340\">Solaris<\/td>\n<td width=\"340\">\/export\/home\/&lt;user&gt; or ~\/<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"680\">or if you want to put in user defined location then please follow the <a href=\"https:\/\/community.jaspersoft.com\/documentation\/jasperreports-server-install-guide\/v56\/setting-jasperreports-server-license\">link <\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<\/ul>\n<\/li>\n<li>Now run the Tomcat (not the %JASPER_HOME%\\tomcat) and everything should be fine<\/li>\n<\/ol>\n<h3>Migrating Jasperserver and oracle repository.<\/h3>\n<ol>\n<li>Take a backup and restore oracle schema JASPERSERVER, FOODMART and SUGARCRM(if exists) into destination oracle server.<\/li>\n<li>Copy Jasperserver-pro webapps folder to Application server.<\/li>\n<li>edit the file located in jasperserver-pro webapps folder %TOMCAT%\\webapps\\jasperserver-pro\\META-INF\\context.xml file and configure Oracle url, schema name and password for jdbc\/jasperserver, jdbc\/sugarcrm, jdbc\/foodmart<\/li>\n<li>Copy the file jasperserver.license and copy to user home directory as said in above<\/li>\n<li>Start the Tomcat and finished \ud83d\ude42<\/li>\n<\/ol>\n<h2>If Evaluation period is expired<\/h2>\n<p>if evaluation period is expired then install the initially downloaded from jasperserver website with postgres sql in any test machine, which will generate the jasperserver.license and copy that file into existing jasperserver machine.<\/p>\n<p>&nbsp;<\/p>\n<h2>Reference:-<\/h2>\n<p>https:\/\/community.jaspersoft.com\/documentation\/jasperreports-server-source-build-guide\/v561\/additional-buildomatic-information<\/p>\n<p>https:\/\/community.jaspersoft.com\/questions\/813885\/how-configure-jasper-server-oracle-11g<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installing Jasperserver pro with Oracle in Evaluation period is bit tricky, because bundle we download from server can only installer with Postgres\u00a0SQL. Below steps explain how to install platform independent Jasperserver pro in your system with Oracle repository. Download the Jaspersoft pro evaluation from here (Lets say we downloaded windows version) Install jaspersoft pro in [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32,81],"tags":[102,2,101,99,12,103,100],"_links":{"self":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/224"}],"collection":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/comments?post=224"}],"version-history":[{"count":6,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/224\/revisions"}],"predecessor-version":[{"id":250,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/224\/revisions\/250"}],"wp:attachment":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/media?parent=224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/categories?post=224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/tags?post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}