June Release: WitPTracker now at 1.6!
Moderators: Joel Billings, wdolson, Don Bowen, mogami
June Release: WitPTracker now at 1.6!
Okay, the wait is over. We are now releasing the WitPTracker.
You can get the program from here: WitPTracker
Of course, it's not complete and there are some areas that we know don't work, but we wanted to get it out in the community. We will fix and enhance as needed and time permits.
There is also an e-mail address to send bug reports, suggestions, complaints, accolades, etc (even though you'll probably just post to this thread): witptracker@gmail.com
Thanks,
Floyd and Damian
You can get the program from here: WitPTracker
Of course, it's not complete and there are some areas that we know don't work, but we wanted to get it out in the community. We will fix and enhance as needed and time permits.
There is also an e-mail address to send bug reports, suggestions, complaints, accolades, etc (even though you'll probably just post to this thread): witptracker@gmail.com
Thanks,
Floyd and Damian
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
RE: WitPTracker 1.0
I hope the next version is easier to try and use. I am getting SQL errors trying to load two different savegames. They are both CHS games - not sure if that is a problem or not. But, I can not get the DB initialized.
RE: WitPTracker 1.0
I got this errors. Any clue?
Initializing WitP Tracker database.
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at witptracker.ProductionPanel$6.getValueAt(ProductionPanel.java:292)
at javax.swing.table.TableRowSorter$TableRowSorterModelWrapper.getValueA
t(Unknown Source)
at javax.swing.DefaultRowSorter$FilterEntry.getValue(Unknown Source)
at witptracker.ProductionPanel$15.include(ProductionPanel.java:911)
at javax.swing.DefaultRowSorter.include(Unknown Source)
at javax.swing.DefaultRowSorter.initializeFilteredMapping(Unknown Source
)
at javax.swing.DefaultRowSorter.sort(Unknown Source)
at javax.swing.DefaultRowSorter.setRowFilter(Unknown Source)
at witptracker.ProductionPanel.<init>(ProductionPanel.java:915)
at witptracker.GUIMain.CreateAndShowGUI(GUIMain.java:311)
at witptracker.GUIMain$3.run(GUIMain.java:386)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Initializing WitP Tracker database.
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at witptracker.ProductionPanel$6.getValueAt(ProductionPanel.java:292)
at javax.swing.table.TableRowSorter$TableRowSorterModelWrapper.getValueA
t(Unknown Source)
at javax.swing.DefaultRowSorter$FilterEntry.getValue(Unknown Source)
at witptracker.ProductionPanel$15.include(ProductionPanel.java:911)
at javax.swing.DefaultRowSorter.include(Unknown Source)
at javax.swing.DefaultRowSorter.initializeFilteredMapping(Unknown Source
)
at javax.swing.DefaultRowSorter.sort(Unknown Source)
at javax.swing.DefaultRowSorter.setRowFilter(Unknown Source)
at witptracker.ProductionPanel.<init>(ProductionPanel.java:915)
at witptracker.GUIMain.CreateAndShowGUI(GUIMain.java:311)
at witptracker.GUIMain$3.run(GUIMain.java:386)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
RE: WitPTracker 1.0
ORIGINAL: Nomad
I hope the next version is easier to try and use. I am getting SQL errors trying to load two different savegames. They are both CHS games - not sure if that is a problem or not. But, I can not get the DB initialized.
I know we've never tested with CHS. Send the save file and witptracker.properties file to witptracker@gmail.com and I'll take a look.
Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
RE: WitPTracker 1.0
ORIGINAL: emek
I got this errors. Any clue?
Initializing WitP Tracker database.
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at witptracker.ProductionPanel$6.getValueAt(ProductionPanel.java:292)
at javax.swing.table.TableRowSorter$TableRowSorterModelWrapper.getValueA
t(Unknown Source)
at javax.swing.DefaultRowSorter$FilterEntry.getValue(Unknown Source)
at witptracker.ProductionPanel$15.include(ProductionPanel.java:911)
at javax.swing.DefaultRowSorter.include(Unknown Source)
at javax.swing.DefaultRowSorter.initializeFilteredMapping(Unknown Source
)
at javax.swing.DefaultRowSorter.sort(Unknown Source)
at javax.swing.DefaultRowSorter.setRowFilter(Unknown Source)
at witptracker.ProductionPanel.<init>(ProductionPanel.java:915)
at witptracker.GUIMain.CreateAndShowGUI(GUIMain.java:311)
at witptracker.GUIMain$3.run(GUIMain.java:386)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Send me the save game file and witptracker.properties file to witptracker@gmail.com and I'll take a look.
Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
- Roger Neilson II
- Posts: 1419
- Joined: Sun Jul 16, 2006 11:16 am
- Location: Newcastle upon Tyne. England
RE: WitPTracker 1.0
Ok, have done as it says, and have created a separate folder for each game as that looks sensible. Unfortunately all my games are awaiting turns! Will give it a try when anyone responds.
Roger
Roger
RE: WitPTracker 1.0
ORIGINAL: Roger Neilson II
Ok, have done as it says, and have created a separate folder for each game as that looks sensible. Unfortunately all my games are awaiting turns! Will give it a try when anyone responds.
Roger
You should be able to load old turns (if you have them saved. I hope somebody gets this to work...
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
- Roger Neilson II
- Posts: 1419
- Joined: Sun Jul 16, 2006 11:16 am
- Location: Newcastle upon Tyne. England
RE: WitPTracker 1.0
I only have one vanilla WItp game - I screwed the bat file on that and used the previous turn and therefore according to your user guide shouldn't try to load it in again....
Roger
Will load an earlier turn. The glories of massive googlemail storage eh?
Roger
Will load an earlier turn. The glories of massive googlemail storage eh?
- Roger Neilson II
- Posts: 1419
- Joined: Sun Jul 16, 2006 11:16 am
- Location: Newcastle upon Tyne. England
RE: WitPTracker 1.0
Ok, loaded the previous turn in. Games are running on my D drive and path is correct for this standard WITP game.
Here's what I get when I run the BAT in cmd mode:
Ignore the first typo in there - duh its late here.
Can send files if you want them, but you may have plenty to look at...
Here's what I get when I run the BAT in cmd mode:
Ignore the first typo in there - duh its late here.
Can send files if you want them, but you may have plenty to look at...
- Attachments
-
- witptrackerproblem.jpg (63.43 KiB) Viewed 3638 times
RE: WitPTracker 1.0
ORIGINAL: Roger Neilson II
Ok, loaded the previous turn in. Games are running on my D drive and path is correct for this standard WITP game.
Here's what I get when I run the BAT in cmd mode:
Ignore the first typo in there - duh its late here.
Can send files if you want them, but you may have plenty to look at...
Do you have a folder named "lib" in D:\WITPTracker? In that folder should be a single file: hsqldb.jar
Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
- Roger Neilson II
- Posts: 1419
- Joined: Sun Jul 16, 2006 11:16 am
- Location: Newcastle upon Tyne. England
RE: WitPTracker 1.0
No, this is what is in my folder.....
I'm actually on googlechat and able to chat if that's easier. I'm on as my name without the II at the end.
Roger
I'm actually on googlechat and able to chat if that's easier. I'm on as my name without the II at the end.
Roger
- Attachments
-
- witptracke..contents.jpg (25.88 KiB) Viewed 3634 times
RE: WitPTracker 1.0
ORIGINAL: Roger Neilson II
No, this is what is in my folder.....
Roger -
Create a new folder called "lib" and put that hsqldb file in there.
Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
RE: WitPTracker 1.0
It gave me a whole load of -65 errors linked to data categories... and I'm unsure as to how to get a printout of the errors, I've used the start->run procedure but I can't see an error printout being created to post here.
John Dillworth: "I had GreyJoy check my spelling and he said it was fine."
Well, that's that settled then.
Well, that's that settled then.
RE: WitPTracker 1.0
ORIGINAL: Nemo121
It gave me a whole load of -65 errors linked to data categories... and I'm unsure as to how to get a printout of the errors, I've used the start->run procedure but I can't see an error printout being created to post here.
Can you capture the screen which shows the errors?
Sending me the turn file let's me see it for myself (and I can try to debug the program properly).
Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
- Roger Neilson II
- Posts: 1419
- Joined: Sun Jul 16, 2006 11:16 am
- Location: Newcastle upon Tyne. England
RE: WitPTracker 1.0
Ok, thats sort of did the trick. A sub folder called 'lib' with the hsqldb file in there. I now have the programme running. It did generate, as Nemo observed, a lot of -65 error codes, hopefully I have trapped them all here for you: As I say, its worked and am now looking at the various screens.
Roger
Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Users\Roger>d:
D:\>cd witptracker
D:\WITPTracker>witptracker.bat
D:\WITPTracker>java -jar "WitPTracker.jar"
Initializing WitP Tracker database.
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(5294,667,33,56269)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7038,667,33,62889)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7071,667,33,52959)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7211,667,33,41706)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(8350,667,33,43030)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9015,667,33,40334)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9046,667,33,54379)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9049,667,33,59579)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9141,667,33,65535)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9387,667,33,62889)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9411,667,33,52191)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9434,667,33,65529)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9462,667,33,60241)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9474,667,33,64213)
Roger
Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Users\Roger>d:
D:\>cd witptracker
D:\WITPTracker>witptracker.bat
D:\WITPTracker>java -jar "WitPTracker.jar"
Initializing WitP Tracker database.
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(5294,667,33,56269)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7038,667,33,62889)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7071,667,33,52959)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7211,667,33,41706)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(8350,667,33,43030)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9015,667,33,40334)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9046,667,33,54379)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9049,667,33,59579)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9141,667,33,65535)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9387,667,33,62889)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9411,667,33,52191)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9434,667,33,65529)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9462,667,33,60241)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(9474,667,33,64213)
- Roger Neilson II
- Posts: 1419
- Joined: Sun Jul 16, 2006 11:16 am
- Location: Newcastle upon Tyne. England
RE: WitPTracker 1.0
Going to try the saem with a CHS one and see if its the same situation. BRB.
The tables look awesome!
Roger
The tables look awesome!
Roger
- Roger Neilson II
- Posts: 1419
- Joined: Sun Jul 16, 2006 11:16 am
- Location: Newcastle upon Tyne. England
RE: WitPTracker 1.0
Ok, that got a shorter set of errors, but the programme has not initialised this time.
here's the errors:
Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Users\Roger>d:
D:\>cd mike witptracker
D:\Mike WITPTRACKER>witptracker.bat
D:\Mike WITPTRACKER>java -jar "WitPTracker.jar"
Initializing WitP Tracker database.
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7709,191,33,65527)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7880,191,33,41706)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(8201,191,33,52469)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(8328,191,33,65525)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.AirGroup.InsertSmallDelta(AirGroup.java:204)
at witptracker.AirGroup.InsertInTable(AirGroup.java:195)
at witptracker.SaveFileReader.ReadAirGroups(SaveFileReader.java:432)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:72)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=AirGroupSmallDelta Values=(1151,191,13,35000)
Exception in thread "main" java.lang.NullPointerException
at witptracker.ResourceLocation.<init>(ResourceLocation.java:46)
at witptracker.InMemoryDB.PostProcessResources(InMemoryDB.java:207)
at witptracker.InMemoryDB.LoadStartupTables(InMemoryDB.java:130)
at witptracker.Main.main(Main.java:118)
D:\Mike WITPTRACKER>
Can send the two lots if you want to see them..... but say so soon as its time for some zzzz over this side of the pond.
Roger
here's the errors:
Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Users\Roger>d:
D:\>cd mike witptracker
D:\Mike WITPTRACKER>witptracker.bat
D:\Mike WITPTRACKER>java -jar "WitPTracker.jar"
Initializing WitP Tracker database.
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7709,191,33,65527)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(7880,191,33,41706)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(8201,191,33,52469)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.Ship.InsertSmallDelta(Ship.java:301)
at witptracker.Ship.InsertInTable(Ship.java:272)
at witptracker.SaveFileReader.ReadShipInfo(SaveFileReader.java:739)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:62)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=ShipSmallDelta Values=(8328,191,33,65525)
java.sql.SQLException: Numeric value out of range
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at witptracker.Database.InsertRow(Database.java:56)
at witptracker.AirGroup.InsertSmallDelta(AirGroup.java:204)
at witptracker.AirGroup.InsertInTable(AirGroup.java:195)
at witptracker.SaveFileReader.ReadAirGroups(SaveFileReader.java:432)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:72)
at witptracker.Main.main(Main.java:104)
Insert Error code = -65
Table=AirGroupSmallDelta Values=(1151,191,13,35000)
Exception in thread "main" java.lang.NullPointerException
at witptracker.ResourceLocation.<init>(ResourceLocation.java:46)
at witptracker.InMemoryDB.PostProcessResources(InMemoryDB.java:207)
at witptracker.InMemoryDB.LoadStartupTables(InMemoryDB.java:130)
at witptracker.Main.main(Main.java:118)
D:\Mike WITPTRACKER>
Can send the two lots if you want to see them..... but say so soon as its time for some zzzz over this side of the pond.
Roger
RE: WitPTracker 1.0
Roger -
Okay, great!
The lines like:
Indicate that this ship (#5294) has 56,269 supply loaded, but the database can only handle up to 32000. Does this ship really have the capacity to load that much supply?
Floyd
Okay, great!
The lines like:
Code: Select all
Insert Error code = -65
Table=ShipSmallDelta Values=(5294,667,33,56269)
Indicate that this ship (#5294) has 56,269 supply loaded, but the database can only handle up to 32000. Does this ship really have the capacity to load that much supply?
Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
RE: WitPTracker 1.0
Nice applications. Favorites are definitely the ship info and the ac comparison pages.
I think you and Bodhi should merge DNA and figure out how to combine efforts when AE comes around . . .
I think you and Bodhi should merge DNA and figure out how to combine efforts when AE comes around . . .