harishbabul.y Posted November 16, 2015 Share Posted November 16, 2015 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. Link to comment Share on other sites More sharing options...
hozawa Posted November 17, 2015 Share Posted November 17, 2015 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. Link to comment Share on other sites More sharing options...
beekerc69 Posted November 20, 2015 Share Posted November 20, 2015 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. Link to comment Share on other sites More sharing options...
glenarvand Posted February 1, 2018 Share Posted February 1, 2018 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 errornet.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 Link to comment Share on other sites More sharing options...
glenarvand Posted February 1, 2018 Share Posted February 1, 2018 What worked for me was to remove all comments within the query.see also https://community.jaspersoft.com/jasperreports-library/issues/6526HTH. Link to comment Share on other sites More sharing options...
AngelaJKing Posted November 27, 2019 Share Posted November 27, 2019 Please, visit following link. this will definitely help you out. https://javarevisited.blogspot.com/2012/01/javasqlsqlexception-invalid-column.html Link to comment Share on other sites More sharing options...
sudeep.duvvuru Posted October 19, 2021 Share Posted October 19, 2021 Faced Same Problem, Restarting Studio resolved everything.**Wasted hours before doing this. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now