halfer

Many thanks Lucian - that is most helpful. I will pass this over to our Java chap and see if we can make use of the general approach.

Hi, thanks for your response. Although you are using a Netbeans-based iReport, would I be right in suggesting this would work with the regular iReport application? As previously indicated my knowledge of Java is pretty limited but I am pretty hardy in giving things a go where necessary. I shall take a look at Barcode4J - thanks for the tip. Using an image variable sounds like a good idea - at least one does not have to edit the JRXML file manually to get this to work! (for our users I think this would be considered too complex a step for production workflow - only programmers would be able to edit barcodes). Is the renderer to call this library trivial? If not, would you be prepared to share some of your code? Any further hints for this Java dunce would be appreciated!

Thanks for your reply, Lucian, much appreciated. Having iReport support is pretty important for us (though conceivably we could run all of our JRXML reports through an XML filter that "fixes up" the barcode thing I suppose). However this sounds like a bit of a hassle so I think we'll stick with what iReport gives us. Is there somewhere I can put forward SVG support inside iReports as a suggested feature? Meanwhile is using PNG instead of JPEG easy to achieve in JasperReports, or would I have to change some code? I have a Java-developing colleague who can advise me on this sort of stuff, but I suspect I would actually have to do the work, and I am not a Java developer... :o) I wonder also whether you know of the status of the Barbeque project? It looks like work has stalled on it. If this is the case, do you think that iReports/JasperReports may choose to move to other render engines anyway, in due course?

One other item, which is not nearly so important, is that the background of the barcode (snapshotted directly from iReport PDF output) is quite noisy and the resolution is quite blocky. I wonder if JPEG has been used as an interim output format? On this topic I'd like to remove the noisiness and it would be even better if we could use SVG or some other vector format as an interim format, so that the end result is rendered in the PDF with no resolution limitations.

Hi all Using both iReport or JasperServer I am trying to fix some problems with our barcode output. We use Tomcat 6 and the latest version of Barbeque, version 1.5beta1. I am somewhat concerned that this might be a problem with Barbeque, and that the Barbeque project may have been abandoned (the bug tracker has plenty of unresolved bugs and the last one fixed was November 2007). Firstly we are experiencing a heavy underline in the barcode. This appears to be a fault that has been raised a number of times on the project site. There are a few code resolutions to try - but I was wondering if any JasperServer users had any experience with sorting this out? Links are here, here, here and here. The last item suggests that the bug has been fixed, but it clearly hasn't! Ideally there would be a Property to set in iReport to fix this, but I reckon I might have to get my hands dirty and recompile it. Has anyone experienced this, first of all, and if so can any pointers be offered?

If you want to call reports using an arbitrary connection, this is not supported directly in JasperServer at present. However I discovered a fairly elegant workaround that you may be interested in.

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.

jbchurn wrote: Hi, Thanks for your advice and I will consider it. Between, since you use Oracle as JasperServer core database before, can you advise me how to generate the sql script for Oracle database? Sorry, you misread my post. We've never used Oracle as the JasperServer core database. I see in the other post you've referenced that you are rebuilding the server - honestly it looks more trouble than it's worth... use MySQL. Why are you so keen to use Oracle anyway?

Apologies for delayed reply - I don't believe I received a notification on it. As far as I know, the data source was set up in the same way. We got around this by calling the stored procedure first, from our web application, then redirecting the browser to the generator URI, which employed a view rather than a stored procedure. To be honest it feels like a better architecture this way, although if anyone knows why the connections have suddenly changed to read-only, I'd be interested to know why that happens! Thanks for your reply, Sherman, btw - much appreciated.

(Incidentally for the benefit of future readers, please use a sensible title for your posts. It is not helpful when reading through search results to encounter a title that does not relate at all to the content of the message. Thanks)

I received a "transaction is read-only" error through Oracle on a particular report after upgrading from JS2 to JS3. It turns out that the report used a stored procedure which wrote to temporary tables, which you are not allowed to do in a r/o connection. Hence I suspect you are (a) using a stored proc, and (b) doing a write operation in that procedure. I presume that JS3 uses a r/o connection to the server by default, but you might be able to ask here how to open a connection that allows write ops as well. Failing that you could always rethink your approach so that you only execute read operations in your sql?

Sorry, that path of the required lib should have been "iReport.jar/it/businesslogic/ireport/barcode/BcImage.class", but the forum ate my backslashes. It also does not reveal a submit button when editing posts (and I get JavaScript errors if I use IE etc...).

