JasperServer on oracle

[swisssteve]

Hi,

It is not clear in the documentation if JasperServer community edition will run with oracle or only MySQL.

can anyone confirm this?

[halfer]

We have been using JasperServer Community Edition 2 and 3 with Oracle 9i and 10g. There's sometimes little problems (see one of my recent posts) but in general it works very well.

[cooperbry]

Are you using JasperServer with Oracle as your JasperServer repository?  If so, maybe you can help me?

 

So far, I've been able to create the repository in Oracle 9i using the instructions in the build help.  I've setup a JBoss server and deployed the war file per the instructions in the installation guide.  Everything seems to work correctly using the JasperServer interface, except when I try to save a report file (<>.jrxml).  I can save a datasource, image file, etc.  Just curious if I've done something wrong here?  I've included a stack trace and my database settings.  I saw a similar post in this forum with no resolution.  Unfortunately, we have no budget for pro, so, I'm trying to get community edition working.  Any help would be appreciated.

 

[cooperbry]

I solved this issue by using the updated Oracle jdbc driver library.  ojdbc5.jar

[halfer]

Glad you got it sorted out. I would have replied earlier but this forum doesn't seem to email me when I get new replies.

 

In any case I might not have been much use, as we use MySQL on the same server as JasperServer to make the setup easy to (re)deploy. In our case there would be no major advantage to transferring it to Oracle.