Matrix Games Forums

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

Congratulations!
 
I think its an awesome tool!
 

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 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)

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

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

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

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...

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?

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...

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

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

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

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.

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

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)

Going to try the saem with a CHS one and see if its the same situation. BRB.

The tables look awesome!

Roger

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

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

Nice applications.&nbsp; 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 . . .