DO NOT REPLY [Bug 8952] New: - order of INSERTs in Ant test bookstore-data.sql

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8952>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8952

order of INSERTs in Ant test bookstore-data.sql 

           Summary: order of INSERTs in Ant test bookstore-data.sql
           Product: Turbine
           Version: 3.0
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Torque
        AssignedTo: turbine-dev@jakarta.apache.org
        ReportedBy: igouy@yahoo.com


torque 3.0 b2 ant test

In bookstore-data.sql the 
INSERT INTO author
must be before the 
INSERT INTO book 
to satisfy the referential integrity constraints


jakarta-turbine-torque # ant test

[torque-insert-sql] Executing file: /usr/share/jakarta-turbine-
torque/target/test/rttest/src/sql/bookstore-data.sql
[torque-insert-sql] Failed to execute: INSERT INTO book 
(book_id,isbn,author_id,title) VALUES (100,'unknown',100,'Book 1 - Author 1')
[torque-insert-sql] com.sap.dbtech.jdbc.exceptions.DatabaseException: SAP 
DBTech SQL: [-35] Referential integrity violated:BOOK_FK_1,TEST,BOOK

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>