java.sql.SQLSyntaxErrorException: ORA-00904: "GMTSYSDATE": invalid identifier [message #1752065] |
Wed, 18 January 2017 13:15 |
Athul Shetty 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
|
|
|
Powered by
FUDForum. Page generated in 0.05066 seconds