Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » odaconsumer.CannotGetColumnCount
odaconsumer.CannotGetColumnCount [message #47246] Thu, 16 June 2005 12:34 Go to next message
Eclipse UserFriend
This is a multi-part message in MIME format.

------=_NextPart_000_003A_01C5726F.BF77C140
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Any idea about why this is happening and how I can fix it?

error message:

A Birt exception occurred.
Error Code:odaconsumer.CannotGetColumnCount
Error Message:Cannot get the column count.
ORA-24338: statement handle not executed

what I was doing: attempting to preview results of a simple query in =
Edit Data Set

Data Source setup: =20

Extension ID: org.eclipse.birt.report.data.oda.jdbc
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
JDBC Driver URL: jdbc:oracle:oci8:@enboss

Oracle driver jar: classes12.jar

------=_NextPart_000_003A_01C5726F.BF77C140
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Any idea about why this is happening =
and how I can=20
fix it?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>error message</U>:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; A Birt exception=20
occurred.<BR>&nbsp;&nbsp;&nbsp; Error=20
Code:odaconsumer.CannotGetColumnCount<BR>&nbsp;&nbsp;&nbsp; Error =
Message:Cannot=20
get the column count.<BR>&nbsp;&nbsp;&nbsp; ORA-24338: statement handle =
not=20
executed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>what I was doing</U>:&nbsp;&nbsp; =
attempting to=20
preview results of a simple query in Edit Data Set</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>Data Source setup</U>:&nbsp; =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; Extension ID:&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
org.eclipse.birt.report.data.oda.jdbc</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; JDBC Driver =
Class:&nbsp;=20
oracle.jdbc.driver.OracleDriver</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; JDBC Driver=20
URL:&nbsp;&nbsp;&nbsp; jdbc:oracle:oci8:@enboss</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Oracle driver jar:&nbsp; =
classes12.jar</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_003A_01C5726F.BF77C140--
Re: odaconsumer.CannotGetColumnCount [message #47284 is a reply to message #47246] Thu, 16 June 2005 12:39 Go to previous messageGo to next message
Eclipse UserFriend
This is a multi-part message in MIME format.

------=_NextPart_000_0098_01C57268.0183B060
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What was the query?
"Chris Downey" <cdowney@gmail.com> wrote in message =
news:d8s9mt$a9d$1@news.eclipse.org...
Any idea about why this is happening and how I can fix it?

error message:

A Birt exception occurred.
Error Code:odaconsumer.CannotGetColumnCount
Error Message:Cannot get the column count.
ORA-24338: statement handle not executed

what I was doing: attempting to preview results of a simple query in =
Edit Data Set

Data Source setup: =20

Extension ID: org.eclipse.birt.report.data.oda.jdbc
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
JDBC Driver URL: jdbc:oracle:oci8:@enboss

Oracle driver jar: classes12.jar

------=_NextPart_000_0098_01C57268.0183B060
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>What was the query?</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Chris Downey" &lt;<A=20
href=3D"mailto:cdowney@gmail.com">cdowney@gmail.com</A>&gt; wrote in =
message <A=20
=
href=3D"news:d8s9mt$a9d$1@news.eclipse.org">news:d8s9mt$a9d$1@news.eclips=
e.org</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Any idea about why this is happening =
and how I=20
can fix it?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>error message</U>:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; A Birt exception=20
occurred.<BR>&nbsp;&nbsp;&nbsp; Error=20
Code:odaconsumer.CannotGetColumnCount<BR>&nbsp;&nbsp;&nbsp; Error=20
Message:Cannot get the column count.<BR>&nbsp;&nbsp;&nbsp; ORA-24338:=20
statement handle not executed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>what I was doing</U>:&nbsp;&nbsp; =
attempting=20
to preview results of a simple query in Edit Data Set</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>Data Source setup</U>:&nbsp; =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; Extension =
ID:&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
org.eclipse.birt.report.data.oda.jdbc</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; JDBC Driver =
Class:&nbsp;=20
oracle.jdbc.driver.OracleDriver</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; JDBC Driver=20
URL:&nbsp;&nbsp;&nbsp; jdbc:oracle:oci8:@enboss</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Oracle driver jar:&nbsp;=20
classes12.jar</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML >

------=_NextPart_000_0098_01C57268.0183B060--
Re: odaconsumer.CannotGetColumnCount [message #47308 is a reply to message #47284] Thu, 16 June 2005 12:46 Go to previous messageGo to next message
Eclipse UserFriend
This is a multi-part message in MIME format.

------=_NextPart_000_0047_01C57271.7BD33F80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

select PROJ_NO, USER_LEVEL
from EMAAR_ACTIVE.HQ_PROJ

"Joe Rybacki" <Joe.Rybacki@dynetics.com> wrote in message =
news:d8s9um$akh$1@news.eclipse.org...
What was the query?
"Chris Downey" <cdowney@gmail.com> wrote in message =
news:d8s9mt$a9d$1@news.eclipse.org...
Any idea about why this is happening and how I can fix it?

error message:

A Birt exception occurred.
Error Code:odaconsumer.CannotGetColumnCount
Error Message:Cannot get the column count.
ORA-24338: statement handle not executed

what I was doing: attempting to preview results of a simple query =
in Edit Data Set

Data Source setup: =20

Extension ID: org.eclipse.birt.report.data.oda.jdbc
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
JDBC Driver URL: jdbc:oracle:oci8:@enboss

Oracle driver jar: classes12.jar

------=_NextPart_000_0047_01C57271.7BD33F80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><B><FONT color=3D#7f0055 size=3D2>
<P>select </B></FONT><FONT size=3D2>PROJ_NO, =
USER_LEVEL<BR></FONT><B><FONT=20
color=3D#7f0055 size=3D2>from </B></FONT><FONT=20
size=3D2>EMAAR_ACTIVE.HQ_PROJ</P></FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Joe Rybacki" &lt;<A=20
=
href=3D"mailto:Joe.Rybacki@dynetics.com">Joe.Rybacki@dynetics.com</A>&gt;=
wrote=20
in message <A=20
=
href=3D"news:d8s9um$akh$1@news.eclipse.org">news:d8s9um$akh$1@news.eclips=
e.org</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>What was the query?</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Chris Downey" &lt;<A=20
href=3D"mailto:cdowney@gmail.com">cdowney@gmail.com</A>&gt; wrote in =
message=20
<A=20
=
href=3D"news:d8s9mt$a9d$1@news.eclipse.org">news:d8s9mt$a9d$1@news.eclips=
e.org</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Any idea about why this is =
happening and how I=20
can fix it?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>error message</U>:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; A Birt exception =

occurred.<BR>&nbsp;&nbsp;&nbsp; Error=20
Code:odaconsumer.CannotGetColumnCount<BR>&nbsp;&nbsp;&nbsp; Error=20
Message:Cannot get the column count.<BR>&nbsp;&nbsp;&nbsp; =
ORA-24338:=20
statement handle not executed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>what I was =
doing</U>:&nbsp;&nbsp; attempting=20
to preview results of a simple query in Edit Data Set</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><U>Data Source setup</U>:&nbsp; =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; Extension =
ID:&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
org.eclipse.birt.report.data.oda.jdbc</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; JDBC Driver =
Class:&nbsp;=20
oracle.jdbc.driver.OracleDriver</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; JDBC Driver=20
URL:&nbsp;&nbsp;&nbsp; jdbc:oracle:oci8:@enboss</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Oracle driver jar:&nbsp;=20
classes12.jar</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BLOCKQUOTE ></BODY></HTML>

------=_NextPart_000_0047_01C57271.7BD33F80--
Re: odaconsumer.CannotGetColumnCount [message #47352 is a reply to message #47308] Thu, 16 June 2005 13:12 Go to previous message
Eclipse UserFriend
here is the stack trace from the Eclipse error log:

!SUBENTRY 1 org.eclipse.birt.report.designer.ui 4 1001 Jun 16, 2005
13:09:58.145
!MESSAGE ORA-24338: statement handle not executed

!STACK 0
java.sql.SQLException: ORA-24338: statement handle not executed

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:15 97)
at oracle.jdbc.oci8.OCIDBAccess.describe(OCIDBAccess.java:601)
at oracle.jdbc.driver.OracleStatement.describe(OracleStatement. java:4585)
at
oracle.jdbc.driver.OracleStatement.getDBDescription(OracleSt atement.java:755)
at
oracle.jdbc.driver.OracleResultSetMetaData.getColumnCount(Or acleResultSetMetaData.java:97)
at
org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData.getC olumnCount(ResultSetMetaData.java:79)
at
org.eclipse.birt.data.engine.odaconsumer.manager.OdaResultSe tMetaData.getColumnCount(OdaResultSetMetaData.java:57)
at
org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.g etColumnCount(ResultSetMetaData.java:65)
at
org.eclipse.birt.data.engine.odaconsumer.ProjectedColumns.<init >(ProjectedColumns.java:49)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oGetProjectedColumns(PreparedStatement.java:393)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:333)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1021)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:304)
at
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:245)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:465)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:379)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:171)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:137)
at
org.eclipse.birt.report.designer.internal.ui.util.DataSetMan ager.execute(DataSetManager.java:211)
at
org.eclipse.birt.report.designer.internal.ui.util.DataSetMan ager.execute(DataSetManager.java:195)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.ResultS etPreviewPage.updateResults(ResultSetPreviewPage.java:86)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.ResultS etPreviewPage$1.run(ResultSetPreviewPage.java:245)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr onizer.java:106)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav a:2749)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2434)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:668 )
at org.eclipse.jface.window.Window.open(Window.java:648)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.BaseDia log.open(BaseDialog.java:138)
at
org.eclipse.birt.report.designer.ui.actions.EditDataSetActio n.doAction(EditDataSetAction.java:59)
at
org.eclipse.birt.report.designer.internal.ui.views.actions.A bstractElementAction.run(AbstractElementAction.java:52)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:881 )
at
org.eclipse.jface.action.ActionContributionItem.handleWidget Selection(ActionContributionItem.java:915)
at
org.eclipse.jface.action.ActionContributionItem.access$2(Act ionContributionItem.java:866)
at
org.eclipse.jface.action.ActionContributionItem$7.handleEven t(ActionContributionItem.java:785)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:2772)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2431)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:1377)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1348)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:254)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:141)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplicatio n.java:96)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(Pl atformActivator.java:335)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:273)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.eclipse.core.launcher.Main.basicRun(Main.java:185)
at org.eclipse.core.launcher.Main.run(Main.java:704)
at org.eclipse.core.launcher.Main.main(Main.java:688)





"Chris Downey" <cdowney@gmail.com> wrote in message
news:d8sae3$ba8$1@news.eclipse.org...
select PROJ_NO, USER_LEVEL
from EMAAR_ACTIVE.HQ_PROJ
"Joe Rybacki" <Joe.Rybacki@dynetics.com> wrote in message
news:d8s9um$akh$1@news.eclipse.org...
What was the query?
"Chris Downey" <cdowney@gmail.com> wrote in message
news:d8s9mt$a9d$1@news.eclipse.org...
Any idea about why this is happening and how I can fix it?

error message:

A Birt exception occurred.
Error Code:odaconsumer.CannotGetColumnCount
Error Message:Cannot get the column count.
ORA-24338: statement handle not executed

what I was doing: attempting to preview results of a simple query in Edit
Data Set

Data Source setup:

Extension ID: org.eclipse.birt.report.data.oda.jdbc
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
JDBC Driver URL: jdbc:oracle:oci8:@enboss

Oracle driver jar: classes12.jar
Previous Topic:Standalone without view
Next Topic:navigation
Goto Forum:
  


Current Time: Tue Jul 15 14:35:57 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly