Eclipse Community Forums: BIRT » 'Select *' query always generates error

Home » Archived » BIRT » 'Select *' query always generates error

'Select *' query always generates error [message #198044]

Fri, 27 October 2006 12:08

Eclipse User

Originally posted by: goykhmanster.gmail.com

Hi

I am having a problem with BIRT report viewer.
Any time my query text has 'select *' in it (select all columns), i get
the following error on the report page:

Exception in:
ReportEngineService.runReport( )

Error happended while running the report

I am using BIRT report viewer 2.0.2 with Eclipse 3.1.

Has any of you ever got this problem? Is there a workaround? I would
appreciate any help. Thanks in advance.

Re: 'Select *' query always generates error [message #198211 is a reply to message #198044]

Sun, 29 October 2006 21:44

Eclipse User

Can you get any error when you preview result in dataset editor page?Could
you please attach the detailed exception trace on the report page?

Thanks
Mingxia
"Boris" <goykhmanster@gmail.com> wrote in message
news:11b4d5f698e226f26f1e099cab48009c$1@www.eclipse.org...
> Hi
>
> I am having a problem with BIRT report viewer. Any time my query text has
> 'select *' in it (select all columns), i get the following error on the
> report page:
>
> Exception in:
> ReportEngineService.runReport( )
>
> Error happended while running the report
>
> I am using BIRT report viewer 2.0.2 with Eclipse 3.1.
>
> Has any of you ever got this problem? Is there a workaround? I would
> appreciate any help. Thanks in advance.
>

Re: 'Select *' query always generates error [message #198348 is a reply to message #198211]

Mon, 30 October 2006 10:48

Eclipse User

Originally posted by: goykhmanster.gmail.com

This is the error from dataset editor:

An unexpected internal exception occurred.Please see log for detail.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Designer UI
Plug-in ID:org.eclipse.birt.report.designer.ui
Version:2.0.2
Error Code:Error.GUIException.invokedByUnexpectedException
Error Message:IClob.getSubString()

Re: 'Select *' query always generates error [message #198385 is a reply to message #198348]

Mon, 30 October 2006 21:24

Eclipse User

Boris,
It seems that your table contains Clob column....Could you please tell me
the database and jdbc driver you used?

Thanks
Mingxia
"Boris" <goykhmanster@gmail.com> wrote in message
news:898e2534c4d11aab9bf4bbe108ace096$1@www.eclipse.org...
> This is the error from dataset editor:
>
> An unexpected internal exception occurred.Please see log for detail.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Designer UI
> Plug-in ID:org.eclipse.birt.report.designer.ui
> Version:2.0.2
> Error Code:Error.GUIException.invokedByUnexpectedException
> Error Message:IClob.getSubString()
>
>
>
>

Re: 'Select *' query always generates error [message #198438 is a reply to message #198385]

Tue, 31 October 2006 13:24

Eclipse User

Originally posted by: bgoykhman.hotmail.com

Hmm... Thanks for pointing that out...

I am using Oracle Thin driver. Should i use OCI driver instead?

Re: 'Select *' query always generates error [message #198594 is a reply to message #198438]

Tue, 31 October 2006 22:34

Eclipse User

Hi Boris,
Oracle Thin driver should also support Clob datatype. Maybe you could try
the latest version of Birt. BTW, could you provide the detailed error log
information in Error Log perspective? Thanks a lot.

Mingxia

"Boris" <bgoykhman@hotmail.com> wrote in message
news:ff9ab5f83da359b299c945aef911337e$1@www.eclipse.org...
> Hmm... Thanks for pointing that out...
>
> I am using Oracle Thin driver. Should i use OCI driver instead?
>

Re: 'Select *' query always generates error [message #198642 is a reply to message #198594]

Wed, 01 November 2006 13:24

Eclipse User

Originally posted by: bgoykhman.hotmail.com

Error 2006-10-31 14:30:29.196 Error Message:IClob.getSubString()
Error 2006-10-31 14:30:29.196 Error
Code:Error.GUIException.invokedByUnexpectedException
Info 2006-10-31 14:30:29.196 Version:2.0.2
Info 2006-10-31 14:30:29.196 Plug-in ID:org.eclipse.birt.report.designer.ui
Info 2006-10-31 14:30:29.196 Plug-in Name:BIRT Designer UI
Info 2006-10-31 14:30:29.196 Plug-in Provider:Eclipse.org

Previous Topic:	ODA Extension
Next Topic:	Storing custom metadata in rptdesign file?

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jun 10 16:16:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter