June Release: WitPTracker now at 1.6!

Gary Grigsby's strategic level wargame covering the entire War in the Pacific from 1941 to 1945 or beyond.

Moderators: Joel Billings, wdolson, Don Bowen, mogami

Post Reply
floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

June Release: WitPTracker now at 1.6!

Post by floydg »

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
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Coach Z
Posts: 576
Joined: Tue Jul 31, 2007 8:38 pm
Location: New York

RE: WitPTracker 1.0

Post by Coach Z »

Congratulations!
 
I think its an awesome tool!
 
ZUCK
User avatar
Nomad
Posts: 7273
Joined: Wed Sep 05, 2001 8:00 am
Location: West Yellowstone, Montana

RE: WitPTracker 1.0

Post by 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.
emek
Posts: 90
Joined: Thu Nov 16, 2000 10:00 am
Location: London

RE: WitPTracker 1.0

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

floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker 1.0

Post by floydg »

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.
floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker 1.0

Post by floydg »

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.
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: WitPTracker 1.0

Post by 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
Image
floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker 1.0

Post by floydg »

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.
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: WitPTracker 1.0

Post by Roger Neilson II »

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?
Image
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: WitPTracker 1.0

Post by 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:





Image

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
witptrackerproblem.jpg (63.43 KiB) Viewed 3635 times
Image
floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker 1.0

Post by floydg »

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:





Image

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.
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: WitPTracker 1.0

Post by Roger Neilson II »

No, this is what is in my folder.....



Image

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
witptracke..contents.jpg (25.88 KiB) Viewed 3631 times
Image
floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker 1.0

Post by floydg »

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.
User avatar
Nemo121
Posts: 5828
Joined: Fri Feb 06, 2004 11:15 am
Contact:

RE: WitPTracker 1.0

Post by 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.
John Dillworth: "I had GreyJoy check my spelling and he said it was fine."
Well, that's that settled then.
floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker 1.0

Post by floydg »

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.
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: WitPTracker 1.0

Post by Roger Neilson II »

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)
Image
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: WitPTracker 1.0

Post by Roger Neilson II »

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

The tables look awesome!

Roger
Image
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: WitPTracker 1.0

Post by Roger Neilson II »

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
Image
floydg
Posts: 2053
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker 1.0

Post by floydg »

Roger -

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.
User avatar
Crimguy
Posts: 1408
Joined: Fri Aug 15, 2003 6:42 pm
Location: Cave Creek, AZ

RE: WitPTracker 1.0

Post by Crimguy »

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 . . .
________________________
www.azcrimes.com
<sig removed because I'm a bandwidth hog>
Post Reply

Return to “War In The Pacific - Struggle Against Japan 1941 - 1945”