JasperServer 2.0.0 released

[Teodor Danciu]

The JasperSoft team is pleased to announce the release of the JasperServer 2.0.0, which brings new and improved functionality in these areas:

* Upgraded third party versions: mondrian-2.3, jpivot-1.7
* Improved display of input controls
* Simplified object permissions page
* Users can change their passwords
* Passwords stored in encrypted format
* Export to CSV
* Users can test connections when they create data sources
* XML/A data sources are now available for JasperServer reports
* Improved error handling

The iReport plugin was also updated to support the latest JasperServer functionality.

Release Notes:
http://sourceforge.net/project/shownotes.php?release_id=517489&group_id=162962

Download:
http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=195243&release_id=517489


The JasperSoft Team

[nucflash]

Hello,

 

I am running jasperserver 1.2.0 with postgreSQL backend.

 

Is there any SQL script to upgrade my postgres database from 1.2.0 to 2.0.0?

 

If not, what's the recommended method to switch to 2.0.0?

 

Thank you for your help!

[nucflash]

as there is a script from 1.2.1 to 2.0.0 for postgres, i created a script for 1.2.0 to 1.2.1. once you run this, you'll have your db in ver 1.2.1 and then you can upgrade with the script provided in the jasperserver to 2.0.0

 

Code:

    alter table JIBeanDatasource 
        drop 
        constraint FK674BF34F4D66224;

    alter table JIJNDIJdbcDatasource 
        drop 
        constraint FK7F9DA248F4D66224;

    alter table JIJdbcDatasource 
        drop 
        constraint FKC8BDFCBFF4D66224;

 ALTER TABLE jimondrianconnection DROP CONSTRAINT fk4ff53b197e642982;

    alter table JIReportDataSource 
        drop 
        constraint FK6A248C18A8BF376D;

    alter table JIReportUnit 
        drop 
        constraint FK98818B777E642982;


DROP TABLE JIReportDataSource;

    alter table JIBeanDatasource 
        add constraint FK674BF34A8BF376D 
        foreign key (id) 
        references JIResource (id);

    alter table JIJNDIJdbcDatasource 
        add constraint FK7F9DA248A8BF376D 
        foreign key (id) 
        references JIResource (id);

    alter table JIJdbcDatasource 
        add constraint FKC8BDFCBFA8BF376D 
        foreign key (id) 
        references JIResource (id);

    alter table JIMondrianConnection 
        add constraint FK4FF53B19324CFECB 
        foreign key (reportDataSource) 
        references JIResource (id);

    alter table JIQuery 
        add constraint FKCBCB0EC92B329A97 
        foreign key (dataSource) 
        references JIResource (id);

    alter table JIReportUnit 
        add constraint FK98818B77324CFECB 
        foreign key (reportDataSource) 
        references JIResource (id);

    alter table JIInputControl
        add column visible bool default true;

	  update JIInputControl set visible = true;

[wizhippo]

How did you get js to run with postresql?

 

I can get it 2.0 to run but anytime i go to add a file resource

 

I get a 11:16:08,283 ERROR JSErrorPage_jsp,http-0.0.0.0-8080-1:326 -

org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.

[tkavanagh]

I'm going to add a new topic for this problem so that we don't use the "JasperServer 2.0 Released" topic.

 

I'll call it "JS 2.0 and PostgreSQL Error".

Post edited by: tkavanagh, at: 2007/07/20 19:24

[ctcreel]

I have just installed JasperServer 2.0 on a linux box (Fedora). The input controls are not showing up but the reports are running. These reports worked on the previous version of JasperServer. Any ideas on what might be going on?

[lucianc]

In JS 2.0 the report input controls screen/dialog is shown only if there is at least one mandatory input control that lacks a default value (in the JRXML). If you don't have such an input control but want to force the controls screen, edit the report unit and check the "Always Prompt" flag in the resources/input controls screen.

 

HTH,

Lucian

 

PS: It's not necessary to post questions related to JasperServer 2.0 in the 2.0 announcement topic, you can safely create new topics.