Error trying to display reports in JRC

84 Views

Hi,

We have written some rather complex reports using Crystal Reports 2008. The reports are working well within the report editor, but when we try to run them in a JRC web application, they both fail.

We have 2 different error messages:

Error
Invalid Join Tree node.

and

Error
Unexpected database connector error.

The datasource is a JDBC connection, and the same errors occur with MySQL and Microsoft SQLServer. We use an SQL Command in both reports, to call a stored procedure. We also use subreports. The datasource for both reports is fairly similar, so nothing to explain the different error messages.

After logging the queries in MySQL, I found out that Crystal Reports will send all the required querys, but JRC doesn't send a single SELECT query. The other difference is that JRC sends a CONNECT message multiple times, without sending a password.

32 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
33 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
34 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
35 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
36 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
37 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
38 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
39 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
40 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
41 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
42 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
43 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
44 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
45 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
46 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
47 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
48 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
49 Connect     Access denied for user 'demo'@'localhost' (using password: NO)
50 Connect     demo@localhost on demo
50 Query       SHOW VARIABLES
50 Query       SHOW COLLATION
50 Query       SET NAMES utf8
50 Query       SET character_set_results = NULL
50 Query       SET autocommit=1

We have written other reports using the same SQL Command to call the same Stored Procedure, and they work just fine. There is something special about those reports that we can't figure out.

We use the same JDBC connector for both the report editor and the JRC web application.

I have also written a quick-and-dirty Java viewer application, based on the CR Java Runtime 12.2.200, and the same problem occurs.

Same with previewing the reports in Crystal Reports For Eclipse 2.

Has anybody experienced a similar problem? Is there something obvious that we are missing?

Thank you,

JC

Edited by: Jean-Charles Boude on Mar 9, 2009 5:52 PM