cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From McRib <m.agba...@arcor.de>
Subject Re: trouble w/ tutorial and foreign keys
Date Mon, 30 Jul 2007 09:00:44 GMT

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.


Mime
View raw message