Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Error create data set with computed column
Error create data set with computed column [message #206967] Mon, 18 December 2006 10:57 Go to next message
Sergey A. Lisovoy is currently offline Sergey A. LisovoyFriend
Messages: 6
Registered: July 2009
Junior Member
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 20:47 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Tue Jul 16 11:57:48 GMT 2024

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

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

Back to the top