csbac

Hi! AFAIK, JasperAnalysis is contained in JasperServer ... Thus, OLAP analysis works when you installed the JS. Also, http://www.jasperforge.org/index.php?option=com_content&task=section&id=16&Itemid=277 says this: "JasperServer (Includes JasperAnalysis)" Yours, Sebastian

Hi! Looks very much like "SOAP with attachments" to me ... The response in itself looks OK, starts with a 200 OK. It seems the receiving side does not support attachments? Yours, Sebastian

Hi! As I just wrote in http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=22623 I had this problem as well ... in my case, it was caused by an old mysql-connector...jar. Yours, Sebastian

Hello! I had the same problem on one installation. Short version: I used a quite old mysql-connector (3.0.9, if I remember rightly). After replacing it with current 5.0.5, it did work. Longer version: I found out that the user account was correctly authenticated (wrong password gave different log message). On the other hand, the authentication object logged by acegisecurity did not log any permissions. I then found out that the only difference between the working and the non-working installation were the connector-j. Thus, I presume, the old version of the mysql jdbc driver did not return any rows from the user->role assignment table, or rather returned an error that was dropped ...? Some time later, I ported JasperServer to FirebirdSQL, and had an empty JIUserRole table in between - the error message was different (login succeeded, yet "access denied" on the JS pages themselves, no logout possible). Obviously, the "locked" problem is a bit more than just "no rows from JIUserRole". Maybe s.th. about join or union or sub-select that only "newer" versions of mysql support? Yours, Sebastian PS: I forgot to write ... I'm using JS on JBoss 4.0.4, not tomcat. Thus, I had to add the mysql-connector manually to server/name/lib. Post edited by: csbac, at: 2007/03/18 08:47

Post edited by: csbac, at: 2007/03/16 12:38

Hello! Just ... a note about your solution: The "!" in $P!{PARAM} is obviously VERY important. Without, the parameter is uses as a JDBC parameter, and JDBC does not support in (?) parameters. The error messages depend on the db system (firebird: cast error; mysql: empty report), yet it probably never works. I presume the "!" makes it a string insertion, not a JDBC parameter? Thanks, Sebastian PS: Just in case s/o noticed ... a few minutes ago my post was a bit longer and said exactly the opposite ;-) Post edited by: csbac, at: 2007/03/16 12:37

Hello, I understand your problem because I have just been trying to do the same ... There are two problems there. * JasperServer passes Multi-Selection values to the Jasper report in a class that implements Collection. Thus, if you define the report parameter as java.util.Collection, you can access it from the report and print it etc. As a default value in the parameter definition, you can use, e.g., Collections.singletonList("entry") or Arrays.asList(new String[] {"entry1", "entry2" }). This works for me w/o any problem. * If you want to use this parameter in an SQL query, like in SELECT * FROM TABLE WHERE idSth in ($P!{param}), you need to look at the post http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=19639 The only viable way is to convert the multi-selection list (Collection) in a string list, and set this as a parameter. Take care of the "!" in $P!{PARAM}, though. Otherwise, the string is passed as JDBC parameter, and that one only places the single string into the "in (?)", not as a list of items/strings. I will have to find out how to best do this conversion; toString() does not work, as it writes [1,2,3] in case of an Integer collection ... maybe a replaceAll call afterwards? Yours, Sebastian Post edited by: csbac, at: 2007/03/16 12:44