{"id":13636,"date":"2022-11-04T14:21:15","date_gmt":"2022-11-04T20:21:15","guid":{"rendered":"http:\/\/201.237.206.56\/Sitios\/ugit.siua.ac.cr\/?p=13636"},"modified":"2022-11-07T09:18:27","modified_gmt":"2022-11-07T15:18:27","slug":"cgi-configurar-jasper-studio-para-sigesa","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=13636","title":{"rendered":"CGI: Configurar Jasper Studio para SIGESA"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>SIGESA utiliza jasper 5.5.0 por tanto tenemos que configurar el jasper studio para que utilice esta versi\u00f3n<\/li><li>Si no SIGESA presenta el siguiente error<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"964\" height=\"625\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_142.png\" alt=\"\" class=\"wp-image-13637\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_142.png 964w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_142-300x195.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_142-768x498.png 768w\" sizes=\"(max-width: 964px) 100vw, 964px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Para esto abrimos el Jasper Studio y vamos a men\u00fa->Window->preferences<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"240\" height=\"318\" src=\"\/wp-content\/uploads\/2022\/11\/Menu_143.png\" alt=\"\" class=\"wp-image-13638\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Menu_143.png 240w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Menu_143-226x300.png 226w\" sizes=\"(max-width: 240px) 100vw, 240px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"240\" height=\"318\" src=\"\/wp-content\/uploads\/2022\/11\/image.png\" alt=\"\" class=\"wp-image-13640\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/image.png 240w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/image-226x300.png 226w\" sizes=\"(max-width: 240px) 100vw, 240px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Vamos a la secci\u00f3n de  Jaspersoft Studio-&gt;Compatibility-&gt;Manage JaspertReports Versions<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"845\" height=\"599\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_144.png\" alt=\"\" class=\"wp-image-13642\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_144.png 845w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_144-300x213.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_144-768x544.png 768w\" sizes=\"(max-width: 845px) 100vw, 845px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Nos muestra una ventana donde nos solicita el path del archivo<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"468\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_145.png\" alt=\"\" class=\"wp-image-13643\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_145.png 711w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_145-300x197.png 300w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Por tanto debemo ir a la siguiente p\u00e1gina donde debemos descargar la versi\u00f3n que requerimos<\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/sourceforge.net\/projects\/jasperreports\/files\/archive\/jasperreports\/\" target=\"_blank\">https:\/\/sourceforge.net\/projects\/jasperreports\/files\/archive\/jasperreports\/<\/a><\/li><li>Para nuestro caso 5.6.0<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"254\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_146-1024x254.png\" alt=\"\" class=\"wp-image-13644\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_146-1024x254.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_146-300x75.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_146-768x191.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_146.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"526\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_148-1024x526.png\" alt=\"\" class=\"wp-image-13645\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_148-1024x526.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_148-300x154.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_148-768x394.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_148.png 1155w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Descomprimimos la carpeta<\/li><li>Y en Jasper Studio le indicamos la ruta<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"399\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_149-1024x399.png\" alt=\"\" class=\"wp-image-13647\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_149-1024x399.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_149-300x117.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_149-768x299.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_149.png 1110w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Ahora le indicamos a jasper studio que utilice esta versi\u00f3n<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"841\" height=\"628\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_150.png\" alt=\"\" class=\"wp-image-13649\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_150.png 841w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_150-300x224.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_150-768x573.png 768w\" sizes=\"(max-width: 841px) 100vw, 841px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">PLSQL: <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Gu\u00eda: <a rel=\"noreferrer noopener\" href=\"https:\/\/community.jaspersoft.com\/wiki\/no-query-executer-factory-registered-plsql-language-jasperserver-51\" target=\"_blank\">https:\/\/community.jaspersoft.com\/wiki\/no-query-executer-factory-registered-plsql-language-jasperserver-51<\/a><\/li><li>Para poder utilizar plsql en Jasper Studio debemos descargar <\/li><li><a href=\"http:\/\/www.java2s.com\/Code\/Jar\/j\/Downloadjasperreportsextensions353jar.htm\">http:\/\/www.java2s.com\/Code\/Jar\/j\/Downloadjasperreportsextensions353jar.htm<\/a><\/li><li>o de <a href=\"\/wp-content\/uploads\/2022\/11\/jasperreports-extensions-3.5.3.zip\">aqu\u00ed<\/a><\/li><li>Debemos crear una carpeta \u00ablib\u00bb en<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir \/opt\/tibco\/TIB_js-studiocomm_6.20.0\/META-INF\/lib\nchmod 777 \/opt\/tibco\/TIB_js-studiocomm_6.20.0\/META-INF\/lib<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Y con nautilus pegamos el archivo ah\u00ed<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"307\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_151-1024x307.png\" alt=\"\" class=\"wp-image-13653\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_151-1024x307.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_151-300x90.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_151-768x230.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_151.png 1128w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Tambien lo pegamos en la carpeta anterior de jasperreports 5.6.0<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>\/home\/tavo\/Escritorio\/NUBECASA\/012_Trabajos\/CGI\/Programas\/jasperreports-5.6.0-project\/jasperreports-5.6.0\/lib\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ahora creamos la carpeta \u00abclasses\u00bb como usuario root<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir \/opt\/tibco\/TIB_js-studiocomm_6.20.0\/META-INF\/classes\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Y creamos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/opt\/tibco\/TIB_js-studiocomm_6.20.0\/META-INF\/classes\/jasperreports.properties<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>y el agregamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Luego creamos la carpeta \u00abflow\u00bb<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir \/opt\/tibco\/TIB_js-studiocomm_6.20.0\/META-INF\/flows<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ceamos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/opt\/tibco\/TIB_js-studiocomm_6.20.0\/META-INF\/flows\/queryBeans.xml<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Y le agregamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;bean id=\"editQueryAction\" class=\"com.jaspersoft.jasperserver.war.action.EditQueryAction\">\n    &lt;property name=\"repository\">\n        &lt;ref bean=\"${bean.repositoryService}\"\/>\n    &lt;\/property>\n    &lt;property name=\"queryLanguages\">\n        &lt;list>\n            &lt;value>sql&lt;\/value>\n\u00a0\n            &lt;!-- Here is the added value to PL\/SQL Query Language -->\n            &lt;value>plsql&lt;\/value>\n\u00a0\n            &lt;value>hql&lt;\/value>\n        &lt;\/list>\n    &lt;\/property>\n    &lt;property name=\"queryLanguagesRequestAttrName\" value=\"queryLanguages\" \/>\n    &lt;property name=\"validator\" ref=\"queryValidator\" \/>\n&lt;\/bean><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/opt\/tibco\/TIB_js-studiocomm_6.20.0\/META-INF\/applicationContext.xml<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Y le agregamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;bean class=\"com.jaspersoft.jasperserver.api.engine.jasperreports.util.DataSourceServiceDefinition\">\n    &lt;property name=\"serviceBeanName\" value=\"jdbcDataSourceServiceFactory\"\/>\n    &lt;property name=\"supportedQueryLanguages\">\n        &lt;set>\n            &lt;value>sql&lt;\/value>\n            &lt;value>SQL&lt;\/value>\n\u00a0\n            &lt;!-- Add these two value lines for the Oracle PL\/SQL Language -->\n            &lt;value>plsql&lt;\/value>\n            &lt;value>PLSQL&lt;\/value>\n\u00a0\n        &lt;\/set>\n    &lt;\/property>\n&lt;\/bean>\n\u00a0\n&lt;bean class=\"com.jaspersoft.jasperserver.api.engine.jasperreports.util.DataSourceServiceDefinition\">\n    &lt;property name=\"serviceBeanName\" value=\"jndiJdbcDataSourceServiceFactory\"\/>\n    &lt;property name=\"supportedQueryLanguages\">\n        &lt;set>\n            &lt;value>sql&lt;\/value>\n            &lt;value>SQL&lt;\/value>\n\u00a0\n            &lt;!-- Add these two value lines for the Oracle PL\/SQL Language -->\n            &lt;value>plsql&lt;\/value>\n            &lt;value>PLSQL&lt;\/value>\n\u00a0\n            &lt;\/set>\n        &lt;\/property>\n&lt;\/bean><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Reinicamos el Jasper Studio y ya podremos compilar plsql<\/li><li><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SIGESA utiliza jasper 5.5.0 por tanto tenemos que configurar el jasper studio para que utilice esta versi\u00f3n Si no SIGESA presenta el siguiente error Para esto abrimos el Jasper Studio y vamos a men\u00fa->Window->preferences Vamos a la secci\u00f3n de Jaspersoft Studio-&gt;Compatibility-&gt;Manage JaspertReports Versions Nos muestra una ventana donde nos solicita el path del archivo Por [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[429],"tags":[450,430,446,449],"class_list":["post-13636","post","type-post","status-publish","format-standard","hentry","category-cgi","tag-5-5-0","tag-cgi","tag-jasper","tag-studio"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/13636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13636"}],"version-history":[{"count":7,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/13636\/revisions"}],"predecessor-version":[{"id":13655,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/13636\/revisions\/13655"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}