mpenningroth

I want to bring up a particular report when a user within a spefic role logs in. This is with jasperserver-pro 3.1.2. I tried to do this modifing the home.jsp to use a new jsp if the particular role was identified. This runs the correct report but I get duplicate buttons etc. The relevant jsp code is shown below. I copied the homeForDemo.jsp and modified it . The attachment is a screen capture of what I see. If I run this using the url I don't have this problem. ie the following works ok: http://localhost:8080/CincomBIServer/flow.html?_flowId=viewReportFlow&reportUnit=/Financials_Demo/AR_Reports/Dashboard How can I get the proper behavior from the jsp? Thanks, Mark Code:<% request.setAttribute("homePage","true"); %> <%request.setAttribute("homePage","true"); %><table width="100%" height="100%" cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top"> <!-- dashboard is 896 pixels: 246 (Top Five) + 450 (Sales by Month) + 200 (Gauges) + spacing --> <table valign="top" align="center" cellpadding="0" cellspacing="0" border="0" width="928" <tr> <td valign="top" align="center" width="100%"><%@ page import="com.jaspersoft.ji.license.LicenseManager" %> <iframe name="Dashboard" allowtransparency="true" standalone="true" align="center" marginwidth="0" marginheight="0" hspace="0" vspace="0" frameborder="0" height="460" width="100%" scrolling="no" src="${pageContext.request.contextPath}/flow.html?_flowId=viewReportFlow&reportUnit=/Financials_Demo/AR_Reports/Dashboard"> </iframe> </td> </td> </tr> </table> </td> </tr></table>

Is this and other advanced topics discussed in the JasperIntelligence Ultimate Guide?

What database are you using?

Thanks Anandharaj. Cleaning up the tomcat cache did the trick.

Sorry I forgot to attach the tomcat error log for the case when I can't run a report. Here it is [file name=jaspererr.txt size=14605]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/jaspererr.txt[/file]

I built jasperserver 1.2.1 (using postgres as the repository) and I have several issues problems. Please see the .doc file in the attached zip for all the gory details. Note: I was running fine with an interim version of 1.2.1 that I collaborated with jaspersoft on. (My company has a partnership with jaspersoft). I opened a support issue with jaspersoft but I was also advised to post this issue to the forum. [file name=js121initialbuildprobs.zip size=104509]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/js121initialbuildprobs.zip[/file]

After reading the dubious jdbc specification, the setReadOnly method is just a hint to the database and does not mean that the transaction is prevented from updating the database. I went ahead and modified our jdbc driver to pretty much treat the setReadOnly method as a no-op.

Shermann, The problem was the readOnly settings. Our database doesn't really support a readOnly connection and since we support methods, we really couldn't easily enforce it from the jdbc api. I rebuilt our driver as a test, and when I don't throw an exception when attempting to set the connection as readonly, the jdbc connection worked fine. Thanks, Mark

Shermann, Yes the jndi works fine. I am sure that the jadb driver in question does not support the javax extensions for connection pooling. (It has its own pooling with a different interface.) I guess I was wondering if DBCP has options that can be set on a driver specific case that would allow it to work. I know that several middle tier servers implement their own pooling on top of drivers that do not directly support connection pooling. (jndi for one...). Regards, Mark

The database is Cincom's Object Relational Database. I work at Cincom and the database is used internally as a component of a couple of our products. It is a type II driver.

I have a jdbc datasource that works fine with iReport, but when I use the datasource in jasperserver, the connection fails. The driver is available to tomcat etc. If I use a jndi resource defined for the same jdbc datasource, it works fine. The jdbc driver is not from a standard database, I wonder if there are other options that can be set. Here is my stack trace: Caused by: java.util.NoSuchElementException: Could not create a validated object at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:851) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) ... 89 more 14:14:51,468 ERROR JSErrorPage_jsp,http-8080-Processor23:146 - java.util.NoSuchElementException: Could not create a validated object at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:851) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:58) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:52) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:66) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:556) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:314) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:686) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:248) at com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:110)

