william_ferguson_au

I also had a look at https://svn.sourceforge.net/svnroot/jasperintel as suggested in the JasperIntelligence-Source-Build-And-Developers-Giude, but its only up to revission 7 last committed on 20-JUN-2006. Where's the current SCM location? William

I'd like to checkout thejasperIntel source as I need to build 1.0.1 against Axis2-1.1-RC1 but am wondering where the source is located. Following the DeveloperForge link hunting ofr source code eventually lands you at http://www.jasperforge.org/sf/scm/do/viewRepository/projects.jasperintelligence/scm.JasperIntelligence_Repository Which seems to give a SCM location of http://scm.jasperforge.org/svn/repos/jasperintelligence Bu the SVN version at that location is 2, ie only a single change has been made to the original source, so it doesn't sound quite right. Where should I be looking? William

Sherman, what's the ETA of the Oracle patch for 1.1? Also what version of jasperReport does JI-1.1 run against? 1.0.1 ran against 1.24, but I need 1.2.5 or greater for access to JRPrintText#getValueClassName William

Thanks Sherman, that worked nicely.

Hi, I'm attempting to get jasperIntel running against an Oracle (9) database. I have converted the jasperserverCreate.ddl from MySql to Oracle, and copnfigured the context xml and hibernate properties to use the appropriate driver and dialect, but the problem I am having is that a "Resource" table is defined which is a reserved word in Oracle. I have managed to create a "Resource" table by quoting all instances of it in the DDL, but JasperIntel falls over at runtime because the SQL generated by hibernate doesn't quote "RESOURCE" then. Any ideas of how I can get it to do it?

Thanks Tony, that got me there. Perhaps the comment at http://jasperforge.org/sf/scm/do/viewRepository/projects.jasperintelligence/scm.JasperIntelligence_Maven2_reposi should be changed to indicate that its not an anonynous checkout. BTW are there are plans for the JasperServer components to be installed in that Repository? William

I'm looking for a Maven Repository from which I can download the built JasperIntel libraries. I'm hoping thats at http://scm.jasperforge.org/svn/repos/jasperintelligence_maven as is hinted at on http://jasperforge.org/sf/scm/do/viewRepository/projects.jasperintelligence/scm.JasperIntelligence_Maven2_reposi but I can't tell because it wants a password that I don't have. I noted that JasperReports is available via IBiblio. Where can I pick up the JasperIntel libs so that I can build against them? William

Is the versioning provided in JasperIntel anything more than incrementing the version number field when a report is loaded to the same URI as an existing report? Is the previous version of the report retained in JasperIntel? If so, how do you execute an instance of the old report? William

How do you control how many report instances are generated at once? Eg I have 200 jobs scheduled to run at 2am, running them all in parallel would likely cause both the Jasper server and the DB to thrash. Is there a way in which limit the number of parallel jobs? And what avlues are generally used? William

lucianc wrote: Therefore the job owner needs to be a user registered in JasperIntelligence. Would this hold for your "user1", or would "jasperAdmin" be the only registered user? "jasperAdmin" would be the only registered user and would have full access to all resources. lucianc wrote: Also, in which way are you including the username in the generated report? Is it via the "LoggedInUser" parameter? To date there have been no requirements for details of the user that requested the report to be embedded in the report output. Though if this became the case I expect that it would be resolved by passing the appropriate paramater to the report itself. We really need the id of the user that we have said is scheduling the report and for whom a report instance is generated to be preserved so that we can query for it. Which is another questiion, how do I query for all scheduled jobs for a particular user? And I really don't want to duplicate our authentication framework within JasperIntel. Is it possible to verify the required resources (according to the authenitcated user "jasperAdmin" when the report is scheduled instead of when it is run? Then all that would need be done is to preserve the value of the #username attribute on the ReportJob when it is scheduled. Ie have the #username stamped by the client to the ScheudlingService instead of somewhere in its bowels. William

From our WebService (deployed within JasperIntel) I am trying to schedule a report using the SchedulingService. The client connects to the WebService by passing well-known credentials, currently jasperAdmin (we only intend to have a single user configured within JasperIntel and restrict access to it from within our application). When I construct the ReportJob I specify ReportJob#userName to be 'user1' expecting it to be preserved. But when I execute schedulingService#getScheduledJobs the ReportJobSummary returned lists the #username as jasperAdmin not 'user1'. Is there some way for me to get the username of the scheduled job preserved? Likewise for generated report output. I need to have the username of the scheduled job preserved in the generated report. William

Thanks Sherman, that work nicely. But I don't understand why you also suggested moving it higher in the list of URIs. It isn't maked by anything above it so it shouldn't matter right? In any case, it worked fine by just adding in the ROLE_ANONYMOUS entry. To keep the names of the generated results human comprehensible and to provide the token level security I mentioned above, we will be creating a new folder in the repository for each ReportJob based on the token. Each such folder would then contain one generated report output for each time that schedueld ReportJob is executed. Are you aware of any limitations we might encounter by having so many folders created within the Repository? William

We don't want to use the JasperIntel UI (in general) as report scheduling etc will be performed via a WebService. But we do want users to be able to retrieve their reports without having to authenticate to the JasperIntel application as they will already have autheticated to another application. Our plan is to generate a token for each report and use that token to create a path within the repository (or hopefully filesystem) at which the report results will be stored. Is there some way I can switch off authentication requirements for "/fileview/*" Requests but not for anything else? William

We don't intend to use any of the JasperIntel UI. All access to JasperIntel is via a WebService. The generated report files will be served directly off the disk by another Servlet or WebApp. William

What do I need to do to get a job scheduled to run once/month using a Simple Recurrence? It only provides for minutes/hours/days/weeks as the interval.

Is there any way to schedule a report such that its output is expported to the file system instead of being stored back in the database? I'm asking because some of the reports that will be generated will be 40M in size and I don't really want the overhead of 1) transferring this to the DB 2) writing it in the DB 3) retrieving from the DB 4) transferring it from the DB especially when I could write it straight to the file system and have a web server serve it directly from there. William

I want to create a WebService that allows you to schedule a Report etc and that can be dropped alongside the existing repository ws. Looking at the 1.0.1a source of the ManagementService, it appears that I need to retrieve the EngineService etc from context provided to the Axis2SpringServlet. Whats the best way of achieving this, since I'm running JasperIntel 1.0.1 William