Skip to main content



      Home
Home » Archived » BIRT » Error with PostgreSQL Data Sets
Error with PostgreSQL Data Sets [message #13082] Thu, 03 March 2005 07:41 Go to next message
Eclipse UserFriend
Hi All,

Have just installed the M1 release of BIRT and it's looking very
promising. Great work!

I'm trying to do some reporting against a PostgreSQL 7.3 database. I've
installed the most recent Postgres JDBC Type 3 driver following the
instructions in the "Installing a JDBC driver" thread and I can now
create Data Sets.

However, when editing the Data Set and clicking on any of Filters, Ouput
Columns or Preview Results I get the following error:

"Cannot get the column count.

Reason: org.eclipse.birt.data.engine.core.DataException occurred
Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount

Details:

Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
Error Message:Cannot get the column count.
ResultSetMetaData can't be null."

Any ideas?

Thanks,

Rich
Re: Error with PostgreSQL Data Sets [message #13257 is a reply to message #13082] Thu, 03 March 2005 16:30 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: roman.levandovsky.guest-tek.com

I have encountered the same problem in my installation as well.
Is there anything else we are supposed to do in order to get Postgres
working with BIRT?

Roman.

news.eclipse.org wrote:

> Hi All,

> Have just installed the M1 release of BIRT and it's looking very
> promising. Great work!

> I'm trying to do some reporting against a PostgreSQL 7.3 database. I've
> installed the most recent Postgres JDBC Type 3 driver following the
> instructions in the "Installing a JDBC driver" thread and I can now
> create Data Sets.

> However, when editing the Data Set and clicking on any of Filters, Ouput
> Columns or Preview Results I get the following error:

> "Cannot get the column count.

> Reason: org.eclipse.birt.data.engine.core.DataException occurred
> Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount

> Details:

> Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
> Error Message:Cannot get the column count.
> ResultSetMetaData can't be null."

> Any ideas?

> Thanks,

> Rich
Re: Error with PostgreSQL Data Sets [message #14046 is a reply to message #13257] Thu, 03 March 2005 21:47 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: onefolder.sjtu.edu.cn

Hi,

Can you download latest code from CVS to do test? This bug has been fixed
serveral days before. If you still have any problem please let me know.

Thanks,
Mars

"Roman Levandovsky" <roman.levandovsky@guest-tek.com> wrote in message
news:d07vku$8vq$1@www.eclipse.org...
> I have encountered the same problem in my installation as well.
> Is there anything else we are supposed to do in order to get Postgres
> working with BIRT?
>
> Roman.
>
> news.eclipse.org wrote:
>
> > Hi All,
>
> > Have just installed the M1 release of BIRT and it's looking very
> > promising. Great work!
>
> > I'm trying to do some reporting against a PostgreSQL 7.3 database. I've
> > installed the most recent Postgres JDBC Type 3 driver following the
> > instructions in the "Installing a JDBC driver" thread and I can now
> > create Data Sets.
>
> > However, when editing the Data Set and clicking on any of Filters, Ouput
> > Columns or Preview Results I get the following error:
>
> > "Cannot get the column count.
>
> > Reason: org.eclipse.birt.data.engine.core.DataException occurred
> > Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
>
> > Details:
>
> > Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
> > Error Message:Cannot get the column count.
> > ResultSetMetaData can't be null."
>
> > Any ideas?
>
> > Thanks,
>
> > Rich
>
>
Re: Error with PostgreSQL Data Sets [message #14129 is a reply to message #14046] Fri, 04 March 2005 06:29 Go to previous messageGo to next message
Eclipse UserFriend
Mars,

Thanks for that! All works perfectly now with last night's build
N20050303 -- btw for other people working with Postgres, that nightly
build contains the latest Postgres JDBC driver so it all works
'out-of-the-box' now.

Cheers,
Rich

Mars wrote:
> Hi,
>
> Can you download latest code from CVS to do test? This bug has been fixed
> serveral days before. If you still have any problem please let me know.
>
> Thanks,
> Mars
>
> "Roman Levandovsky" <roman.levandovsky@guest-tek.com> wrote in message
> news:d07vku$8vq$1@www.eclipse.org...
>
>>I have encountered the same problem in my installation as well.
>>Is there anything else we are supposed to do in order to get Postgres
>>working with BIRT?
>>
>>Roman.
>>
>>news.eclipse.org wrote:
>>
>>
>>>Hi All,
>>
>>>Have just installed the M1 release of BIRT and it's looking very
>>>promising. Great work!
>>
>>>I'm trying to do some reporting against a PostgreSQL 7.3 database. I've
>>>installed the most recent Postgres JDBC Type 3 driver following the
>>>instructions in the "Installing a JDBC driver" thread and I can now
>>>create Data Sets.
>>
>>>However, when editing the Data Set and clicking on any of Filters, Ouput
>>>Columns or Preview Results I get the following error:
>>
>>>"Cannot get the column count.
>>
>>>Reason: org.eclipse.birt.data.engine.core.DataException occurred
>>>Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
>>
>>>Details:
>>
>>>Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
>>>Error Message:Cannot get the column count.
>>>ResultSetMetaData can't be null."
>>
>>>Any ideas?
>>
>>>Thanks,
>>
>>>Rich
>>
>>
>
>
Re: Error with PostgreSQL Data Sets [message #14231 is a reply to message #14129] Fri, 04 March 2005 16:29 Go to previous message
Eclipse UserFriend
Originally posted by: roman.levandovsky.guest-tek.com

Indeed, everything seems to work.

Roman.

news.eclipse.org wrote:

> Mars,

> Thanks for that! All works perfectly now with last night's build
> N20050303 -- btw for other people working with Postgres, that nightly
> build contains the latest Postgres JDBC driver so it all works
> 'out-of-the-box' now.

> Cheers,
> Rich

> Mars wrote:
>> Hi,
>>
>> Can you download latest code from CVS to do test? This bug has been fixed
>> serveral days before. If you still have any problem please let me know.
>>
>> Thanks,
>> Mars
>>
>> "Roman Levandovsky" <roman.levandovsky@guest-tek.com> wrote in message
>> news:d07vku$8vq$1@www.eclipse.org...
>>
>>>I have encountered the same problem in my installation as well.
>>>Is there anything else we are supposed to do in order to get Postgres
>>>working with BIRT?
>>>
>>>Roman.
>>>
>>>news.eclipse.org wrote:
>>>
>>>
>>>>Hi All,
>>>
>>>>Have just installed the M1 release of BIRT and it's looking very
>>>>promising. Great work!
>>>
>>>>I'm trying to do some reporting against a PostgreSQL 7.3 database. I've
>>>>installed the most recent Postgres JDBC Type 3 driver following the
>>>>instructions in the "Installing a JDBC driver" thread and I can now
>>>>create Data Sets.
>>>
>>>>However, when editing the Data Set and clicking on any of Filters, Ouput
>>>>Columns or Preview Results I get the following error:
>>>
>>>>"Cannot get the column count.
>>>
>>>>Reason: org.eclipse.birt.data.engine.core.DataException occurred
>>>>Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
>>>
>>>>Details:
>>>
>>>>Error Code:DATA_EXCEPTION_odaconsumer.CannonGetColumnCount
>>>>Error Message:Cannot get the column count.
>>>>ResultSetMetaData can't be null."
>>>
>>>>Any ideas?
>>>
>>>>Thanks,
>>>
>>>>Rich
>>>
>>>
>>
>>
Previous Topic:running a BIRT report from a tomcat server
Next Topic:Custom oda data source
Goto Forum:
  


Current Time: Wed Jul 16 22:24:02 EDT 2025

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

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

Back to the top