wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes Jasper Report  With Oracle Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Jasper Report  With Oracle Stored Procedure" Watch "Jasper Report  With Oracle Stored Procedure" New topic
Author

Jasper Report With Oracle Stored Procedure

Alan Hermin
Ranch Hand

Joined: Feb 16, 2006
Posts: 290
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 ]
Marco All
Greenhorn

Joined: Mar 05, 2009
Posts: 13
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?
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

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.


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
Marco All
Greenhorn

Joined: Mar 05, 2009
Posts: 13
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
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

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

Joined: Mar 05, 2009
Posts: 13
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
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

I don't understand, how is oraclestoredprocedure wrapped up? Is it a single class file? A zipped up archive?...
Marco All
Greenhorn

Joined: Mar 05, 2009
Posts: 13
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
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

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

Joined: Mar 05, 2009
Posts: 13
Ok, just done it. but with any result
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

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

Joined: Mar 05, 2009
Posts: 13
Yes, but until now any answer... but I'm trustful for the future Thanks Martijn!
 
Consider Paul's rocket mass heater.
 
subject: Jasper Report With Oracle Stored Procedure