Closed masterpatje closed 2 years ago
masterpatje
commented
2 years ago Closing and re-opening the application after the import of a lot of .hrf files (>100) described above and now my team is gone.
And the correpsponding output.log output.log
masterpatje
commented
2 years ago Had to again download a new .hrf file.
And the strange thing is that in the comparison .hrf files all files seems to be available. But clicking them won't give a comparison (!). So it seems like the data is incorrectly imported.
masterpatje
commented
2 years ago Single .hrf file import seems to also fail. So I think in general there is some problem with importing older .hrf files.
Copied a part of the output log.
[Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: STATEMENT
Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, Statement, OwnerNotes, PlayerCategory ) VALUES(0,457607636,'2020-12-31 02:42:00','Abdelkhalek','','Sabbar',21,3,8,6,2,8,10,9,3,6,9,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,3,2,3,4,3,29500,0,12,29430,-1,1,0,2,8,8,0,14,-1,0,436,'2022-03-27 19:20:30.0',98,0,0,0,false,20,true,0.0,0,'2022-03-23 17:10:00',14.0,690594140,5, '', '', 0)
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: STATEMENT
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90)
at core.db.SpielerTable.saveSpieler(SpielerTable.java:210)
at core.db.SpielerTable.saveSpieler(SpielerTable.java:225)
at core.db.DBManager.saveSpieler(DBManager.java:571)
at core.model.HOModel.saveHRF(HOModel.java:579)
at core.file.hrf.HRFImport.
wsbrenk
commented
2 years ago @masterpatje your log is saying that column STATEMENT is not in database table SPIELER.
latest version should have created it (#1441). don't know, why it is missing. Could you please try to rerun the database update:
masterpatje
commented
2 years ago Can I also do a fresh install? Or do you want me to install v261, create a database and then import that database in v266.
although you are quite specific, I am abit unsure what you are asking me to do, so that I can provide you with test results.
wsbrenk
commented
2 years ago @masterpatje i found the error - if you make a fresh install, the error should be fixed.
wsbrenk
commented
2 years ago fix db update for ho instances which first started with v6 dev version.
masterpatje
commented
2 years ago Downloaded version v268
installation did not have any errors
1 known warning, no match to determine location, today will be the 1st league match, so after today that warning should be gone with a clean install
after downloading this week's data, I imported last week's data (5 april 2022)
got the message "HRF file succesfully included"
and 5 april 2022 is available as a comparison file
PROBLEM NOT FIXED: the file is not correctly imported
If I click the comparison file it is not comparing the files
looking at the output log I can see that the file was not correctly imported
10:41:04 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10267 table: HRF
Statement: INSERT INTO HRF ( HRF_ID, Name, Datum ) VALUES(0,'5 apr. 2022 08:48:50','2022-04-05 08:48:50.0' )
java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10267 table: HRF
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90)
at core.db.HRFTable.saveHRF(HRFTable.java:125)
at core.db.DBManager.saveHRF(DBManager.java:920)
at core.model.HOModel.saveHRF(HOModel.java:571)
at core.file.hrf.HRFImport.
10:41:05 [Error] core.training.TrainingWeekManager: It was assumed that start date will always be before next training date in database 10:41:05 [Info] core.training.TrainingWeekManager: Next week training date: 2022-04-08 01:05:00
masterpatje
commented
2 years ago Hmmm the comparison is doing something actually, maybe it is succesfully imported, I see below the player table the following:
But it is not visible in the comparison section where the players are shown, normally you would see the difference from last week indication by a + or - and the difference compared to the selected .hrf files. Most probably subtracting the field values.
wsbrenk
commented
2 years ago @masterpatje many thanks again for your great QA job!
masterpatje
commented
2 years ago @wsbrenk I appreciate that. The way you respond as a developer motivates me to do proper QA. I am very willing to test other issues, but only if they are related v6.0+. I think this version is superior to other versions and want to help making it the best version. And besides that I am an user as well, so I benefit from it directly. So a win-win.
So it would be nice if we can make this the beta version after fixing some bugs that should be out before pushing it as the beta release. Like fixing issues which could consider importing .hrf files and in skill development. I had some problems that it incorrectly calculates them, but before issueing this bug, I want to see if fixing this problem is also key to that one.
What would help me is to see which issues are considered active and related to v6.0 and a priority label if they are urgent for a beta release.
Best to you, Patrick
wsbrenk
commented
2 years ago @masterpatje it is very likely that incorrect skill calculation was caused by this bug. import of hrf files was not the main focus of last years development.
masterpatje
commented
2 years ago Yes in v269 this bug is fixed. On a fresh install and importing last week .hrf file the correct changes are shown. Well done @wsbrenk.
I will now try to add multiple .hrf files and see if also the calculation (7-weeks and full calculation works correctly). If it doesn't work as expected I will post a new bug.
I had closed the issue, but later found out that there are still some error messages in the log. Posted it below this comment.
masterpatje
commented
2 years ago Wait.. still got some errors in the output file. Functionality is working but still a few errors.
22:09:40 [Error] core.db.TeamsLogoTable: logo information not available in database for team ID=365613 22:09:40 [Error] core.gui.theme.ThemeManager: logo not found for team 365613 22:09:41 [Error] core.net.MyConnector: Failed to select a proxy java.io.IOException: Failed to select a proxy at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1234) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1128) at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:175) at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.connect(HttpsURLConnectionImpl.java:142) at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.doExecute(JDKHttpClient.java:138) at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.execute(JDKHttpClient.java:94) at com.github.scribejava.core.oauth.OAuthService.execute(OAuthService.java:114) at core.net.MyConnector.getNonCHPPWebFile(MyConnector.java:764) at core.net.MyConnector.getFileFromWeb(MyConnector.java:649) at tool.updater.UpdateHelper.download(UpdateHelper.java:26) at core.db.TeamsLogoTable.getTeamLogoFileName(TeamsLogoTable.java:87) at core.db.DBManager.getTeamLogoFileName(DBManager.java:2612) at core.gui.theme.ThemeManager.getClubLogo(ThemeManager.java:191) at core.gui.theme.ThemeManager.getSmallClubLogo(ThemeManager.java:182) at module.series.SeriesTablePanel.populateSerieTable(SeriesTablePanel.java:260) at module.series.SeriesTablePanel.changeSaison(SeriesTablePanel.java:98) at module.series.SeriesPanel.informSaisonChange(SeriesPanel.java:136) at module.series.SeriesPanel.fillSaisonCB(SeriesPanel.java:132) at module.series.SeriesPanel.initialize(SeriesPanel.java:35) at core.gui.comp.panel.LazyImagePanel.callInitialize(LazyImagePanel.java:145) at core.gui.comp.panel.LazyImagePanel$2.hierarchyChanged(LazyImagePanel.java:132) at java.desktop/java.awt.Component.processHierarchyEvent(Component.java:6793) at java.desktop/java.awt.Component.processEvent(Component.java:6412) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.Component.createHierarchyEvents(Component.java:5639) at java.desktop/java.awt.Container.createHierarchyEvents(Container.java:1474) at java.desktop/java.awt.Component.show(Component.java:1691) at java.desktop/java.awt.Component.show(Component.java:1728) at java.desktop/java.awt.Component.setVisible(Component.java:1675) at java.desktop/javax.swing.JComponent.setVisible(JComponent.java:2720) at java.desktop/javax.swing.JTabbedPane.fireStateChanged(JTabbedPane.java:422) at java.desktop/javax.swing.JTabbedPane$ModelListener.stateChanged(JTabbedPane.java:295) at java.desktop/javax.swing.DefaultSingleSelectionModel.fireStateChanged(DefaultSingleSelectionModel.java:148) at java.desktop/javax.swing.DefaultSingleSelectionModel.setSelectedIndex(DefaultSingleSelectionModel.java:79) at java.desktop/javax.swing.JTabbedPane.setSelectedIndexImpl(JTabbedPane.java:648) at java.desktop/javax.swing.JTabbedPane.setSelectedIndex(JTabbedPane.java:623) at java.desktop/javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(BasicTabbedPaneUI.java:4101) at java.desktop/javax.swing.plaf.synth.SynthTabbedPaneUI$1.mousePressed(SynthTabbedPaneUI.java:320) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6623) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4572) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: java.lang.IllegalArgumentException: protocol = https host = null at java.base/sun.net.spi.DefaultProxySelector.select(DefaultProxySelector.java:186) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1232) ... 79 more
22:09:41 [Error] core.db.TeamsLogoTable: error when trying to download logo of team ID: 1009780 https:http://res.hattrick.org/teamlogo/11/101/1010/1009780/1009780.png 22:09:41 [Error] core.gui.theme.ThemeManager: logo not found for team 1009780 22:09:41 [Error] core.net.MyConnector: Failed to select a proxy java.io.IOException: Failed to select a proxy at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1234) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1128) at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:175) at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.connect(HttpsURLConnectionImpl.java:142) at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.doExecute(JDKHttpClient.java:138) at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.execute(JDKHttpClient.java:94) at com.github.scribejava.core.oauth.OAuthService.execute(OAuthService.java:114) at core.net.MyConnector.getNonCHPPWebFile(MyConnector.java:764) at core.net.MyConnector.getFileFromWeb(MyConnector.java:649) at tool.updater.UpdateHelper.download(UpdateHelper.java:26) at core.db.TeamsLogoTable.getTeamLogoFileName(TeamsLogoTable.java:87) at core.db.DBManager.getTeamLogoFileName(DBManager.java:2612) at core.gui.theme.ThemeManager.getClubLogo(ThemeManager.java:191) at core.gui.theme.ThemeManager.getSmallClubLogo(ThemeManager.java:182) at module.series.SeriesTablePanel.populateSerieTable(SeriesTablePanel.java:260) at module.series.SeriesTablePanel.changeSaison(SeriesTablePanel.java:98) at module.series.SeriesPanel.informSaisonChange(SeriesPanel.java:136) at module.series.SeriesPanel.fillSaisonCB(SeriesPanel.java:132) at module.series.SeriesPanel.initialize(SeriesPanel.java:35) at core.gui.comp.panel.LazyImagePanel.callInitialize(LazyImagePanel.java:145) at core.gui.comp.panel.LazyImagePanel$2.hierarchyChanged(LazyImagePanel.java:132) at java.desktop/java.awt.Component.processHierarchyEvent(Component.java:6793) at java.desktop/java.awt.Component.processEvent(Component.java:6412) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.Component.createHierarchyEvents(Component.java:5639) at java.desktop/java.awt.Container.createHierarchyEvents(Container.java:1474) at java.desktop/java.awt.Component.show(Component.java:1691) at java.desktop/java.awt.Component.show(Component.java:1728) at java.desktop/java.awt.Component.setVisible(Component.java:1675) at java.desktop/javax.swing.JComponent.setVisible(JComponent.java:2720) at java.desktop/javax.swing.JTabbedPane.fireStateChanged(JTabbedPane.java:422) at java.desktop/javax.swing.JTabbedPane$ModelListener.stateChanged(JTabbedPane.java:295) at java.desktop/javax.swing.DefaultSingleSelectionModel.fireStateChanged(DefaultSingleSelectionModel.java:148) at java.desktop/javax.swing.DefaultSingleSelectionModel.setSelectedIndex(DefaultSingleSelectionModel.java:79) at java.desktop/javax.swing.JTabbedPane.setSelectedIndexImpl(JTabbedPane.java:648) at java.desktop/javax.swing.JTabbedPane.setSelectedIndex(JTabbedPane.java:623) at java.desktop/javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(BasicTabbedPaneUI.java:4101) at java.desktop/javax.swing.plaf.synth.SynthTabbedPaneUI$1.mousePressed(SynthTabbedPaneUI.java:320) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:287) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6623) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4572) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: java.lang.IllegalArgumentException: protocol = https host = null at java.base/sun.net.spi.DefaultProxySelector.select(DefaultProxySelector.java:186) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1232) ... 79 more
22:09:41 [Error] core.db.TeamsLogoTable: error when trying to download logo of team ID: 1277381 https:http://res.hattrick.org/teamlogo/13/128/1278/1277381/1277381.png 22:09:41 [Error] core.gui.theme.ThemeManager: logo not found for team 1277381 22:17:56 [Info] core.training.TrainingWeekManager: Next week training date: 2022-04-15 01:05:00
masterpatje
commented
2 years ago re-opening the application gives another error in the outpot.log file
[Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 269
[Debug] DBUpdater: Update to 601 complete but this is a development version so DBVersion will remain unchanged
[Info] HOVerwaltung: language used for interface is: Nederlands
[Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00
[Info] HOMainFrame: This is HO! version 6.0 DEV (r269), have fun!
[Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0)
[Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium)
[Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf
[Debug] RatingPredictionManager: Rebuilding RPM cache!
[Error] MyConnector: Failed to select a proxy
java.io.IOException: Failed to select a proxy
at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1234)
at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1128)
at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:175)
at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.connect(HttpsURLConnectionImpl.java:142)
at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.doExecute(JDKHttpClient.java:138)
at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.execute(JDKHttpClient.java:94)
at com.github.scribejava.core.oauth.OAuthService.execute(OAuthService.java:114)
at core.net.MyConnector.getNonCHPPWebFile(MyConnector.java:764)
at core.net.MyConnector.getFileFromWeb(MyConnector.java:649)
at tool.updater.UpdateHelper.download(UpdateHelper.java:26)
at core.db.TeamsLogoTable.getTeamLogoFileName(TeamsLogoTable.java:87)
at core.db.DBManager.getTeamLogoFileName(DBManager.java:2612)
at core.gui.theme.ThemeManager.getClubLogo(ThemeManager.java:191)
at core.gui.theme.ThemeManager.getClubLogo(ThemeManager.java:186)
at module.lineup.lineup.MatchBanner.refresh(MatchBanner.java:183)
at core.gui.RefreshManager.doRefresh(RefreshManager.java:69)
at core.gui.HOMainFrame.
[Debug] UpdateHelper: Error downloading from 'https:http://res.hattrick.org/teamlogo/11/102/1012/1011878/1011878.png': java.lang.NullPointerException: Cannot invoke "java.io.InputStream.read()" because "in" is null [Error] TeamsLogoTable: error when trying to download logo of team ID: 1011878 https:http://res.hattrick.org/teamlogo/11/102/1012/1011878/1011878.png [Error] ThemeManager: logo not found for team 1011878 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called
masterpatje
commented
2 years ago Importing another .hrf files (the week before that one) produces the following output. Again stating some errors.
[Debug] UpdateHelper: Error downloading from 'https:http://res.hattrick.org/teamlogo/11/102/1012/1011878/1011878.png': java.lang.NullPointerException: Cannot invoke "java.io.InputStream.read()" because "in" is null [Error] TeamsLogoTable: error when trying to download logo of team ID: 1011878 https:http://res.hattrick.org/teamlogo/11/102/1012/1011878/1011878.png [Error] ThemeManager: logo not found for team 1011878 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called
masterpatje
commented
2 years ago Output.log After adding a few more old .hrf files new lines [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingModel: Previous training date: TrainingPerWeek[Training date: 2022-04-08 01:05:00, Training Type: Positiespel%, Intensity: 100%, StaminaPart: 17] [Debug] FutureTrainingTable: FutureTraining table has been cleared ! [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Info] TrainingWeekManager: Next week training date: 2022-04-15 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingModel: Previous training date: TrainingPerWeek[Training date: 2022-04-08 01:05:00, Training Type: Positiespel%, Intensity: 100%, StaminaPart: 17] [Debug] FutureTrainingTable: FutureTraining table has been cleared ! [Debug] TrainingModel: Previous training date: TrainingPerWeek[Training date: 2022-04-08 01:05:00, Training Type: Positiespel%, Intensity: 100%, StaminaPart: 17] [Debug] FutureTrainingTable: FutureTraining table has been cleared !
wsbrenk
commented
2 years ago recalculation of player skills does not work after reimporting old hrf files
masterpatje
commented
2 years ago Error messages are fixed. This bug is killed.
Reactio to your comment:
recalculation of player skills does not work after reimporting old hrf files
I will post a new feature request. Maybe at the import of a .hrf file also the appropiate training can be set for past trainings.
Describe the bug Importing .hrf files leads to seemingly succesfull import, but errors in the output log.
To Reproduce Steps to reproduce the behavior: Import a lot of .hrf files (>100)
Screenshots If applicable, add screenshots to help explain your problem.
Platform information:
Additional context A couple of examples from many from the output log. 19:19:19 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: STATEMENT Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, Statement, OwnerNotes, PlayerCategory ) VALUES(1,366317202,'','Sabit','','Bozoba',25,2,8,6,1,15,3,8,2,5,2,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,2,2,2,3,4,272760,20,31,80660,-1,1,0,0,0,0,0,0,-1,0,188,'2014-11-14 18:43:17.0',100,0,0,0,false,11,false,0.0,0,'null',0.0,0,0, '', '', 0) java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: STATEMENT at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.SpielerTable.saveSpieler(SpielerTable.java:210) at core.db.SpielerTable.saveSpieler(SpielerTable.java:225) at core.db.DBManager.saveSpieler(DBManager.java:571) at core.model.HOModel.saveHRF(HOModel.java:579) at core.file.hrf.HRFImport.(HRFImport.java:92)
at core.gui.HOMainFrame.actionPerformed(HOMainFrame.java:305)
at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1028)
at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1072)
at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626)
at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389)
at java.desktop/java.awt.Component.processEvent(Component.java:6391)
at java.desktop/java.awt.Container.processEvent(Container.java:2266)
at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948)
at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575)
at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310)
at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: STATEMENT
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.ParserDQL.readSimpleColumnName(Unknown Source)
at org.hsqldb.ParserDQL.readSimpleColumnNames(Unknown Source)
at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 46 more
19:19:19 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: STATEMENT Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, Statement, OwnerNotes, PlayerCategory ) VALUES(0,398982744,'','Samuel','','Barendse',19,53,5,5,1,4,4,6,4,4,1,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,3,4,1,4,1,2700,0,12,320,-1,0,0,0,0,0,0,0,-1,0,188,'2014-11-14 18:43:17.0',100,0,0,0,false,20,true,0.0,0,'null',0.0,0,0, '', '', 0) java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: STATEMENT at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.SpielerTable.saveSpieler(SpielerTable.java:210) at core.db.SpielerTable.saveSpieler(SpielerTable.java:225) at core.db.DBManager.saveSpieler(DBManager.java:571) at core.model.HOModel.saveHRF(HOModel.java:579) at core.file.hrf.HRFImport.(HRFImport.java:92)
at core.gui.HOMainFrame.actionPerformed(HOMainFrame.java:305)
at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1028)
at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1072)
at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626)
at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389)
at java.desktop/java.awt.Component.processEvent(Component.java:6391)
at java.desktop/java.awt.Container.processEvent(Container.java:2266)
at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948)
at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575)
at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310)
at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: STATEMENT
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.ParserDQL.readSimpleColumnName(Unknown Source)
at org.hsqldb.ParserDQL.readSimpleColumnNames(Unknown Source)
at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 46 more