Jump to content
Changes to the Jaspersoft community edition download ×


  • Posts

  • Joined

  • Last visited

robertmkc's Achievements


Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges



  1. Problem:When trying to run a MSSQL Stored Procedure in JasperServer, after selecting plsql as the language, the server returns the following error message: No query executer factory registered for the 'plsql' language. Resolution:Download jasperreports-extentions-3.5.3.jar. http://www.java2s.com/Code/Jar/j/Downloadjasperreportsextensions353jar.htm Place this file in your <jasperserver-pro>WEB-INFlib directory. In <js-install>WEB-INFclassesjasperreports.properties, add the line: net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory In <js-install>WEB-INFflowsqueryBeans.xml, add plsql as a value in the editQueryAction bean's queryLanguages property list: <bean id="editQueryAction" class="com.jaspersoft.jasperserver.war.action.EditQueryAction"> <property name="repository"> <ref bean="${bean.repositoryService}"/> </property> <property name="queryLanguages"> <list> <value>sql</value> <!-- Here is the added value to PL/SQL Query Language --> <value>plsql</value> <value>hql</value> </list> </property> <property name="queryLanguagesRequestAttrName" value="queryLanguages" /> <property name="validator" ref="queryValidator" /></bean>[/code]In <js-install>WEB-INFapplicationContext.xml, add plsql (lower and uppercase) as values in the jdbcDataSourceServiceFactory and the jndiJdbcDataSourceServiceFactory service beans: <bean class="com.jaspersoft.jasperserver.api.engine.jasperreports.util.DataSourceServiceDefinition"> <property name="serviceBeanName" value="jdbcDataSourceServiceFactory"/> <property name="supportedQueryLanguages"> <set> <value>sql</value> <value>SQL</value> <!-- Add these two value lines for the Oracle PL/SQL Language --> <value>plsql</value> <value>PLSQL</value> </set> </property></bean><bean class="com.jaspersoft.jasperserver.api.engine.jasperreports.util.DataSourceServiceDefinition"> <property name="serviceBeanName" value="jndiJdbcDataSourceServiceFactory"/> <property name="supportedQueryLanguages"> <set> <value>sql</value> <value>SQL</value> <!-- Add these two value lines for the Oracle PL/SQL Language --> <value>plsql</value> <value>PLSQL</value> </set> </property></bean>[/code]Restart the Jasper Services.
  2. Just as the title says: I can create a chart in the Adhoc Report Builder. When I click on the "Chart Types..." link, nothing happens. If I click "Chart Format..." it works fine. Is there some weird setting somewhere that I'm missing? Had anyone run in to that before?
  3. Oh wow! How did I miss that? I was trying to hide them in the overrides css file... I guess I was trying too hard! Thanks for the answer.
  4. I'm wanting to hide the unused scrollbars on the Dashboard. Any suggestions? I've circled them (somewhat sloppily) in the attached image.
  5. I know I'm missing something easy here: I'm trying to connect to MongoDB in JasperServer 5.1. I have a MongoDB connection defined and tests as working. How can I use that data source to create an Ad Hoc View? I can't seem to create a Domain/Topic off the data, as the source does not show up in my list. Any suggestions?
  6. Recently, I've been having issues in the repository when clicking any of the items, but the issue only occurs in the Chrome browser. It seems both left clicking and right clicking no longer function, though the clicks are certainly being registered by my pc. This is not an issue in Internet Explorer or Firefox. It seems to be solely limited to the Chrome environement. I've included a video link that goes to Youtube to show you what is going on. The pointer with the red circiles means I'm clicking the mouse at that moment. http://www.youtube.com/watch?v=L7-vnCU2sKY&feature=youtu.be
  7. Has anyone consumed the JasperServer Web Services using JQuery? I'm not trying to do a whole lot, but I'd like to get a list of dashboards created by the logged in user using Javascript/JQuery.
  • Create New...