Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » java.sql.SQLSyntaxErrorException: ORA-00904: "GMTSYSDATE": invalid identifier(java.sql.SQLSyntaxErrorException: ORA-00904: "GMTSYSDATE": invalid identifier)
java.sql.SQLSyntaxErrorException: ORA-00904: "GMTSYSDATE": invalid identifier [message #1752065] Wed, 18 January 2017 13:15
Athul Shetty is currently offline Athul ShettyFriend
Messages: 2
Registered: February 2011
Junior Member

We have simple BIRT report which runs on birt_viewer 4.2.1, which has SQL query with GMTSYSDATE but this fails with below error on Oracle 12c DB. Same query works fine with Oracle 11g. Query used to test is "select GMTSYSDATE,SYSDATE from dual".

Same query runs with out any issues on SQL*Plus and JDBC with 12c driver and 12c DB. This issue comes only when we run with birt-viewer. We are using 12c JDBC (ojdbc7.jar) driver.

Error Snippet: Cannot get the result set metadata. SQL statement does not return a ResultSet object.
SQL error #1:ORA-00904: "GMTSYSDATE": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "GMTSYSDATE": invalid identifier

I have attached the file which has complete exception stack trace.

Could you please help ?

Athul Shetty
Previous Topic:WebViewerExample won't load with Tomcat 8.5
Next Topic:Unable to set the Autofit Row Height for Row: 121
Goto Forum:

Current Time: Wed Jan 22 22:29:07 GMT 2020

Powered by FUDForum. Page generated in 0.01865 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top