floydg
Posts: 2052
Joined: 6/27/2004 From: Middletown, NJ Status: offline
|
quote:
ORIGINAL: BigDuke66 Just tried it with a save from the RHS mod and got this: E:\WITP Tracker>java -Xms512m -Xmx768m -jar "WitPTracker.jar" nomap Initializing WitP Tracker AE 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:54) at witptracker.Device.InsertInTable(Device.java:242) at witptracker.SaveFileReader.ReadDeviceInfo(SaveFileReader.java:1259) at witptracker.SaveFileReader.<init>(SaveFileReader.java:166) at witptracker.Main.main(Main.java:139) Insert Error code = -65 Table=Devices Values=(519,'Resource Mine/Stn',26,0,0,0,0,0,0,0,0,0,0,519,50000, 41,12,2,99,99) java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V ALUES ( 82,'RAF Hur'cn] 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:54) at witptracker.Aircraft.InsertInTable(Aircraft.java:248) at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004) at witptracker.SaveFileReader.<init>(SaveFileReader.java:157) at witptracker.Main.main(Main.java:139) Insert Error code = -11 Table=Aircraft Values=(82,'RAF Hur'cn IIdTr AT',9,1,81,25680,286,257,1610,21,2, 12,315,0,16,3,43,86,2,-128,21,21,19,17,13,4,4,8,9,30,9,43) java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V ALUES ( 84,'RAF Hur'cn] 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:54) at witptracker.Aircraft.InsertInTable(Aircraft.java:248) at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004) at witptracker.SaveFileReader.<init>(SaveFileReader.java:157) at witptracker.Main.main(Main.java:139) Insert Error code = -11 Table=Aircraft Values=(84,'RAF Hur'cn FR.IIbFB',9,1,83,28000,286,257,2010,30,1, 12,315,1000,0,1,43,85,2,-96,30,30,24,19,15,3,4,4,5,30,3,44) java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V ALUES ( 85,'RAF Hur'cn] 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:54) at witptracker.Aircraft.InsertInTable(Aircraft.java:248) at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004) at witptracker.SaveFileReader.<init>(SaveFileReader.java:157) at witptracker.Main.main(Main.java:139) Insert Error code = -11 Table=Aircraft Values=(85,'RAF Hur'cn FR.IIcFB',9,1,84,28000,286,257,1960,28,1, 12,315,1000,0,4,44,85,2,-96,28,28,23,18,13,3,4,4,5,30,3,45) java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V ALUES ( 151,'KNIL Hur'cn] 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:54) at witptracker.Aircraft.InsertInTable(Aircraft.java:248) at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004) at witptracker.SaveFileReader.<init>(SaveFileReader.java:157) at witptracker.Main.main(Main.java:139) Insert Error code = -11 Table=Aircraft Values=(151,'KNIL Hur'cn IIb Tr',11,0,150,28400,286,257,2010,30, 1,12,214,1102,3,2,42,155,2,32,30,30,22,19,14,4,4,0,0,20,2,42) java.sql.SQLException: Unexpected token: NDO in statement [INSERT INTO Aircraft VALUES ( 453,'PB2Y-3R Cor'ndo] 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:54) at witptracker.Aircraft.InsertInTable(Aircraft.java:248) at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004) at witptracker.SaveFileReader.<init>(SaveFileReader.java:157) at witptracker.Main.main(Main.java:139) Insert Error code = -11 Table=Aircraft Values=(453,'PB2Y-3R Cor'ndo XPT',4,8,451,16080,185,123,440,7,1, 32,718,11000,2,1,42,453,4,16,0,0,0,0,0,13,16,0,0,32,7,44) Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 709 >= 709 at java.util.Vector.elementAt(Unknown Source) at witptracker.Aircraft.GetAircraft(Aircraft.java:219) at witptracker.InMemoryDB.LoadStartupTables(InMemoryDB.java:130) at witptracker.Main.main(Main.java:161) E:\WITP Tracker>pause Drücken Sie eine beliebige Taste . . . I hope not but I guess that looks like something more serious. Crud. The aircraft errors are because of the quotes in the aircraft names -- easy to fix. The device error is because of the large build rate (50K per month). I can fix that, too. Please send me a save and witptracker.properties to test the fixes. Same place as usual... Floyd
|