exceptions on running tutorial
Hi,
Attempting to eval this product, but run across this after my initial session (I saved my data from a straight-forward tutorial 1 run-through, and then get this exception trace)
Any clues what might be happening (I reproduced this after a reinstall; running under WinXP SP2 if that matters); obviously this is jdbc related, not sure of a workaround?
(From the log file)
An error occurred while executing the SQL statement. The error was Table not found in statement [SELECT * FROM scrapingsession].
java.sql.SQLException: Table not found in statement [SELECT * FROM scrapingsession]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:302)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:317)
at com.screenscraper.data.DScrapingSession.getAllScrapingSessions(DScrapingSession.java:234)
at com.screenscraper.business.BScrapingSession.getAllScrapingSessions(BScrapingSession.java:173)
at com.screenscraper.scraper.ScrapingSessionManager.loadScrapingSessions(ScrapingSessionManager.java:1155)
at com.screenscraper.controller.ControllerMain.main(ControllerMain.java:504)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:159)
at java.lang.Thread.run(Unknown Source)
An error occurred while executing the SQL statement. The error was Table not found in statement [SELECT le FROM control].
java.sql.SQLException: Table not found in statement [SELECT le FROM control]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:302)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:317)
at com.screenscraper.data.DScrapingSession.getLE(DScrapingSession.java:909)
at com.screenscraper.business.BScrapingSession.getLE(BScrapingSession.java:656)
at com.screenscraper.util.General.validate(General.java:1867)
at com.screenscraper.scraper.ScrapingServer.
at com.screenscraper.controller.ControllerMain.startServers(ControllerMain.java:612)
at com.screenscraper.controller.ControllerMain.main(ControllerMain.java:536)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:159)
at java.lang.Thread.run(Unknown Source)
An error occurred while executing the SQL statement. The error was Table not found in statement [SELECT pv FROM control].
java.sql.SQLException: Table not found in statement [SELECT pv FROM control]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:302)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:317)
at com.screenscraper.data.DScrapingSession.getPV(DScrapingSession.java:858)
at com.screenscraper.business.BScrapingSession.getPV(BScrapingSession.java:608)
at com.screenscraper.util.General.validate(General.java:1873)
at com.screenscraper.scraper.ScrapingServer.
at com.screenscraper.controller.ControllerMain.startServers(ControllerMain.java:612)
at com.screenscraper.controller.ControllerMain.main(ControllerMain.java:536)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:159)
at java.lang.Thread.run(Unknown Source)
An error occurred while executing the SQL statement. The error was Table not found in statement [SELECT le FROM control].
java.sql.SQLException: Table not found in statement [SELECT le FROM control]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:302)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:317)
at com.screenscraper.data.DScrapingSession.getLE(DScrapingSession.java:909)
at com.screenscraper.data.DScrapingSession.setPV(DScrapingSession.java:871)
at com.screenscraper.business.BScrapingSession.getPV(BScrapingSession.java:621)
at com.screenscraper.util.General.validate(General.java:1873)
at com.screenscraper.scraper.ScrapingServer.
at com.screenscraper.controller.ControllerMain.startServers(ControllerMain.java:612)
at com.screenscraper.controller.ControllerMain.main(ControllerMain.java:536)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:159)
at java.lang.Thread.run(Unknown Source)
exceptions on running tutorial
Thanks, that seems to have solved it (running the alpha)
exceptions on running tutorial
Hi,
Unfortunately, it appears as though your database has become corrupted. There are a few possible causes, but the most likely is probably a firewall that would be blocking a port or two that screen-scraper needs.
In our latest alpha version of screen-scraper we check for any port conflicts. What would you think about re-installing, upgrading to the latest alpha, then taking another shot at this? Here are the steps I'd recommend:
1. Using Windows Task Manager, ensure you have no java.exe or javaw.exe processes running. Kill any that are (that you know don't correspond to some other app you might be running).
2. Un-install screen-scraper.
3. Delete the screen-scraper folder from your "Program Files" directory.
4. Install the latest public release of screen-scraper (most likely the one you already downloaded).
5. Upgrade your screen-scraper instance by following the instructions here: [url]http://blog.screen-scraper.com/2006/11/14/version-27220a-of-screen-scraper-available/[/url].
Hopefully that helps to root out the issue. Feel free to reply back if we can be of further assistance.
Kind regards,
Todd Wilson