• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
  • Mikalai Zaikin

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

Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
"To do good, you actually have to do something." -- Yvon Chouinard
a bit of art, as a gift, the permaculture playing cards
    Bookmark Topic Watch Topic
  • New Topic