Changeset 17290 for lang/java

Timestamp:

08/09/08 19:36:31 (4 months ago)

Author:

int128

Message:

hsqldbをサーバモードで使う設定にしてみた

Location:

lang/java/slideboard/trunk

Files:

• sql/HSQLDB Server.launch (added)
• sql/create.sql (modified) (3 diffs)
• sql/data (added)
• sql/data/test.properties (added)
• src/main/resources/jdbc.dicon (modified) (1 diff)

lang/java/slideboard/trunk/sql/create.sql

@@ -1 +1 @@
 
 CREATE TABLE post (
-        post_id integer generated by default as identity,
+        id integer generated by default as identity,
         title varchar(255) not null,
         description varchar(255) not null,
@@ -8 +8 @@
 
 CREATE TABLE author (
-        author_id integer generated by default as identity,
+        id integer generated by default as identity,
         name varchar(255) not null,
         department varchar(255) not null,
@@ -14 +14 @@
 );
 
-INSERT INTO post VALUES(1, 'Post(1)', 'This is a test post.', 0);
-INSERT INTO post VALUES(2, 'Post(2)', 'This is a test post.', 0);
-INSERT INTO post VALUES(3, 'Post(3)', 'This is a test post.', 0);
+INSERT INTO post VALUES(1, 'Post1', 'This is a test post.', 3);
+INSERT INTO post VALUES(2, 'Post2', 'This is a test post.', 2);
+INSERT INTO post VALUES(3, 'Post3', 'This is a test post.', 1);
+
+INSERT INTO author VALUES(1, 'Taro', 'My Home Security', 'taro@example.com');
+INSERT INTO author VALUES(2, 'Jiro', 'Your Home Security', 'jiro@example.com');
+INSERT INTO author VALUES(3, 'Ikzo', 'My Home Security', 'ikzo@example.com');
+
+COMMIT;

lang/java/slideboard/trunk/src/main/resources/jdbc.dicon

@@ -12 +12 @@
                 </property>
                 <property name="URL">
-                        "jdbc:hsqldb:file:"
-                                + @org.seasar.framework.util.ResourceUtil@getBuildDir('app.dicon').getCanonicalPath()
-                                + "/data/test"
+                        "jdbc:hsqldb:hsql://localhost/test"
                 </property>
                 <property name="user">"sa"</property>