WITPSTAFF

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

WITPSTAFF

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support >> WITPSTAFF

Page: [1]

Message

<< Older Topic Newer Topic >>

WITPSTAFF - 10/26/2010 9:48:27 AM

michelzzt

Posts: 20
Joined: 1/12/2010
From: Cognac - France
Status: offline

Hello ;
I don't why by now I am unable to initialize a newdata base with witpstff. Every time this message appears :

Could not create or initialize the database

java.sql.SQLException:Wrong data type:
java.lang.illegalArgumentException in statement[CREATE MEMORY]
TABLE"Turn2Date" ("date"DATE default'0000-00-00')

Thank you for help.

I encounter the same difficulties with windows XP or W7 64bits, my game version is 1.04.1106g

Post #: 1

RE: WITPSTAFF - 10/26/2010 1:04:21 PM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: michelzzt

Hello ;
I don't why by now I am unable to initialize a newdata base with witpstff. Every time this message appears :

Could not create or initialize the database

java.sql.SQLException:Wrong data type:
java.lang.illegalArgumentException in statement[CREATE MEMORY]
TABLE"Turn2Date" ("date"DATE default'0000-00-00')

Thank you for help.

I encounter the same difficulties with windows XP or W7 64bits, my game version is 1.04.1106g

Witpstaff has not been updated in some time. I think it lost functionality some time ago with an AE and Javapatch that caused the DB to not initialise properly. I'll stand corrected if this is not the case.
See these messages in this thread for more ...
http://www.matrixgames.com/forums/fb.asp?m=2363701
http://www.matrixgames.com/forums/fb.asp?m=2377518

The replacement is WitpTracker which you will find a link to in the Sticky section of the main forum.

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to michelzzt)

Post #: 2

RE: WITPSTAFF - 10/26/2010 2:04:50 PM

michaelm75au

Posts: 13500
Joined: 5/5/2001
From: Melbourne, Australia
Status: offline

It sounds a bit like the Java Update 18 that affect how date was interpreted.

_____________________________

Michael

(in reply to n01487477)

Post #: 3

RE: WITPSTAFF - 10/26/2010 2:07:44 PM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: michaelm
It sounds a bit like the Java Update 18 that affect how date was interpreted.

Yeah Micheal,
that's why I posted the links; I believe that if you use Java update 17 it may work ... but I thought an AE patch also rendered Staff to the Unemployment lines ... (pun intended)

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to michaelm75au)

Post #: 4

RE: WITPSTAFF - 10/26/2010 2:28:15 PM

michaelm75au

Posts: 13500
Joined: 5/5/2001
From: Melbourne, Australia
Status: offline

quote:

ORIGINAL: n01487477

quote:

ORIGINAL: michaelm
It sounds a bit like the Java Update 18 that affect how date was interpreted.

Yeah Micheal,
that's why I posted the links; I believe that if you use Java update 17 it may work ... but I thought an AE patch also rendered Staff to the Unemployment lines ... (pun intended)

Opps. didn't notice it was witpstaff. Just saw the Java reference.
I thought that it was still running under the current AE version. The Xmas patch I think caused some issue that was the last thing that was fixed in witpstaff.

_____________________________

Michael

(in reply to n01487477)

Post #: 5

RE: WITPSTAFF - 10/26/2010 4:26:18 PM

michelzzt

Posts: 20
Joined: 1/12/2010
From: Cognac - France
Status: offline

Thank you for your posts, I will try to find java update 17.
My previous save with witpstaff are still working.

I use also Witptracker but I like the ship4history included in witpstaff.

(in reply to michaelm75au)

Post #: 6

RE: WITPSTAFF - 10/27/2010 11:52:56 AM

Local Yokel

Posts: 1494
Joined: 2/4/2007
From: Somerset, U.K.
Status: offline

I like to use both Staff AND Tracker, and wasn't aware of a problem with Staff until I saw this thread.

I'm running Windows XP on a fairly ancient machine, Witp AE version 1.0.4.1106g. According to the Java Control Panel, my Java version is 6 Update 18, but I don't entirely trust that information, as I see I downloaded Update 17 some time ago, possibly to address the very problem encountered here. OTOH the Registry data for the Java Runtime does confirm that my current version is 1.6.0_18. If I did overwrite Update 18 with Update 17, then it hasn't altered the Registry's information about which version of Java I am running. And I see Java can now be updated to Update 22!

I ran a test of initialising a new Staff database for a PBEM Scenario 1 game, playing Japanese side. The database initialised correctly and I was able to load the first game turn's save file and view its data through Staff without error.

I'm therefore not sure whether there really is an incompatibility between Staff and the version of Java the OP is using. But I see no signs of changes to the game itself having led to such an incompatibility, as I think I am running the most up-to-date version of the game.

If you want to get an old version of the Java runtime, suggest http://www.oracle.com/technetwork/java/archive-139210.html is the place to go. There you can chose the version you want from the JDK/JRE - 6 dropdown list.

_____________________________

(in reply to michelzzt)

Post #: 7

RE: WITPSTAFF - 10/27/2010 12:05:45 PM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

Thanks L.Y,
I thought there was a problem initialising new games with staff because that problem with Java 18 was reported in the Staff thread some time ago... Glad to hear Staff is still working and initialising properly.

Should have tested before I posted

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to Local Yokel)

Post #: 8