Skip to main content



      Home
Home » Archived » BIRT » Oracle DB access Exception
Oracle DB access Exception [message #12018] Tue, 01 March 2005 15:13 Go to next message
Eclipse UserFriend
Originally posted by: asinha.vitria.com

I added oracle jdbc driver to the available drivers by adding the jar to the
odaconfig.xml as mentioned in one of the posts earlier. I created new
DataSource and a new Data set. everything seemed to be good while going
through the wizard but after I finished the dataset, it gave me this
exception.

org.eclipse.birt.data.engine.core.DataException occurred
Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
A JDBC Exception occured: ORA-01003: no statement parsed

ORA-01003: no statement parsed

The statement in the DataSet editor is simple.
SELECT "SA"."CLAIM"."PATIENT$VTOID",

"SA"."CLAIM"."DOCTOR",

"SA"."CLAIM"."PROCEDUREDATE",

"SA"."CLAIM"."CLAIMAMOUNT",

"SA"."CLAIM"."COVEREDAMOUNT",

"SA"."CLAIM"."STATUS",

"SA"."CLAIM"."CLAIMDOCUMENT"

FROM "SA"."CLAIM"

Can anyone help?

-Ayon
Re: Oracle DB access Exception [message #14062 is a reply to message #12018] Thu, 03 March 2005 21:51 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: onefolder.sjtu.edu.cn

Hi,

Please check out lastest CVS code to do test. This bug has been fixed one
day before.

Thanks,
Mars

"Ayon Sinha" <asinha@vitria.com> wrote in message
news:d02iev$3cq$1@www.eclipse.org...
> I added oracle jdbc driver to the available drivers by adding the jar to
the
> odaconfig.xml as mentioned in one of the posts earlier. I created new
> DataSource and a new Data set. everything seemed to be good while going
> through the wizard but after I finished the dataset, it gave me this
> exception.
>
> org.eclipse.birt.data.engine.core.DataException occurred
> Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
> Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
> Error Message:Cannot get the result set metadata.
> A JDBC Exception occured: ORA-01003: no statement parsed
>
> ORA-01003: no statement parsed
>
> The statement in the DataSet editor is simple.
> SELECT "SA"."CLAIM"."PATIENT$VTOID",
>
> "SA"."CLAIM"."DOCTOR",
>
> "SA"."CLAIM"."PROCEDUREDATE",
>
> "SA"."CLAIM"."CLAIMAMOUNT",
>
> "SA"."CLAIM"."COVEREDAMOUNT",
>
> "SA"."CLAIM"."STATUS",
>
> "SA"."CLAIM"."CLAIMDOCUMENT"
>
> FROM "SA"."CLAIM"
>
> Can anyone help?
>
> -Ayon
>
>
Re: Oracle DB access Exception [message #14079 is a reply to message #14062] Fri, 04 March 2005 00:44 Go to previous message
Eclipse UserFriend
Originally posted by: asinha.vitria.com

I cannot afford timewise to be on the bleeding edge. I will have to wait for
the next build. Thanks for letting me know that, I've indeed hit a bug
rather than user-error.
-Ayon
"Mars" <onefolder@sjtu.edu.cn> wrote in message
news:d08j3g$u0e$2@www.eclipse.org...
> Hi,
>
> Please check out lastest CVS code to do test. This bug has been fixed one
> day before.
>
> Thanks,
> Mars
>
> "Ayon Sinha" <asinha@vitria.com> wrote in message
> news:d02iev$3cq$1@www.eclipse.org...
> > I added oracle jdbc driver to the available drivers by adding the jar to
> the
> > odaconfig.xml as mentioned in one of the posts earlier. I created new
> > DataSource and a new Data set. everything seemed to be good while going
> > through the wizard but after I finished the dataset, it gave me this
> > exception.
> >
> > org.eclipse.birt.data.engine.core.DataException occurred
> > Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
> > Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
> > Error Message:Cannot get the result set metadata.
> > A JDBC Exception occured: ORA-01003: no statement parsed
> >
> > ORA-01003: no statement parsed
> >
> > The statement in the DataSet editor is simple.
> > SELECT "SA"."CLAIM"."PATIENT$VTOID",
> >
> > "SA"."CLAIM"."DOCTOR",
> >
> > "SA"."CLAIM"."PROCEDUREDATE",
> >
> > "SA"."CLAIM"."CLAIMAMOUNT",
> >
> > "SA"."CLAIM"."COVEREDAMOUNT",
> >
> > "SA"."CLAIM"."STATUS",
> >
> > "SA"."CLAIM"."CLAIMDOCUMENT"
> >
> > FROM "SA"."CLAIM"
> >
> > Can anyone help?
> >
> > -Ayon
> >
> >
>
>
Previous Topic:Deployment and calculation examples
Next Topic:Oracle support?
Goto Forum:
  


Current Time: Sat May 10 02:38:13 EDT 2025

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

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

Back to the top