Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » org.eclipse.birt.report.data.oda.jdbc.JDBCException(org.eclipse.birt.report.data.oda.jdbc.JDBCException)
org.eclipse.birt.report.data.oda.jdbc.JDBCException [message #688290] Fri, 24 June 2011 11:19 Go to next message
parasu  is currently offline parasu Friend
Messages: 13
Registered: May 2011
Junior Member
Hi All,

Ive got below error while executing a query in BIRT but the same executed correctly in TOAD


A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.6.2.r262_v20110215
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:ORA-00936: missing expression

;

Thanku,
Parsuram

Re: org.eclipse.birt.report.data.oda.jdbc.JDBCException [message #688343 is a reply to message #688290] Fri, 24 June 2011 13:29 Go to previous messageGo to next message
Cyril Rognon is currently offline Cyril RognonFriend
Messages: 24
Registered: July 2010
Junior Member
Hello,

it can happen if in your query there is some special char that birt doesn't handle well or if you have wrong oracle driver and a dialect issue.

can you show the sql query text ?

regards
Cyril
Re: org.eclipse.birt.report.data.oda.jdbc.JDBCException [message #689279 is a reply to message #688343] Mon, 27 June 2011 10:21 Go to previous messageGo to next message
parasu  is currently offline parasu Friend
Messages: 13
Registered: May 2011
Junior Member
No Message Body
Re: org.eclipse.birt.report.data.oda.jdbc.JDBCException [message #689283 is a reply to message #689279] Mon, 27 June 2011 10:32 Go to previous message
parasu  is currently offline parasu Friend
Messages: 13
Registered: May 2011
Junior Member
Hi Cyril,

Please find the below example and give the suggestion related mentioned issue

Thanks in Advace
Parasuram


Example :

select distinct
K.sfield_7 Period,
R.Opportunity Opportunity,
R.BSLA BSLA,
R.Mgmnt_Structure MGMT_STRUCTURE_COUNTRY,
R.SubPandL SUB_PL,
(SELECT EMSG.English FROM EMSG, ZS_DECODE D
WHERE EMSG.ID = D.EMSG_ID AND D.Attribute_ID = 5003 AND D.Value =K.Flag_23)

Frequency,
K.sfield_8 F1,
A.Group_code F2,
B.local_acriteria_no F3,
K.string_19 F4,
K.string_20 F5,
K.string_21 F6,
K.string_7 F7,
(SELECT EMSG.English FROM EMSG, ZS_DECODE D
WHERE EMSG.ID = D.EMSG_ID AND D.Attribute_ID = 5015 AND D.Value = K.Flag_46)

Risk,
(SELECT E.English FROM ZS_Decode D, emsg E
WHERE E.ID = D.EMSG_ID
AND D.Attribute_ID = 5177
AND D.Value = K.Flag_41) WorkflowStatus,
(CASE WHEN (R.criteria1=0 OR R.criteria2=0 OR R.criteria3=0 OR R.criteria4=0

OR R.criteria5=0 OR R.criteria6=0 OR R.criteria7=0) THEN 'open' ELSE 'closed'

END) Status,
DECODE(R.criteria1,0,'No','Yes')criteria1,
DECODE(R.criteria2,0,'No','Yes')criteria2,
DECODE(R.criteria3,0,'No','Yes')criteria3,
DECODE(R.criteria4,0,'No','Yes')criteria4,
DECODE(R.criteria5,0,'No','Yes')criteria5,
DECODE(R.criteria6,0,'No','Yes')criteria6,
DECODE(R.criteria7,0,'No','Yes')criteria7
FROM
MV_view R,
Item K,
Bank B,
Acgr A
WHERE
K.type=10013
AND B.acc_no=K.acc_no
ANDK.acc_no=A.acc_no
ANDK.acc_no=R.Acc_NO
ANDK.date_20=R.End_Date

[Updated on: Mon, 27 June 2011 10:35]

Report message to a moderator

Previous Topic:Remove special characters from generated word doc
Next Topic:Ecore - oda driver : Is there an offical release ?
Goto Forum:
  


Current Time: Mon Nov 24 16:39:48 GMT 2014

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

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