db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lach, Thierry" <Thierry.L...@bbdodetroit.com>
Subject RE: Schema producing invalid SQL
Date Fri, 03 Jan 2003 21:56:42 GMT
It appears that you are getting a size on the CC_TYPE date column in
ORDERS.  I don't think mysql allows a length on a date column.  I'd
guess you have a wrong datatype there.

Also, try adding 'required="true"' to the ARTICLE_TYPE column in
MISC_ARTICLE.

-----Original Message-----
From: Donald Rosengartner [mailto:DROSENGARTNER@kc.rr.com] 
Sent: Thursday, January 02, 2003 10:43 PM
To: turbine-torque-user@jakarta.apache.org
Subject: Re: Schema producing invalid SQL


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
View raw message