As you can see from close inspection of the output, there are 4 sql files being acted upon(should be two).
I renamed the database to 'fishing' in my properties file and schema to be inline with the datsource changes being made, hence new filenames. These errors do not reflect current schema conditions. Merely cleaning up the $torque-home\src\sql directory and rebuilding has resolved this. *********************************************** insert-sql: [torque-sql-exec] Our new url -> jdbc:mysql://localhost:3306/fishing [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\id-table-schema.sql [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\project-schema.sql [torque-sql-exec] Failed to execute: CREATE TABLE ORDERS ( ORDER_ID INTEGER NOT NULL AUTO_INCRE MENT, ORDER_DATE DATE NOT NULL, PRIORITY VARCHAR (5), AUTOBILL INTEGER, TERM INTEGER default -1 , BEGIN_DATE DATE NOT NULL, CC_TYPE DATE (10), CC_NUM BIGINT, CC_EXPIRE DATE, CC_NAME VARCHAR ( 75), FKCUSTOMER_ID INTEGER, PRIMARY KEY(ORDER_ID), FOREIGN KEY (FKCUSTOMER_ID) REFERENCES CUSTO MER (CUSTOMER_ID) ) [torque-sql-exec] java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near '(10), CC_NUM BIGINT, CC_EXPIRE DATE, CC_NAME VARCHAR (75), FKCUSTOMER_ID INTEGER' at line 1 [torque-sql-exec] Failed to execute: CREATE TABLE MISC_ARTICLE ( ARTICLE_ID INTEGER NOT NULL AU TO_INCREMENT, ARTICLE_TYPE VARCHAR (40), P_1 VARCHAR (250) NOT NULL, P_2 VARCHAR (250), P_3 VAR CHAR (250), P_4 VARCHAR (250), P_5 VARCHAR (250), IMAGE_DIR VARCHAR (70) NOT NULL, IMAGE_1 VARC HAR (30), IMAGE_2 VARCHAR (30), IMAGE_3 VARCHAR (30), BG_IMAGE VARCHAR (30), LINK_1 VARCHAR (15 0), APPROVED INTEGER, ADDED DATE, FKPOSTED_BY VARCHAR (50) NOT NULL, PRIMARY KEY(ARTICLE_ID,ART ICLE_TYPE), FOREIGN KEY (FKPOSTED_BY) REFERENCES GFEUSER (USER_NAME) ) [torque-sql-exec] java.sql.SQLException: General error: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead [torque-sql-exec] 66 of 68 SQL statements executed successfully [torque-sql-exec] Our new url -> jdbc:mysql://localhost:3306/fishing [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\fishing-schema.sql [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\fishing-schema-idtable-ini t.sql [torque-sql-exec] 78 of 80 SQL statements executed successfully
