Re: trouble w/ tutorial and foreign keys

From: McRib (m.agbagl..rcor.de)
Date: Mon Jul 30 2007 - 05:00:44 EDT

  • Next message: Ahmed Mohombe: "Re: DataViews heads up"

    here is the complete log - HTH:

    INFO QueryLogger: Created connection pool:
    jdbc:mysql://localhost/playground
            Driver class: com.mysql.jdbc.Driver
            Min. connections in the pool: 1
            Max. connections in the pool: 1
    INFO QueryLogger: --- will run 3 queries.
    INFO QueryLogger: Opening connection: jdbc:mysql://localhost/playground
            Login: root
            Password: *******
    INFO QueryLogger: +++ Connecting: SUCCESS.
    INFO QueryLogger: --- transaction started.
    INFO QueryLogger: Detected and installed adapter:
    org.apache.cayenne.dba.mysql.MySQLAdapter
    INFO QueryLogger: delete from PAINTING
    INFO QueryLogger: === updated 2 rows.
    INFO QueryLogger: delete from ARTIST
    INFO QueryLogger: === updated 1 row.
    INFO QueryLogger: delete from GALLERY
    INFO QueryLogger: === updated 1 row.
    INFO QueryLogger: +++ transaction committed.
    INFO QueryLogger: --- transaction started.
    INFO QueryLogger: LOCK TABLES AUTO_PK_SUPPORT WRITE
    INFO QueryLogger: SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE TABLE_NAME =
    'ARTIST'
    INFO QueryLogger: UPDATE AUTO_PK_SUPPORT SET NEXT_ID = NEXT_ID + 20 WHERE
    TABLE_NAME = 'ARTIST' AND NEXT_ID = 260
    INFO QueryLogger: UNLOCK TABLES
    INFO QueryLogger: LOCK TABLES AUTO_PK_SUPPORT WRITE
    INFO QueryLogger: SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE TABLE_NAME =
    'GALLERY'
    INFO QueryLogger: UPDATE AUTO_PK_SUPPORT SET NEXT_ID = NEXT_ID + 20 WHERE
    TABLE_NAME = 'GALLERY' AND NEXT_ID = 260
    INFO QueryLogger: UNLOCK TABLES
    INFO QueryLogger: LOCK TABLES AUTO_PK_SUPPORT WRITE
    INFO QueryLogger: SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE TABLE_NAME =
    'PAINTING'
    INFO QueryLogger: UPDATE AUTO_PK_SUPPORT SET NEXT_ID = NEXT_ID + 20 WHERE
    TABLE_NAME = 'PAINTING' AND NEXT_ID = 260
    INFO QueryLogger: UNLOCK TABLES
    INFO QueryLogger: --- will run 3 queries.
    INFO QueryLogger: INSERT INTO ARTIST (DATE_OF_BIRTH, ID, NAME) VALUES (?,
    ?, ?)
    INFO QueryLogger: [bind: '1881-10-25 00:00:00.0', 260, 'Pablo Picasso']
    INFO QueryLogger: === updated 1 row.
    INFO QueryLogger: INSERT INTO GALLERY (ID, NAME) VALUES (?, ?)
    INFO QueryLogger: [bind: 260, 'Metropolitan Museum of Art']
    INFO QueryLogger: === updated 1 row.
    INFO QueryLogger: INSERT INTO PAINTING (ARTIST_ID, GALLERY_ID, ID, NAME)
    VALUES (?, ?, ?, ?)
    INFO QueryLogger: [bind: NULL, NULL, 260, 'Gertrude Stein']
    INFO QueryLogger: === updated 1 row.
    INFO QueryLogger: [bind: NULL, NULL, 261, 'Girl Reading at a Table']
    INFO QueryLogger: === updated 1 row.
    INFO QueryLogger: +++ transaction committed.
    INFO QueryLogger: --- will run 1 query.
    INFO QueryLogger: --- transaction started.
    INFO QueryLogger: SELECT t0.NAME, t0.ARTIST_ID, t0.GALLERY_ID, t0.ID FROM
    PAINTING t0 - prepared in 7 ms.
    INFO QueryLogger: === returned 2 rows. - took 11 ms.
    INFO QueryLogger: +++ transaction committed.
    INFO QueryLogger: --- will run 1 query.
    INFO QueryLogger: --- transaction started.
    INFO QueryLogger: SELECT t0.NAME, t0.ARTIST_ID, t0.GALLERY_ID, t0.ID FROM
    PAINTING t0 WHERE UPPER(t0.NAME) LIKE UPPER(?) [bind: 'gi%']
    INFO QueryLogger: === returned 1 row. - took 32 ms.
    INFO QueryLogger: +++ transaction committed.
    INFO QueryLogger: --- will run 1 query.
    INFO QueryLogger: --- transaction started.
    INFO QueryLogger: SELECT t0.NAME, t0.ARTIST_ID, t0.GALLERY_ID, t0.ID FROM
    PAINTING t0, ARTIST t1 WHERE t0.ARTIST_ID = t1.ID AND (t1.DATE_OF_BIRTH < ?)
    [bind: '1907-01-01 00:00:00.777']
    INFO QueryLogger: === returned 0 rows. - took 16 ms.
    INFO QueryLogger: +++ transaction committed.

    -- 
    View this message in context: http://www.nabble.com/trouble-w--tutorial-and-foreign-keys-tf4163514.html#a11860076
    Sent from the Cayenne - User mailing list archive at Nabble.com.
    



    This archive was generated by hypermail 2.0.0 : Mon Jul 30 2007 - 05:01:16 EDT