Mercurial > dive4elements > river
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 |