diff options
| author | Matthew Newhook <matthew@zeroc.com> | 2008-09-16 11:07:45 -0230 |
|---|---|---|
| committer | Matthew Newhook <matthew@zeroc.com> | 2008-09-16 11:07:45 -0230 |
| commit | c92b09cb5177dfc2249d92ac15fcd2cf5533df7e (patch) | |
| tree | cb88bf4899c44f23e9907633ac7a94cc56ec7267 /java | |
| parent | add renter to the BookRentedException. (diff) | |
| download | ice-c92b09cb5177dfc2249d92ac15fcd2cf5533df7e.tar.bz2 ice-c92b09cb5177dfc2249d92ac15fcd2cf5533df7e.tar.xz ice-c92b09cb5177dfc2249d92ac15fcd2cf5533df7e.zip | |
use InnoDB storage engine
Diffstat (limited to 'java')
| -rw-r--r-- | java/demo/Database/library/BookI.java | 1 | ||||
| -rw-r--r-- | java/demo/Database/library/createTypes.sql | 8 |
2 files changed, 4 insertions, 5 deletions
diff --git a/java/demo/Database/library/BookI.java b/java/demo/Database/library/BookI.java index 01499a1e93a..a4817b6f635 100644 --- a/java/demo/Database/library/BookI.java +++ b/java/demo/Database/library/BookI.java @@ -269,7 +269,6 @@ class BookI extends _BookDisp } else { - stmt = context.prepareStatement("INSERT into customers (name) VALUES(?)", java.sql.Statement.RETURN_GENERATED_KEYS); stmt.setString(1, name); diff --git a/java/demo/Database/library/createTypes.sql b/java/demo/Database/library/createTypes.sql index cd07546b83f..ec5fc72e5c3 100644 --- a/java/demo/Database/library/createTypes.sql +++ b/java/demo/Database/library/createTypes.sql @@ -17,14 +17,14 @@ CREATE TABLE books isbn CHAR(10), title VARCHAR(255), renter_id INT -); +) ENGINE=InnoDB; DROP TABLE IF EXISTS authors_books; CREATE TABLE authors_books ( book_id INT, author_id INT -); +) ENGINE=InnoDB; DROP TABLE IF EXISTS authors; CREATE TABLE authors @@ -32,7 +32,7 @@ CREATE TABLE authors id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(255) -); +) ENGINE=InnoDB; DROP TABLE IF EXISTS customers; CREATE TABLE customers @@ -40,4 +40,4 @@ CREATE TABLE customers id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(255) -); +) ENGINE=InnoDB; |