Error with query call

[Matthew Birk]

Hello,

I have just installed VARS on my Mac and am having an issue with getting Query to work. 

macOS 10.14.6

freshly installed JDK8

Whenever I enter a term and hit the search button, I get the following error message in the terminal:

2020-04-01 12:00:19 INFO [AWT-EventQueue-0] vars.query.ui.QueryFrame - Starting query

2020-04-01 12:00:19 DEBUG [vars.query.ui.db.QueryActionImpl-1585742419599] org.mbari.sql.QueryableImpl - Opening JDBC connection:varsuser @ jdbc:derby://localhost:1527/VARS;create=true

2020-04-01 12:00:19 INFO [vars.query.ui.db.QueryActionImpl-1585742419599] vars.query.ui.db.QueryActionUI - Query has been completed

2020-04-01 12:00:19 ERROR [AWT-EventQueue-0] java.awt.EventDispatchThread - Exception in thread [AWT-EventQueue-0]

java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

at java.util.ArrayList.rangeCheck(ArrayList.java:657)

at java.util.ArrayList.get(ArrayList.java:433)

at vars.query.results.QueryResults.toRowOrientedArray(QueryResults.java:88)

at vars.query.ui.QueryResultsTable$QueryResultsTableModel.<init>(QueryResultsTable.java:171)

at vars.query.ui.QueryResultsTable.<init>(QueryResultsTable.java:57)

at vars.query.ui.QueryResultsFrame.getDataTable(QueryResultsFrame.java:211)

at vars.query.ui.QueryResultsFrame.getDataScrollPane(QueryResultsFrame.java:198)

at vars.query.ui.QueryResultsFrame.getDataPanel(QueryResultsFrame.java:182)

at vars.query.ui.QueryResultsFrame.getTabbedPane(QueryResultsFrame.java:499)

at vars.query.ui.QueryResultsFrame.getJContentPane(QueryResultsFrame.java:273)

at vars.query.ui.QueryResultsFrame.initialize(QueryResultsFrame.java:536)

at vars.query.ui.QueryResultsFrame.<init>(QueryResultsFrame.java:121)

at vars.query.ui.db.QueryActionUI$QueryResultsListener.lambda$propertyChange$0(QueryActionUI.java:292)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

at java.awt.EventQueue.access$500(EventQueue.java:97)

at java.awt.EventQueue$3.run(EventQueue.java:709)

at java.awt.EventQueue$3.run(EventQueue.java:703)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

Any help???

Thanks so much!

Matthew

[Brian Schlining]

Hi Matt,

If you zip up your entire VARS directory and put it somewhere I can get it, I can run a test against your database to see what’s going on.

Cheers

-- B
Brian Schlining

--
You received this message because you are subscribed to the Google Groups "mbari-vars" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mbari-vars+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mbari-vars/f13332a4-e081-4961-978b-c6b0c09088b3%40googlegroups.com.