invalid column index

[harishbabul.y]

when i am running SQL Query in oracle database is working fine. same query when i am executing in jasper soft studio i am getting invalid column index.

 

please suggest me any one.

 

Best Regards,

Harish.

[hozawa]

Working OK with me. Can't replicate your problem. You probarly have a problem with your sql or using a wrong Oracle jdbc driver (be sure to use Oracle's jdbc driver and not the bundled Tibco driver).

Try doing "SELECT * FROM <your table name>" to check if you can access data in your table.

[beekerc69]

one thing i've found helpful is to check your parameter definitions against parameter references in the SQL code.

make sure they are all accounted for. 

i'm guessing that when you run the SQL query in a SQL tool (toad, SQLdeveloper, etc) you're commenting out the lines with the $P{} parameters since they won't run in P/L SQL, so naturally the query will run fine against the database.  This is what I do.

I can't say for sure this is the soluution to every instance of this error, but as a troubleshooting step it works well for me.

[glenarvand]

Hi,

same error for me - to be precise: I am getting the error with the Oracle JDBC (7) driver in Studio Pro 621.

With the Tibco JDBC driver for Oracle I am getting another error

net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query:

WITH alloc AS ( SELECT...

The same query works when using SQLDeveloper.

Ideas for solution are very welcome!

Kind regards,

Sebastian

[glenarvand]

What worked for me was to remove all comments within the query.

see also https://community.jaspersoft.com/jasperreports-library/issues/6526

HTH.

[AngelaJKing]

Please, visit following link. this will definitely help you out. https://javarevisited.blogspot.com/2012/01/javasqlsqlexception-invalid-column.html 

[sudeep.duvvuru]

Faced Same Problem, Restarting Studio resolved everything.

**Wasted hours before doing this.