Probleme mit der Suchfunktion

[manuelibt]

Hallo,

mit diesem Thema wurde ich vom jameica Support hier hin verwiesen.

Ich kann seit dem letzten Update nicht mehr in den Datensätzen suchen.

Hier ist das Log der letzten Suche:

[Tue Jan 28 20:42:52 CET 2014][ERROR][de.willuhn.jameica.gui.internal.parts.SearchPart.doSearch] error while opening search result
java.rmi.RemoteException: unable to init iterator. statement: prep40: select KURSTEILNEHMER.* from KURSTEILNEHMER where LOWER(name) LIKE ? OR LOWER(vzweck1) LIKE ? OR blz LIKE ? OR konto LIKE ? {1: '%XXX%', 2: '%XXX%', 3: '%XXX%', 4: '%XXX%'}; nested exception is:
org.h2.jdbc.JdbcSQLException: Unerlaubter Wert "5" für Parameter "parameterIndex"
Invalid value "5" for parameter "parameterIndex" [90008-172]
at de.willuhn.datasource.db.DBIteratorImpl.init(DBIteratorImpl.java:237)
at de.willuhn.datasource.db.DBIteratorImpl.hasNext(DBIteratorImpl.java:252)
at de.jost_net.JVerein.search.KursteilnehmerSearchProvider.search(KursteilnehmerSearchProvider.java:64)
at de.willuhn.jameica.search.SearchResult.getResult(SearchResult.java:49)
at de.willuhn.jameica.gui.internal.parts.SearchResultPart$Provider.getChildren(SearchResultPart.java:334)
at de.willuhn.jameica.gui.internal.parts.SearchResultPart$Plugin.add(SearchResultPart.java:214)
at de.willuhn.jameica.gui.internal.parts.SearchResultPart$Plugin.access$200(SearchResultPart.java:191)
at de.willuhn.jameica.gui.internal.parts.SearchResultPart.init(SearchResultPart.java:110)
at de.willuhn.jameica.gui.internal.parts.SearchResultPart.<init>(SearchResultPart.java:50)
at de.willuhn.jameica.gui.internal.parts.SearchPart.doSearch(SearchPart.java:180)
at de.willuhn.jameica.gui.internal.parts.SearchPart.access$100(SearchPart.java:49)
at de.willuhn.jameica.gui.internal.parts.SearchPart$2.keyTraversed(SearchPart.java:114)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Control.traverse(Unknown Source)
at org.eclipse.swt.widgets.Control.translateTraversal(Unknown Source)
at org.eclipse.swt.widgets.Control.doCommandBySelector(Unknown Source)
at org.eclipse.swt.widgets.Display.windowProc(Unknown Source)
at org.eclipse.swt.internal.cocoa.OS.objc_msgSendSuper(Native Method)
at org.eclipse.swt.widgets.Widget.callSuper(Unknown Source)
at org.eclipse.swt.widgets.Widget.superKeyDown(Unknown Source)
at org.eclipse.swt.widgets.Widget.keyDown(Unknown Source)
at org.eclipse.swt.widgets.Control.keyDown(Unknown Source)
at org.eclipse.swt.widgets.Display.windowProc(Unknown Source)
at org.eclipse.swt.internal.cocoa.OS.objc_msgSendSuper(Native Method)
at org.eclipse.swt.widgets.Widget.callSuper(Unknown Source)
at org.eclipse.swt.widgets.Widget.windowSendEvent(Unknown Source)
at org.eclipse.swt.widgets.Shell.windowSendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.windowProc(Unknown Source)
at org.eclipse.swt.internal.cocoa.OS.objc_msgSendSuper(Native Method)
at org.eclipse.swt.widgets.Display.applicationSendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.applicationProc(Unknown Source)
at org.eclipse.swt.internal.cocoa.OS.objc_msgSend(Native Method)
at org.eclipse.swt.internal.cocoa.NSApplication.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.willuhn.jameica.gui.GUI.loop(GUI.java:827)
at de.willuhn.jameica.gui.GUI.init(GUI.java:310)
at de.willuhn.jameica.system.Application.init(Application.java:148)
at de.willuhn.jameica.system.Application.newInstance(Application.java:90)
at de.willuhn.jameica.Main.main(Main.java:78)
Caused by: org.h2.jdbc.JdbcSQLException: Unerlaubter Wert "5" für Parameter "parameterIndex"
Invalid value "5" for parameter "parameterIndex" [90008-172]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.getInvalidValueException(DbException.java:215)
at org.h2.jdbc.JdbcPreparedStatement.setParameter(JdbcPreparedStatement.java:1338)
at org.h2.jdbc.JdbcPreparedStatement.setObject(JdbcPreparedStatement.java:451)
at de.willuhn.datasource.db.DBIteratorImpl.init(DBIteratorImpl.java:219)
... 43 more

Kann von euch jemand etwas damit anfangen oder hat ähnliche Probleme?
Grüße Manuel

[heiner]

Bug gefunden und beseitigt.

Heiner