Mercurial > dive4elements > framework
changeset 271:aa9f2f5ff032
flys/issue75: fixed doc and schema to make H2 work again.
artifacts/trunk@2059 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 06 Jun 2011 14:00:38 +0000 |
| parents | 89f6de49803d |
| children | 2ce31a9414ff |
| files | ChangeLog README artifact-database/doc/schema-h2.sql |
| diffstat | 3 files changed, 18 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/ChangeLog Fri Jun 03 06:37:23 2011 +0000 +++ b/ChangeLog Mon Jun 06 14:00:38 2011 +0000 @@ -1,3 +1,11 @@ +2011-06-06 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + flys/issue75 + + * artifact-database/doc/schema-h2.sql: Fixed SQL syntax error in trigger creation. + + * README: Adjusted to use new lib versions. + 2011-06-03 Ingo Weinzierl <ingo@intevation.de> * artifacts-common/src/main/java/de/intevation/artifacts/common/utils/ClientProtocolUtils.java:
--- a/README Fri Jun 03 06:37:23 2011 +0000 +++ b/README Mon Jun 06 14:00:38 2011 +0000 @@ -1,9 +1,13 @@ Create a new H2 database for usage in the artifact database: -$ java -cp `find ~/.m2/ -name h2\*.jar` org.h2.tools.RunScript \ - -user USER \ - -password PASSWORD \ - -url jdbc:h2:artifact-database/doc/example-conf/artifacts.db \ - -script artifact-database/doc/schema-h2.sql +$ mkdir testdb +$ for i in h2-1.3.152 artifact-database-1.0-SNAPSHOT artifacts-common-1.0-SNAPSHOT log4j-1.2.14 ; do +> export CLASSPATH=$CLASSPATH:`find ~/.m2/ -name $i.jar` +> done + +$ java org.h2.tools.RunScript \ +> -url jdbc:h2:`readlink -f testdb`/artifacts.db \ +> -script artifact-database/doc/schema-h2.sql +
--- a/artifact-database/doc/schema-h2.sql Fri Jun 03 06:37:23 2011 +0000 +++ b/artifact-database/doc/schema-h2.sql Mon Jun 06 14:00:38 2011 +0000 @@ -51,7 +51,7 @@ ); CREATE TRIGGER collections_access_update_trigger AFTER UPDATE - ON TABLE artifacts FOR EACH ROW + ON artifacts FOR EACH ROW CALL "de.intevation.artifactdatabase.h2.CollectionAccessUpdateTrigger"; COMMIT;