Here is my situation , please help me resolve my problem.
We have been asked to develop a J2EE application which uses Crystal Report for reporting in such a way that these reports would be consumed through jsp pages or .NET client.
I have created a simple java class. This Java Class gets a database connection, executes a sql and returns a resultset. I have created report out of this class using Java Bean Connectivity feature of this report. Deployed it on Weblogic 8.1. I could call this report through jsp page which is again deployed on Weblogic 8.1. Similarly using .NET I have published it as Webservice and created a windows application to call this webservice. Everything works fine. So far so good.
No instead of a Java Class I need to go one deep which is I need to call an EJB which returns me a resultset. I followed above all steps. From JSP deployed on weblogic server my report works fine because same weblogic server has JRC components of crystal and all EJB libraries. THe problem I am facing is while publishing this report as a webservice and calling it from .NET client I get "query engine error." Unable to get the rowset. My Dilemma is am I on a right track ? Is it something I am not aware of as I am doing this first time ? Is there a different approach to achieve this ? How do u call a EJB based report from a .NET client ? If it's a simple java based report it works then why not with multiple packages , libraries ? Remember I am deploying this on IIS server so definitely I am trying something cross platform , interoperatibility is definitely an issue. I was assuming publishing webservice takes care of this part. Am I on right path ? Am I missing something ?
Please help. I will appreciate your help.
[ January 21, 2005: Message edited by: Shivade Sanjay ] [ January 21, 2005: Message edited by: Shivade Sanjay ]