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
Hi,

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:
org.eclipse.birt.report.engine.api.EngineException: Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: 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 ?

Regards,
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: Thu Sep 19 08:18:27 GMT 2019

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

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

Back to the top