Page 13 of 18
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Jan 18, 2010 5:41 pm
by morphin
Hi
i have new installation for windows 7 and WITP-AE. with WITPSTAff i have the following error for initialziing a new DB:
i use the latest java:
C:\Users\Morphin>java -version
java version "1.6.0_18"
Java(TM) SE Runtime Environment (build 1.6.0_18-b07)
Java HotSpot(TM) 64-Bit Server VM (build 16.0-b13, mixed mode)
--------------------
-------------
Could not create or initialize the databasejava.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException in statement [CREATE MEMORY TABLE "Turn2Date" ( "date" DATE default '0000-00-00']
java.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException in statement [CREATE MEMORY TABLE "Turn2Date" ( "date" DATE default '0000-00-00']
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 de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.gui.c.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.V.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
Couldn't set up a working DB template. Bad, Bad.
---------------------------------
RE: WitpStaff questions and suggestions here please (read the first post!)
Posted: Tue Jan 19, 2010 7:43 pm
by madgamer2
I am very glad I did not buy the AE game as none of this thread makes any sense to my poor old brain. Silly me I expect a game to install, run and be able ton play.
reading this thread just makes things more confusing. I planned to wait till all the bugs were fixed but in this case the game is so complicated that the more bugs fixed the more bugs show up. Maybe it has to do with creating this monster from a previous game who's hard code and game code can't deal with the new version without massive and numerous updates,patch's and hot fix's......Naw this could not be true as it is coming from a total tech moron (me)
Madgamer
RE: WitpStaff questions and suggestions here please (read the first post!)
Posted: Wed Jan 20, 2010 3:40 am
by wworld7
Madgamer,
Please don't mistake trouble getting an an add-on utility such as WitpStaff to run as a probem with WITP-AE itself.
To use an old saying, that is like comparing apples and oranges.
Add-on's often take extra effort to configure and run correctly.
RE: WitpStaff questions and suggestions here please (read the first post!)
Posted: Wed Jan 20, 2010 2:24 pm
by coxville
I would have to add that I have been playing this game for a few months now and know exactly how scary it is but that is its beauty. Play the scenarios to get the combat routines sorted and learn some basics about movement and then play the main campaign but don't expect to play it through. I have had two training starts, one lasted 30 game days the other 90 game days, using scenario 2 (I play the Japanese so this is masocistic enough as a beginner). I then regularly save and peek at what is going on i.e what is the AI doing, how accurate is my recon. These two self made tutorials along with the infinite wisdom that abounds on this site leaves me with a game that each time I pick it up amazes me more and more with its depth. If you deal with it one step at a time though and do not try to be an expert in each bit, it is amazing how quickly huge scary tasks become second nature.
Best investment I ever made
Chris
p.s are you in trouble if you go to sleep wondering whether you should go for Tojo's over Tony's...just wondered.
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Sun Jan 31, 2010 7:17 pm
by Numdydar
ORIGINAL: morphin
Hi
i have new installation for windows 7 and WITP-AE. with WITPSTAff i have the following error for initialziing a new DB:
i use the latest java:
C:\Users\Morphin>java -version
java version "1.6.0_18"
Java(TM) SE Runtime Environment (build 1.6.0_18-b07)
Java HotSpot(TM) 64-Bit Server VM (build 16.0-b13, mixed mode)
--------------------
-------------
Could not create or initialize the databasejava.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException in statement [CREATE MEMORY TABLE "Turn2Date" ( "date" DATE default '0000-00-00']
java.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException in statement [CREATE MEMORY TABLE "Turn2Date" ( "date" DATE default '0000-00-00']
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 de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.gui.c.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.V.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
Couldn't set up a working DB template. Bad, Bad.
---------------------------------
I get the same exact error. Can anyone pls tell me how to fix it or is this thread dead?
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 6:28 am
by michaelm75au
Yes, the last update to Java seems to have broken witpstaff.
My PC without version 18 update is still working, but my main development one (which did update a few days ago) has ceased to run witpstaff.
I think it is only when trying to create a new database. Original DBs and loading saves look like they still work okay.
[O/S is XP 32bit with witpstaff 0.8 and 0.7]
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 6:38 am
by Numdydar
Just great [:(]
Any ideas on how I can fit it or are we just sol? Could you supply me with the files for scenerio 1 that you say work? Thanks for the reply as at least I know it is not something I am doing wrong.
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 6:54 am
by n01487477
ORIGINAL: Numdydar
Just great [:(]
Any ideas on how I can fit it or are we just sol? Could you supply me with the files for scenerio 1 that you say work? Thanks for the reply as at least I know it is not something I am doing wrong.
Yeah,?@uninstall java and reinstall with a previous release like jdk/jre 6 update 17
http://java.sun.com/products/archive/
Dont let it update and
Then delete the DB and try again.
Michael, cannot supply you with this ... it is a java compatibility problem with witpstaff... I havent tested witpTracker yet as Im in an airport bound for sydney ...
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 7:59 am
by michaelm75au
ORIGINAL: n01487477
Michael, cannot supply you with this ... it is a java compatibility problem with witpstaff... I havent tested witpTracker yet as Im in an airport bound for sydney ...
He must coming to get me ...[:D]
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 2:15 pm
by Numdydar
Thants Damian for the response it works fine now.
For any one else here is the link to the JAVA version that worked for me
https://cds.sun.com/is-bin/INTERSHOP.en ... TypeFilter
The specific file name is jre-6u17-windows-i586 An important note is that the 64bit versions of JAVA DO NOT WORK. So even if you have a 64bit PC, you MUST use the 32 bit version of JAVA. Also, as Damian stated, do not allow the older version automaticly update Otherwise you have to uninstall it and re-install the old one again. At least until WitPStaff is fixed, unlikely at this point I would think.
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 2:46 pm
by Numdydar
This is really becoming like work. I now get the following error message
config.directory is db
Now trying plugin UPGTestPlugin
Warning: AK load cost of LCU 6753 (ETO Reinforcements) is > 32767 (49855)
Warning: AK load cost of LCU 6886 (Vladivostok Naval) is > 32767 (98972)
Got an Exception java.lang.ArrayIndexOutOfBoundsException: 2079
java.lang.ArrayIndexOutOfBoundsException: 2079
at de.retsiemuab.witpDecoder.ioreaders.a.a(Unknown Source)
at de.retsiemuab.witpDecoder.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aV.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.X.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
What file do I need to edit to fix this? I tried editing the WitP text file located in the db directory where I found the lines that caused the error but that did not work. Any ideas?
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 3:08 pm
by Nomad
I am unsure what you have done, but I would delete the db folder and reinitialize the db and see if that works. It appears to me that the db is corrupted.
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 3:43 pm
by Numdydar
I did that before I posted [:)] It comes up with the same error everytime. Thank you though for trying to help.
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 3:46 pm
by Nomad
Warning: AK load cost of LCU 6753 (ETO Reinforcements) is > 32767 (49855)
Warning: AK load cost of LCU 6886 (Vladivostok Naval) is > 32767 (98972)
Got an Exception java.lang.ArrayIndexOutOfBoundsException: 2079
The warnings should not be a problem. the exception of 2079 is one that was fixed with the WitPstaff 0.8 upgrade.
Make sure you have the latest version of Staff.
Go here to find it:
http://85.214.61.75/witp/witpStaff0.8.zip
RE: witpStaff0.8 fixes problem vs. WitpAE patch 2
Posted: Mon Feb 01, 2010 7:25 pm
by Numdydar
It is now working [:D] Thank you so much for the help.
RE: WitpStaff questions and suggestions here please
Posted: Tue Feb 02, 2010 1:53 pm
by brhugo
I installed the hotfix and confirmed the new witpDecoder2.jar file is in the correct directory. I have the C++ release required (8) and the latest version of Java. But when I try to initialize the database, I get the following error message:
java.sql.SQLException: Wrong data type:java.lanf.IllegalArgumentException in statement [CREATE MEMORY TABLE "Turn2Date" ("date" DATE default '0000-00-00']
(I type in the message since I couldn't cut-and-paste it).
If it helps, I haven't had any trouble installing and using Ae tracker.
RE: WitpStaff questions and suggestions here please
Posted: Tue Feb 02, 2010 2:07 pm
by Numdydar
See my post #250 above for the correct version of JAVA. The latest version of JAVA breaks WitPStaff
RE: WitpStaff questions and suggestions here please
Posted: Wed Feb 03, 2010 12:59 pm
by michaelm75au
I think you can set it up to use a different version of runtime Java by using a environment variable. I'll have to check my reference tomorrow.
RE: WitpStaff questions and suggestions here please
Posted: Sat Feb 06, 2010 8:44 pm
by d0mbo
Help!
When trying to initialize the database i get the following message:
RE: WitpStaff questions and suggestions here please
Posted: Sat Feb 06, 2010 8:47 pm
by d0mbo
oh i see i must use the 32 bit java version..... bummer.....
can i downgrade from 64bit to 32 bit.... anyone knows?