comparison contrib/make_flys_release/make_release.sh @ 5255:f890d315240f

Fix oracle backend configuration and allow INITSQLS statement
author Andre Heinecke <aheinecke@intevation.de>
date Tue, 12 Mar 2013 18:21:53 +0100
parents a859691ec4a0
children df7028d0cb93
comparison
equal deleted inserted replaced
5254:a859691ec4a0 5255:f890d315240f
76 BACKENDURL=${BACKENDURL:-czech-republic.atlas.intevation.de} 76 BACKENDURL=${BACKENDURL:-czech-republic.atlas.intevation.de}
77 BACKENDPORT=${BACKENDPORT:-5432} 77 BACKENDPORT=${BACKENDPORT:-5432}
78 BACKENDBACK=${BACKENDBACK:-flys_2912} 78 BACKENDBACK=${BACKENDBACK:-flys_2912}
79 BACKENDUSER=${BACKENDUSER:-flys_dami} 79 BACKENDUSER=${BACKENDUSER:-flys_dami}
80 BACKENDPASS=${BACKENDPASS:-flys_dami} 80 BACKENDPASS=${BACKENDPASS:-flys_dami}
81 INITSQLS=${INITSQLS:-}
81 82
82 OPTS=`getopt -o ?w:,t,o \ 83 OPTS=`getopt -o ?w:,t,o \
83 -l help,oracle \ 84 -l help,oracle \
84 -n $0 -- "$@"` 85 -n $0 -- "$@"`
85 86
256 if [ "$BUILD_ORACLE" = "TRUE" ]; then 257 if [ "$BUILD_ORACLE" = "TRUE" ]; then
257 # Oracle backend configuration 258 # Oracle backend configuration
258 cat > $WORK_DIR/server/conf/backend-db.xml << EOF 259 cat > $WORK_DIR/server/conf/backend-db.xml << EOF
259 <?xml version="1.0" encoding="UTF-8" ?> 260 <?xml version="1.0" encoding="UTF-8" ?>
260 <backend-database> 261 <backend-database>
261 <user>flys27</user> 262 <user>$BACKENDUSER</user>
262 <password>flys27</password> 263 <password>$BACKENDPASS</password>
263 <dialect>org.hibernatespatial.oracle.OracleSpatial10gDialect</dialect> 264 <dialect>org.hibernatespatial.oracle.OracleSpatial10gDialect</dialect>
264 <driver>oracle.jdbc.driver.OracleDriver</driver> 265 <driver>oracle.jdbc.driver.OracleDriver</driver>
265 <url>jdbc:oracle:thin:@//czech-republic.atlas.intevation.de:1521/XE</url> 266 <url>jdbc:oracle:thin:@//$BACKENDURL:$BACKENDPORT/$BACKENDBACK</url>
267 <connection-init-sqls>$INITSQLS</connection-init-sqls>
266 </backend-database> 268 </backend-database>
267 EOF 269 EOF
268 else 270 else
269 #Postgresql backend configuration 271 #Postgresql backend configuration
270 cat > $WORK_DIR/server/conf/backend-db.xml << EOF 272 cat > $WORK_DIR/server/conf/backend-db.xml << EOF
273 <user>$BACKENDUSER</user> 275 <user>$BACKENDUSER</user>
274 <password>$BACKENDPASS</password> 276 <password>$BACKENDPASS</password>
275 <dialect>org.hibernate.dialect.PostgreSQLDialect</dialect> 277 <dialect>org.hibernate.dialect.PostgreSQLDialect</dialect>
276 <driver>org.postgresql.Driver</driver> 278 <driver>org.postgresql.Driver</driver>
277 <url>jdbc:postgresql://$BACKENDURL:$BACKENDPORT/$BACKENDBACK</url> 279 <url>jdbc:postgresql://$BACKENDURL:$BACKENDPORT/$BACKENDBACK</url>
280 <connection-init-sqls>$INITSQLS</connection-init-sqls>
278 </backend-database> 281 </backend-database>
279 EOF 282 EOF
280 fi 283 fi
281 284
282 mkdir $WORK_DIR/artifactsdb 285 mkdir $WORK_DIR/artifactsdb

http://dive4elements.wald.intevation.org