Thanks for this pointer, although the solution only partly worked for us. We use iReports 3.0.0 and Jasper Server 3, both in the Windows environment. As well as the Barbeque library, we've found that barcodes need "iReport.jaritbusinesslogicireportbarcodeBcImage.class" as well. We have therefore copied the iReports jar from version 3.0.0 of iReports into the "./webapps/jasperserver/WEB-INF/lib" folder. This now works a treat! Does anyone know incidentally whether there is a better way to do this? I am not keen to have added a 7.5Mb file to the lib folder, but then I am also unkeen to start deleting things from the iReports.jar archive, unless I know it is completely safe to do. Does Tomcat load the whole file into memory, or does it just load what it needs anyway? Thanks all!

We are using an Oracle PL/SQL stored procedure inside a report on Jasper Server 3. The procedure writes some data to a global temporary table and then does a select on it to return records through an OUT cursor. This works in JS 2. However in JS3 we get a big stack trace, and part of the error is: java.sql.SQLException: ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction ORA-06512: at "LOGWEB.REPORT_PACKAGE", line 236 ORA-06512: at line 1 A colleague of mine has recommended that we use Oracle Collections to get around this, rather than INSERTs to the global temporary table. I proposed an alternative where we added some switches to the JDBC data source defined in JasperServer to force it to be read/write but neither of us are very comfortable with this. Has anyone encountered this issue before, and might be able to offer some good practise advice on it? Thanks.

I've mentioned this on another thread just now, but thought I would add the same sentiment here. I can see why you would want to move the JasperServer core database to your existing db platform, but my guess is that it's more trouble than it's worth. We use JasperServer + MySQL on a server just for the basic reporting server, and then connect to Oracle sitting on a separate server. You should find it will run more quickly configured like this anyway, since JasperServer then does not have to make db calls to a separate server (or if you are running Oracle on the same box as JasperServer then you haven't reached a performance ceiling anyway).

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.

I have not used the internals of JasperServer in this way, so can't offer direct advice on that. But I've used the SOAP API a fair bit and it works very well indeed. If you get stuck on this question, you could always implement an interface in a web language of your choice, which will of course generate your reports with as much or as little authentication as you want.

Some earlier questions on this thread appeared to be connected to switching out the use of MySQL for another database. In most cases, I would say - just leave the default JasperServer tables in MySQL, and then add the ability to connect to other databases. For example we have a dedicated JasperServer server, using MySQL for the basic install. We have then added the necessary jar files to be able to connect to Oracle 9i and 10g, with most reports being based off SQL queries, and one from a PL/SQL query. We found no compelling reason to switch the base install tables to Oracle too.

(Note: If you thank people like swood when they give you advice, they are more likely to help you again). If you can find a way to bridge between ASP and Java, you could install JasperReports on your web server and create reports directly... however I think that would be making life difficult for yourself. Use the web services approach instead, as swood says. We have a PHP web server and a JasperServer server, and use the SOAP mechanism to generate reports and retrieve them back to the web server, so they can be sent to the user.

In relation to question 2, ad-hoc connections are not supported through the SOAP interface. See my earlier question here on how I solved this: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=40116

Sorry, I should have said Jasper Server *Community Edition* works fine for us. We don't use Professional Edition.

Jasper Server works fine for us with 9i and 10g.

OK, image attachments don't appear to work here. You'll have to take my word for it :o)

The GIF appears to have corrupted on your end. Trying again...

Hi all We are running Jasper Server 2 and trying to switch it to Jasper Server 3, and during this process have run into what we think is a bug with both versions. We are using a report containing a stored procedure, thus: {call REPORT_PACKAGE.PALLET_LABEL($P{SCHEDULE_ID}, $P{cursor} )} -- where 'SCHEDULE_ID' is a promptable input parameter and 'cursor' is a non-promptable output parameter. We have found that if we deploy this through the JS plugin in iReport 2.0.5 or iReport 3.0.0, and point the JRXML in the report package to the report on the server, and the same with the data source, it all works fine. However, if we try to edit the report using the web interface, and step through to the "Data Source" section, the drop-down list of sources in the repository is empty. We have found that if a non-stored procedure is added in its place, then the list of sources populates fine, which implies that the server scans the query inside the report and takes actions depending on the contents. I attach a screenshot to illustrate the problem. We have solved the problem in the meantime by resetting the data source to use via iReport, but perhaps the core devs may be interested in taking a look at this issue?