diff options
| author | Matthew Newhook <matthew@zeroc.com> | 2008-10-06 18:10:54 -0230 |
|---|---|---|
| committer | Matthew Newhook <matthew@zeroc.com> | 2008-10-06 18:10:54 -0230 |
| commit | b2dd3e20207345ed786d3b62ff1596ca27a545e8 (patch) | |
| tree | 1152c70d3d48ca9d22cfb20f1651a654d46b7b38 /java/demo/Database/library/LibraryI.java | |
| parent | adjust config to permit anonymous clients. (diff) | |
| download | ice-b2dd3e20207345ed786d3b62ff1596ca27a545e8.tar.bz2 ice-b2dd3e20207345ed786d3b62ff1596ca27a545e8.tar.xz ice-b2dd3e20207345ed786d3b62ff1596ca27a545e8.zip | |
Fix bug with queryByAuthors. Multiple rows could be returned for multi-author books.
Diffstat (limited to 'java/demo/Database/library/LibraryI.java')
| -rw-r--r-- | java/demo/Database/library/LibraryI.java | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/java/demo/Database/library/LibraryI.java b/java/demo/Database/library/LibraryI.java index 894fb9e65d9..8cd4c21ef7b 100644 --- a/java/demo/Database/library/LibraryI.java +++ b/java/demo/Database/library/LibraryI.java @@ -106,8 +106,8 @@ class LibraryI extends _LibraryDisp sb.append(")"); stmt = context.prepareStatement( - "SELECT COUNT(*) FROM books INNER JOIN authors_books ON books.id=authors_books.book_id AND " + - sb.toString()); + "SELECT COUNT(DISTINCT ID) FROM books INNER JOIN authors_books ON books.id=authors_books.book_id AND " + + sb.toString()); rs = stmt.executeQuery(); boolean next = rs.next(); assert next; @@ -119,7 +119,8 @@ class LibraryI extends _LibraryDisp // Execute the query. stmt = context.prepareStatement( - "SELECT * FROM books INNER JOIN authors_books ON books.id=authors_books.book_id AND " + sb.toString()); + "SELECT DISTINCT ID, ISBN, TITLE, RENTER_ID FROM books INNER JOIN authors_books ON " + + "books.id=authors_books.book_id AND " + sb.toString()); rs = stmt.executeQuery(); next = rs.next(); assert next; |