Jump to content
Changes to the Jaspersoft community edition download ×

Max number of bind parameters in SQL for Jasper Server REST


Recommended Posts

Hi all

I'm using Jasper Studio 6.6.0 along with the Bitnami JasperReports Stack 7.1.0 Rev 5. Both in Windows Platforms.

I have a SQL for our Oracle database which is 400 lines long.

When the report is running in the Studio, everything is fine. The report even compiles and gets deployed into the server.

When I try to run the report from a browser, the report inputs modal is shown but an error is thrown. The log shows the error along with the complete SQL.

The bind parameters starts at 1, for example:

WHERE h.emp_num = :1

and they get incrementing as the query goes.

But then I see that when the bind parameters reachs 98, they start to be missed:

WHERE h.emp_num = ?

And that will be the reason for the error because Oracle can't understand those expresions.

Two questions:

¿How can I increase the number of bind expresions? So I can increase the limit on the numbered bind parameters.

And ...

The report just have three parameters but they are spreaded all over the query. Are there some way of avoid incrementing this bind counter for the parameters? ¿Keep they as three bindings maybe?

Thanks in advance

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...