Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Jasper Report With Oracle Stored Procedure

 
Alan Hermin
Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
  • 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 ]
 
Marco All
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • 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?
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • 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
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • 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
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • 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
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Ok, just done it. but with any result
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Yes, but until now any answer... but I'm trustful for the future Thanks Martijn!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic