Eclipse Community Forums: BIRT » Upgrade to 2.2

Home » Archived » BIRT » Upgrade to 2.2 - Parameter exception

Upgrade to 2.2 - Parameter exception [message #246918]

Mon, 09 July 2007 08:02

Eclipse User

Originally posted by: didier.bathily.u-bordeaux2.fr

Hello,
I upgrade birt from 2.1.1 to 2.2 and i have this error with my reports.

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.2.0.v200706221
Error Code:odaconsumer.CannotSetStringParameter
Error Message:Cannot set the string value (0) to parameter 1
Cannot set preparedStatement parameter string value.
SQL error #1: Index de colonne non valide

They work fine in 2.1.1
Someone know what the problem?
Thanks

Re: Upgrade to 2.2 - Parameter exception [message #247099 is a reply to message #246918]

Mon, 09 July 2007 23:10

Eclipse User

Bathily Didier wrote:
> Hello,
> I upgrade birt from 2.1.1 to 2.2 and i have this error with my reports.
>
> A BIRT exception occurred.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:2.2.0.v200706221
> Error Code:odaconsumer.CannotSetStringParameter
> Error Message:Cannot set the string value (0) to parameter 1
> Cannot set preparedStatement parameter string value.
> SQL error #1: Index de colonne non valide
>
> They work fine in 2.1.1
> Someone know what the problem?
> Thanks
>
Could you please attach the log file?
The log file is at eclipse_workspace\.metadata\.log
Thanks
Qs

Re: Upgrade to 2.2 - Parameter exception [message #247137 is a reply to message #247099]

Tue, 10 July 2007 03:07

Eclipse User

Originally posted by: didier.bathily.u-bordeaux2.fr

here is the log
Thank you

!SESSION 2007-07-09 15:10:12.656
-----------------------------------------------
eclipse.buildId=I20060602-1317
java.version=1.6.0_02
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=fr_FR
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.osgi 4 0 2007-07-09 15:10:31.390
!MESSAGE While loading class
"net.sourceforge.phpeclipse.PHPeclipsePlugin$3$1", thread "Worker-2" timed
out waiting (5000ms) for thread "Worker-0" to finish starting bundle
"net.sourceforge.phpeclipse". To avoid deadlock, thread "Worker-2" is
proceeding but "net.sourceforge.phpeclipse.PHPeclipsePlugin$3$1" may not
be fully initialized.
!STACK 0
java.lang.Exception: Generated exception.
at
org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter .preFindLocalClass(EclipseLazyStarter.java:75)
at
org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLoc alClass(ClasspathManager.java:409)
at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.fin dLocalClass(DefaultClassLoader.java:188)
at
org.eclipse.osgi.framework.internal.core.BundleLoader.findLo calClass(BundleLoader.java:339)
at
org.eclipse.osgi.framework.internal.core.BundleLoader.findCl ass(BundleLoader.java:391)
at
org.eclipse.osgi.framework.internal.core.BundleLoader.findCl ass(BundleLoader.java:352)
at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loa dClass(DefaultClassLoader.java:83)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319 )
at
net.sourceforge.phpeclipse.PHPeclipsePlugin$3.run(PHPeclipse Plugin.java:1182)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
!SESSION 2007-07-10 09:01:29.609
-----------------------------------------------
eclipse.buildId=I20070625-1500
java.version=1.6.0_02
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=fr_FR
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.birt.data 4 1001 2007-07-10 09:06:26.859
!MESSAGE A BIRT exception occurred.
!STACK 0
org.eclipse.birt.data.engine.core.DataException: Cannot set the string
value (null) to parameter 1
Cannot set preparedStatement parameter string value.
SQL error #1: Index de colonne non valide

at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.h andleException(PreparedStatement.java:4234)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3886)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etString(PreparedStatement.java:3528)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2741)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2688)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.setInp utParameterBinding(DataSourceQuery.java:572)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.addPar ameterDefns(DataSourceQuery.java:345)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:257)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:352)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:230)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:486)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:161)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:142)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:141)
at
org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelp er.executeQuery(QueryExecutionHelper.java:111)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.executeQuery(DataRequestSessionImpl.java:256)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.executeQuery(DataSetProvider.java:551)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.execute(DataSetProvider.java:438)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.executeProcess(ResultSetPreviewPage.java:361)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.runUpdateResults(ResultSetPreviewPage.java:265)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.access$1(ResultSetPreviewPage.java:235)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage$4.runInUIThread(ResultSetPreviewPage.java:228)
at org.eclipse.ui.progress.UIJob$1.run(UIJob.java:94)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr onizer.java:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav a:3659)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3296)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:820 )
at org.eclipse.jface.window.Window.open(Window.java:796)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.BaseDia log.open(BaseDialog.java:95)
at
org.eclipse.birt.report.designer.internal.ui.views.data.prov iders.DataSetNodeProvider.performEdit(DataSetNodeProvider.ja va:192)
at
org.eclipse.birt.report.designer.internal.ui.views.DefaultNo deProvider.performRequest(DefaultNodeProvider.java:368)
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:597)
at
org.eclipse.birt.report.designer.ui.views.ElementAdapterInvo cationHandler.invoke(ElementAdapterInvocationHandler.java:89 )
at $Proxy0.performRequest(Unknown Source)
at
org.eclipse.birt.report.designer.internal.ui.views.actions.E ditAction.doAction(EditAction.java:80)
at
org.eclipse.birt.report.designer.internal.ui.views.actions.A bstractElementAction.run(AbstractElementAction.java:64)
at
org.eclipse.birt.report.designer.internal.ui.views.RenameLis tener.doubleClick(RenameListener.java:214)
at
org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredV iewer.java:799)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:857)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:46)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:19 3)
at
org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(S tructuredViewer.java:797)
at
org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSel ect(AbstractTreeViewer.java:1384)
at
org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSe lected(StructuredViewer.java:1173)
at
org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEven t(OpenStrategy.java:237)
at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.ja va:234)
at
org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrate gy.java:295)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3682)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3293)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:2389)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:22 19)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
at
org.eclipse.core.databinding.observable.Realm.runWithDefault (Realm.java:289)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:461)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:149)
at
org.eclipse.ui.internal.ide.application.IDEApplication.start (IDEApplication.java:106)
at
org.eclipse.equinox.internal.app.EclipseAppHandle.run(Eclips eAppHandle.java:153)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .runApplication(EclipseAppLauncher.java:106)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .start(EclipseAppLauncher.java:76)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:363)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:176)
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:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 504)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443)
at org.eclipse.equinox.launcher.Main.run(Main.java:1169)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set
preparedStatement parameter string value.
SQL error #1: Index de colonne non valide
;
java.sql.SQLException: Index de colonne non valide
at
org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:527)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.setString(OdaQuery.java:711)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3881)
... 74 more
Caused by: java.sql.SQLException: Index de colonne non valide
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:111)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:145)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:207)
at
oracle.jdbc.driver.OraclePreparedStatement.setStringInternal (OraclePreparedStatement.java:5328)
at
oracle.jdbc.driver.OraclePreparedStatement.setString(OracleP reparedStatement.java:5320)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:522)
... 76 more
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2007-07-10 09:06:26.859
!MESSAGE Plug-in Provider:Eclipse.org
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2007-07-10 09:06:26.859
!MESSAGE Plug-in Name:BIRT Data Engine
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2007-07-10 09:06:26.859
!MESSAGE Plug-in ID:org.eclipse.birt.data
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2007-07-10 09:06:26.859
!MESSAGE Version:2.2.0.v200706221
!SUBENTRY 1 org.eclipse.birt.data 4 1001 2007-07-10 09:06:26.859
!MESSAGE Error Code:odaconsumer.CannotSetStringParameter
!SUBENTRY 1 org.eclipse.birt.data 4 1001 2007-07-10 09:06:26.859
!MESSAGE Error Message:Cannot set the string value (null) to parameter 1
Cannot set preparedStatement parameter string value.
SQL error #1: Index de colonne non valide

Re: Upgrade to 2.2 - Parameter exception [message #247141 is a reply to message #247137]

Tue, 10 July 2007 03:29

Eclipse User

Originally posted by: didier.bathily.u-bordeaux2.fr

I solve the problem. in fact i didn't use the right driver for Oracle (see
it in log file).
Thank you

Previous Topic:	Data Source Properties not Immediately Available
Next Topic:	Maximum number of series to a Chart?

Goto Forum:

-=] Back to Top [=-

Current Time: Sat May 03 14:00:58 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter