Eclipse Community Forums: BIRT » Error create data set with computed column

Home » Archived » BIRT » Error create data set with computed column

Error create data set with computed column [message #206967]

Mon, 18 December 2006 05:57

Eclipse User

I try to create simple query with computed column like folowing:

select o.InsertTime/1000 myValue
from orders o

And I got an error:

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.1.1.v20060922-1058
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: General error, message from server: "Unknown table 'o' in
field list"

Its query successfully selects data in mysql console on the same database.

PS. Eclipse 3.2.1, BIRT 2.1.1.v20060926-0959

Re: Error create data set with computed column [message #207159 is a reply to message #206967]

Mon, 18 December 2006 15:47

Eclipse User

Take a look at https://bugs.eclipse.org/bugs/show_bug.cgi?id=160724

Jason

"Sergey A. Lisovoy" <s.lisovoy@spb.solidworks.ru> wrote in message
news:em5s2l$lmj$1@utils.eclipse.org...
>I try to create simple query with computed column like folowing:
>
> select o.InsertTime/1000 myValue
> from orders o
>
> And I got an error:
>
> A BIRT exception occurred.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:2.1.1.v20060922-1058
> Error Code:odaconsumer.CannotGetResultSetMetaData
> Error Message:Cannot get the result set metadata.
> SQL statement does not return a ResultSet object.
> SQL error #1: General error, message from server: "Unknown table 'o' in
> field list"
>
> Its query successfully selects data in mysql console on the same database.
>
> PS. Eclipse 3.2.1, BIRT 2.1.1.v20060926-0959

Previous Topic:	Hibernate on BIRT -Viewer Internal error problem
Next Topic:	Report Properties

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 23 17:51:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter