[Wonder-disc] BugTracker Runs - But SQL Fails

[Fred S. <fh...@co...>]

Hi All,

I'm still trying to get the BugTracker app to run. I have updated now to 
all the latest tools - including JVM 1.5.0.

Now the app runs, but the FrontBase(FB) database never gets fully setup 
- only 7 tables are created (using the Create Without Drop routine), 
because of *various type* errors, which to me appear as plugin/eoaccess 
related errors.

What is strange, is the Create Without Drop routine progresses to 
*various points*, and then quits after creating 7 tables. Here are 
partial console listings:

Run #1:
20395 [main] INFO er.extensions.ERXJDBCUtilities  - Executing CREATE 
TABLE "REQ_TYPE" (    "REQ_TYPE_ID" INTEGER CONSTRAINT 
NOT_NULL_REQ_TYPE_REjava.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

and in Run #2 further downstream:

12211 [main] INFO er.extensions.ERXJDBCUtilities  - Executing CREATE 
TABLE "TEST_ITEM_STATE" (    "NAME" VARCHAR(50) CONSTRAINT 
NOT_NULL_TEST_ITEM_STATE_NAME NOT NULL,    "ID" VARCHAR(4) CONSTRAINT 
NOT_NULL_TEST_ITEM_STATE_ID NOT NULL,    "SORT_ORDER" INTEGER CONSTRAINT 
NOT_NULL_TEST_ITEM_STATE_SORT_ORDER NOT NULL)
12249 [main] ERROR er.bugtracker.BTBusinessLogic  - Can't update: 
java.sql.SQLException: Semantic error 79. Constraint name - 
NOT_NULL_TEST_ITEM_STATE_ID - exists.
java.sql.SQLException: Semantic error 79. Constraint name - 
NOT_NULL_TEST_ITEM_STATE_ID - exists.
    at 
com.frontbase.jdbc.FBJErrorMetaData.errorMessageAtIndex(FBJErrorMetaData.java:162)

Notice the first error is a native java error, but the 2nd error is 
FrontBase related error. And the app always aborts downstream at 
Creating tables: erprototypes (java.lang.reflect.InvocationTargetException).

I can run other apps w/FB. I checked the FB website and did not see any 
new plugins. Is anyone aware of any other JDBC type updates needed for 
Project Wonder? Any Ideas?

TIA
Fred

-- 

MacOS: Tiger 10.4.11
Eclipse: 3.3.1.1
WOLips: 3.3.4705
WebObjects: 5.3.3