vmustafa

Hi, How to use Hibernate datasource (as available in iReport) with Jasperserver to build reports? Jasperserver defines datasources a bit differently - unlike next() & getFieldValue(...) of iReport - and offers 3 types, viz, JDBC / JNDI / JavaBean. Regards vmustafa

Hi, While creating a new Domain in JSPro3.5 eval version, I find that upon selection of tables forming the basis of the domain, the columns of selected tables which are of type NVARCHAR2 seem to get ignored. My DB is Oracle 10G. Some of these NVARCHAR2 columns may actually be primary / foreign keys - thus limiting the ability to define the domain substantially. I have read in the "JasperServer-Pro-User-Guide.pdf" that some unsupported fields, like BLOB, do get ignored. But there is no mention wrt NVARCHAR2. Do help me out. Regards, vmustafa

Matt, I am using Oracle 10G R-2 as the DB. After studying the problem I noticed that all the columns of datatype NVARCHAR2 get omitted while reading from the schema into the JasperServer datasource while defining the Domain. Any idea why this is happening? Regards vmustafa

Hi I am trying to create a Domain using the jasperserver pro 3.5 eval version. After selecting the tables I noticed that only a few columns of the tables get included in the selection. This makes it difficult to assign joins. Is there a feature restriction wrt Domain in this evaluation version? Do let me know. Regards. vmustafa

Hi, I am trying to define a Bean Data Source in JasperServer 3.5 (and even 3.1). My configured bean is a factory class which creates & returns an instance of ReportDataSourceService. The name of the method on configured bean is the method of the factory class which creates the instance of ReportDataSourceService. The Spring application context is able to locate my relevant java beans. Now, when I press the Test Connection button - the Test Failed message comes. Apart from this there is no info in any log files to indicate the cause of this failure. How to go about finding the cause of this failure? Please help!!! Regards vmustafa Code:Application Context file contains the entry:- <bean id="studentDataSourceServiceFactory" class="com.xyz.studentcourses.StudentDataSourceServiceFactory" scope="singleton"/>The factory method is defined while defining the Bean Data Source.

Hi, I am using iReports 2.0.4. I am using a custom datasource provided by a custom datasource provider (though my observations are same even for javabean collection datasource). The fields returned by the datasource can be of custom type (other than the usual String, Integer, Boolean, etc). When I select these custom fields for my report & try to build an expression using the Expression Editor - the types associated with these custom fields do not expand into appropriate methods (getXXX(), etc) in the rightmost pane in the lower part of the editor - although the editor is aware of the custom type (through the jar file). Th erightmost pane is filled up for only the standard types like String, Boolean, etc. Due to this, the report designer needs to be aware of the methods available with the custom types to build up the expression. Is there any way to look into the properties of the custom types in Expression Editor? Regards. vmustafa.

Hi, I am using iReport 2.0.4 I am trying to use the QueryExecuter along with FieldsProvider to build up my report. When I use the QueryExecuter only (w/o attaching a FieldsProvider) and build up the report by manually entering the fields (as I know the contents of DataSource created by the QueryExecuter) the report works. But when I attach the FieldsProvider to the QueryExecuter, it does not work. When I press the ReadFields button in Report Query a message is displayed indicating that the QueryExecuterFactory is not found - Error: net.sf.jasperreports.engine.JRException: Class <my query executer factory class> not found. My FieldsProvider is very basic - it returns the fields which I expect from my datasource (I have hardcoded it in the getFields method) without any need to work on the query string. How to resolve this? Request your help. Regards vmustafa Related to this issue another exception also keeps cropping up - net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: No query executer factory class registered for <query language> queries. Create a property named net.sf.jasperreports.query.executer.factory.<query language>. I am unable to find the property file this message is referring to - all I know is the jar containing the factory is in the classpath of ireports. Regards vmustafa Post Edited by Mustafa Vadnagarwala at 03/26/09 14:28

Thanks, it seems to be working with zipped export.

The messages on the console were as below:- Role ROLE_USER already exists, skipping. Role ROLE_ADMINISTRATOR already exists, skipping. Role ROLE_ANONYMOUS already exists, skipping. Role ROLE_PORTLET already exists, skipping. User joeuser already exists, skipping. User jasperadmin already exists, skipping. User anonymousUser already exists, skipping. User ReportAdmin already exists, skipping. Folder details not found in import input for folder /[/code]Please note that when I run for first time, the roles & users do get properly created. Regards vmustafa

While attempting to transfer contents from one instance of JasperServer to another, both linux, I am able to successfully export into a folder. But when I copy the folder into the target m/c and do an import it gives the following message - "Folder details not found in import input for folder /" This happens after the User & Roles subdirectory are processed and resources subdir is about to be processed. Any clue? Regards vmustafa

Hi, While using iReport 2.0.4 and running a simple query (after initial testing of the HQL connection) using HQL, I am facing the following error:- "Error: could not execute query using iterate" Any solution? What are the compatible set of hibernate jars to go with iReport 2.0.4? Thanks & Regards vmustafa

Hi, I am trying to use Hibernate Connection as the data source (using MySql) with iReports (version iReports 3.1.2) but am unsuccessful. After doing the initial config file & mapping file checkups, iReport is unable to open connection - "Cannot open connection" while testing the Hibernate connection. The main messages in the IDE-Log are:- 1 - java.lang.IllegalStateException: You are trying to access file: hibernate.cfg.xml from the default package. Please see http://www.netbeans.org/download/dev/javadoc/org-openide-modules/org/openide/modules/doc-files/classpath.html#default_package 2 - org.hibernate.exception.GenericJDBCException: Cannot open connection 3 - Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3307/xxx The hibernate associated files are in the directory - C:Program FilesJasperSoftiReport-nb-3.1.2ireportmodulesext The MySql related file - mysql-connector-java-5.0.7-bin.jar - is in directory - C:Program FilesJasperSoftiReport-nb-3.1.2ide8modulesext Why is iReport not able to access a suitable driver for mysql? Please help!! Regards vmustafa Post Edited by Mustafa Vadnagarwala at 02/06/09 11:32

Seems to be working when I close down the iReport instance and restart. When I make changes to java code, I need to remove the selected fields in iReport & then "Get fields from datasource" to make to reflect the changes. Regards vmustafa

Hi, Unable to locate the Query Executer & Fields Provider associated UI in the iReport ver 3.1.2. For Query Executer there seems to be an option "Query Executer Mode" in the Connections / Datasources New option; but it does not seem to be doing anything - it just takes a Name & saves it as a datasource. The Test button does not do anything. The UI for these 2 features exist in an older version iReport 2.0.0 The UI for Custom iReport Connection feature also is not there in iReport 3.1.2 as well as iReport 2.0.0 Am I missing out something? Or are these features to be discontinued or revamped? Regards vmustafa

Hi, I am implementing a Custom data source provider ( JRDataSourceProvider interface) which creates a Custom datasource (JRDataSource ifc). I am implementing both the JRDataSourceProvider's getFields(...) method as well as JRDataSource's getFieldValue(...) method. However, I am not getting the fields in the iReports (3.1.2) design tool's Report Query-->DataSource Provider-->Get fields from datasource button. It is showing null. When I am manually adding the fields in the report - using the same field names (of course!) as in my implementation - I am able to run the report. What could be the reason for showing NULL in the "Get fields from datasource" option? Regards vmustafa