[JI-Pro AdHoc and $P{Parameter}]

It's part of JasperServer Pro 2.0. If you install the sample data, it should contain an Ad Hoc topic called "Parameterized Report" which has three different parameters with input controls that you can change in Ad Hoc or when you run the report.

[Jasperserver 1.2.1 build with postgres]

I looked at your doc, and just yesterday another developer here had found and fixed the unit test failure you mentioned:

5. I ran the “mvn clean install†form the jasperserver/jasperserver-unit-test directory and I had one test failure in the TestUserQuery test. I verified that the TestUser was defined in the database (in the jiuser table), so I am not sure what the issue is. I have attached the surefire-reports contents to this issue as a zipfile attachment.

I let him know so he or I can post the fix here.

 

I don't see the jaspererr.txt that you mentioned in point 9--can you post it?

Post edited by: bobtins, at: 2007/04/11 20:18

[No errors being reported in the event recorder]

I've just been working on Oracle compatibility so I'm familiar with kind of thing.

 

I googled on the Oracle error and found a wide variety of issues. Some were caused by Oracle JDBC bugs, others by various combinations of column types and ways of binding values through JDBC, but they were all with long binary or character strings.

 

The JILogEvent table has event_text with type VARCHAR(4000) and event_data with type "LONG RAW" so these are the two I'd suspect. This hibernate user said he turned up an Oracle JDBC bug although it's not clear from the post how he resolved it. You might want to try getting the latest JDBC driver, though:

http://forum.hibernate.org/viewtopic.php?t=964482

 

Other than that, we'd need to find out what Hibernate's doing at the JDBC level (i.e. what setters it's calling to set the column values) and play around with the Hibernate configuration on this table (which is in an hbm.xml file) to see if there's a better type to use for these columns.

 

Sorry I can't be more specific...I think this will be trial and error. I'd report this as a bug (which I might end up fixing).