JVerein

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

Bug gefunden und beseitigt.

Heiner