Home » Archived » 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 07:19  |
Eclipse User |
|
|
|
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 #689283 is a reply to message #689279] |
Mon, 27 June 2011 06:32  |
| Eclipse User |
|
|
|
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 06:35] by Moderator |
|
|
Goto Forum:
Current Time: Wed Jul 23 11:15:35 EDT 2025
Powered by FUDForum. Page generated in 0.15763 seconds |
Home