• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Bear Bibeault
  • Liutauras Vilda
  • Devaka Cooray
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

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

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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'm just a poor boy, I need no sympathy, because I'm easy come, easy go, little high, little low, little ad
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!