changeset 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 0c45b8797baa
files contrib/make_flys_release/make_release.sh
diffstat 1 files changed, 6 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/contrib/make_flys_release/make_release.sh	Tue Mar 12 17:09:25 2013 +0100
+++ b/contrib/make_flys_release/make_release.sh	Tue Mar 12 18:21:53 2013 +0100
@@ -78,6 +78,7 @@
 BACKENDBACK=${BACKENDBACK:-flys_2912}
 BACKENDUSER=${BACKENDUSER:-flys_dami}
 BACKENDPASS=${BACKENDPASS:-flys_dami}
+INITSQLS=${INITSQLS:-}
 
 OPTS=`getopt -o ?w:,t,o \
      -l help,oracle \
@@ -258,11 +259,12 @@
     cat > $WORK_DIR/server/conf/backend-db.xml << EOF
 <?xml version="1.0" encoding="UTF-8" ?>
 <backend-database>
-    <user>flys27</user>
-    <password>flys27</password>
+    <user>$BACKENDUSER</user>
+    <password>$BACKENDPASS</password>
     <dialect>org.hibernatespatial.oracle.OracleSpatial10gDialect</dialect>
     <driver>oracle.jdbc.driver.OracleDriver</driver>
-    <url>jdbc:oracle:thin:@//czech-republic.atlas.intevation.de:1521/XE</url>
+    <url>jdbc:oracle:thin:@//$BACKENDURL:$BACKENDPORT/$BACKENDBACK</url>
+    <connection-init-sqls>$INITSQLS</connection-init-sqls>
 </backend-database>
 EOF
 else
@@ -275,6 +277,7 @@
     <dialect>org.hibernate.dialect.PostgreSQLDialect</dialect>
     <driver>org.postgresql.Driver</driver>
     <url>jdbc:postgresql://$BACKENDURL:$BACKENDPORT/$BACKENDBACK</url>
+    <connection-init-sqls>$INITSQLS</connection-init-sqls>
 </backend-database>
 EOF
 fi

http://dive4elements.wald.intevation.org