I am trying to get the source from svn and I am getting errors. svn: PROPFIND request failed on '/svn/repos/jasperintelligence' svn: PROPFIND of '/svn/repos/jasperintelligence': could not connect to server (http://scm.jasperforge.org) I got this to work a while ago, but no luck now. Any ideas?

I put the zip file back on the ftp server. It will automatically be deleted from the server in a couple of days.

Woops. I was looking under repository not repository admin. I guess that is by design? My stuff is visble via the admin route. It does seem strange to me though that when you click from the repository on datasources etc. you don't see the items, but you do see them when you go through the admin.

I used the repository admin to define new connection information: datasource, mondrianconnection, olap schema, etc. I also created an olap view based on my new definitions. The view works, but I don't see any of my new items in the browser except the view. In the repository browser I don't see any datasources, I don't see anything (including the sample database stuff) under the various sub folders of the olap tree except the views. The views return data (except the xmla one) so I know I have connection. I also see the resources in the database, why aren't they visble in the browser?

You can fix this by changing the js.quartz.properties file: org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate

I ran into an issue with quartz that I was able to get around by adding this line to my js.quartz.properties file: org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate I did not spend any time on trying to make thsi property driven from the build. It should/could be. Maybe I will find time to do so when I get the 1.1 build going.

I am trying to build 1.1 (I have built 1.01 ok) and I am running into problems. 1. I couldn't get the svn checkout to work, said it couldn't connect. Here is the error: C:>svn co --username mpenningroth http://scm.jasperforge.org/svn/repos/jasperintelligence_maven jasperintelligence_maven svn: PROPFIND request failed on '/svn/repos/jasperintelligence_maven' svn: PROPFIND of '/svn/repos/jasperintelligence_maven': could not connect to server (http://scm.jasperforge.org) This worked for me before. So I downloaded the zip file and proceeeded to try the build. 2. I updated my settings.xml to point to the new repository, etc and then tried the mvn install. This failed with errors :Project ID: org.acegisecurity:acegi-security Reason: Error getting POM for 'org.acegisecurity:acegi-security' from the repository: Error transferring file org.acegisecurity:acegi-security:pom:1.0.1 from the specified remote repositories: Maven Snapshots (http://www.ibiblio.org/maven2/), central (http://repo1.maven.org/maven2), ApacheSVN-central (http://scm.jasperforge.org/svn/repos/jasperintelligence_maven), jasperServer (file://C:/jasperintelligence-1.1.0-src/jasperserver-repo) I went out to ibiblio and they don't have version 1.0.1 of this jar. Anyone get past this?

My solution was to add additional properties to the jndi definition. Postgres has a setAutoCommitDefault property that I set to false. When a connection is obtained from the pool, it will automatically turn off auto commit. I tried the *prop changes and they had no impact. I have attached the readme.txt file that is included in the patch. It describes what I did to get this working. [file name=readme.txt size=3921]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/readme.txt[/file]

Did you check out the .zip file i uploaded about this. I had problems with the blobs as well. Post edited by: mpenningroth, at: 2006/11/07 19:35

I uploaded two zipfiles to the ftp.cincom.com/incoming/jasperintell_postgres . These will be available for a couple of days. One has the sugarcrm script and the other does not. Use anonymous ftp.

I haven't seen the specific error you sent. I also did not have to change any pom files as these use properties from the other settings. I have attached a zip file that documents my changes. Please see the readme file for more info. NOTE: Due to the size of the zipfile, I removed the sugarcrm script for postgres. You still should be able to run with foodmart and sugarcrm on mysql, and the jasper repository on postgres. You will of course have to make sure your maven setting properly reflect this. Sorry I guess the zip is too big still... Post edited by: mpenningroth, at: 2006/11/06 12:20

We could but I don't know how to do this.

I was finally able to build and run on postgres 8.1 . Please see the readme.txt in the attached zip file for what I had to do to get this to work. I haven't really done much with the system yet, but it does run through the unit tests, and the samples in the web app works the same as the mysql one. Regards, Mark Woops. My zipfile is too large. Let me know if you want it! Post edited by: mpenningroth, at: 2006/11/01 17:53

It is working now. I was using a different tomcat image and I had failed to put the mysql driver in the common/lib folder. OK I am still having problems with blobs in postgres. The readonly property on the beans do not make a difference. Post edited by: mpenningroth, at: 2006/10/25 14:49