This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi,
I am trying to set up a standalone BIRT server on Apache Tomcat to directly connect to Maximo database using normal JDBC instead of the typical scripted data source for embedded Maximo BIRT. The jdbc connection is tested fine without error. I can see the Maximo Oracle schema and the tables in the dataset query view, but when I tried to use the query builder to build the report query, I can not get the output columns and preview the query. The error said that the SQL statement does not return a resultset object. Oracle error code is like ORA-00911. I tried different qualifier and including schema options to no avail.
At the same time, I have no issue to build the query based on the BIRT sample database or connecting to my mysql or other data source.
Does anyone have any experience on this?
Thanks.