annotate flys-backend/README @ 5200:42bb6ff78d1b 2.9.11

Directly set the connectionInitSqls on the datasource Somehow the factory fails to set the connectionInitSqls if we add it to the dbcpProperties. So we now set it directly
author Andre Heinecke <aheinecke@intevation.de>
date Fri, 08 Mar 2013 11:48:33 +0100
parents 790353fadf30
children 95af0f3aabfb
rev   line source
164
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 For the artifact database
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 # su - postgres
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 $ createuser --no-createrole --no-superuser --pwprompt --no-createdb artifacts
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 $ createdb --encoding=UTF-8 --owner artifacts artifactsdb
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 For the flys database
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
8 # su - postgres
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
9 $ createuser --no-createrole --no-superuser --pwprompt --no-createdb flys
324e12ab7a05 Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
10 $ createdb --encoding=UTF-8 --owner flys flystest1
4765
90142c839fe5 README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 164
diff changeset
11
5054
790353fadf30 Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents: 4765
diff changeset
12
790353fadf30 Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents: 4765
diff changeset
13 Build an importer package:
790353fadf30 Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents: 4765
diff changeset
14 mvn -f pom.xml clean compile assembly:single
790353fadf30 Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents: 4765
diff changeset
15 Alternatively with oracle:
790353fadf30 Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents: 4765
diff changeset
16 mvn -f pom-oracle.xml clean compile assembly:single
790353fadf30 Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents: 4765
diff changeset
17
4765
90142c839fe5 README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 164
diff changeset
18 Standalone DateGuesser testing example:
90142c839fe5 README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 164
diff changeset
19
90142c839fe5 README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 164
diff changeset
20 mvn -e -Dexec.mainClass=de.intevation.flys.utils.DateGuesser -Dexec.args="110803" exec:java <<EOF
90142c839fe5 README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 164
diff changeset
21 110803
90142c839fe5 README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 164
diff changeset
22 EOF
90142c839fe5 README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 164
diff changeset
23

http://dive4elements.wald.intevation.org