• 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 ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Jasper Report With Oracle Stored Procedure

 
Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi all..
i want to know if i can connect jasper reports, with oracle stored procedure?and how?
i think if this is not supported by jasper, then it is some thing like Disadvantage for it...

regrads
[ March 12, 2007: Message edited by: Ala'a Hendi ]
 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I know, it's an old topic... but it's always the first result of a google search... so:

there's a project that called oraclestoredprocedure on jasperforge.org.

The problem is to use it I have problems because I get an error like this



any hint?
 
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It's missing the org.jasperforge.jaspersoft.demo.PlSqlQueryExecuterFactory class. I'd check your relevant JAR to see if that class exists, if not I'd contact Jasperforge to see where its gone/what it should be replaced with.
 
Marco All
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes, it's true... but I've builded the project oraclestoredprocedure, I've copied the build/class folder to iReport one, I've added the classpath to the PlSqlQueryExecuterFactory class into the option of iReport but... still that error!
 
Martijn Verburg
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you post your classpath and where you have the JAR file located? Also perhaps iReport needs to have the classpath set somewhere inside of it in a setting (I haven't used it).
 
Marco All
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
the problem is that in the project oraclestoredprocedure there's any jar file, but only the PlSqlQueryExecuterFactory.class
(I'm not at work now...I can't send you the classpath)
 
Martijn Verburg
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I don't understand, how is oraclestoredprocedure wrapped up? Is it a single class file? A zipped up archive?...
 
Marco All
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
this is the link to the project: http://jasperforge.org/plugins/project/project_home.php?group_id=173

is a repository to checkout with svn...
 
Martijn Verburg
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ah OK, hmm there's no mention of this problem in the various docs for the project. Can you perhaps try building the project, creating a JAR for the single class file and then referencing that JAR in the classpath?
 
Marco All
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok, just done it. but with any result
 
Martijn Verburg
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hmm, in that case I'm afraid I'm not sure how else I can help . Have you tried the JasperForge forums?
 
Marco All
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes, but until now any answer... but I'm trustful for the future Thanks Martijn!
 
reply
    Bookmark Topic Watch Topic
  • New Topic