File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes General Computing and the fly likes Java Bean Connectivity , EJB, JSP and .NET client dilemma Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Java Bean Connectivity , EJB, JSP and .NET client dilemma " Watch "Java Bean Connectivity , EJB, JSP and .NET client dilemma " New topic
Author

Java Bean Connectivity , EJB, JSP and .NET client dilemma

Shivade Sanjay
Greenhorn

Joined: Apr 09, 2002
Posts: 6
Hello Guys,

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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Bean Connectivity , EJB, JSP and .NET client dilemma