db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald Rosengartner" <DROSENGART...@kc.rr.com>
Subject Re: Schema producing invalid SQL
Date Fri, 03 Jan 2003 03:42:56 GMT
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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message