From a7e8c79fe7385f5bceac77563b1bb9b607204432 Mon Sep 17 00:00:00 2001
From: rescobar
Date: Tue, 28 Sep 2010 19:24:10 -0700
Subject: feature[bgz_326568]: Add H2 Database support

---
 .../support/osee.demo.db.connection.xml            | 138 +++++++++++----------
 1 file changed, 70 insertions(+), 68 deletions(-)

(limited to 'plugins/org.eclipse.osee.demo.db.connection')

diff --git a/plugins/org.eclipse.osee.demo.db.connection/support/osee.demo.db.connection.xml b/plugins/org.eclipse.osee.demo.db.connection/support/osee.demo.db.connection.xml
index f86f76b5b8c..e4b6d4df76a 100644
--- a/plugins/org.eclipse.osee.demo.db.connection/support/osee.demo.db.connection.xml
+++ b/plugins/org.eclipse.osee.demo.db.connection/support/osee.demo.db.connection.xml
@@ -1,68 +1,70 @@
-<DbConnection>
-
-	<DatabaseInfo id="h2.db.info">
-		<DatabaseHome key="#DBHOME#" value="~/h2/"/>
-		<DatabaseName key="#DBNAME#" value="osee.h2.db" />
-		<DatabaseType key="#TYPE#" value="h2" />
-		<Prefix key="#PREFIX#" value="jdbc:h2" />
-		<UserName key="#USERNAME#" value="OSEE" />
-		<Password key="#PASSWORD#" value="OSEE" />
-		<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
-		<Port key="#PORT#" value="@AvailableDbServices.port" />
-	</DatabaseInfo>
-
-	<ConnectionDescription id="h2.db.connection">
-		<Driver>org.h2.Driver</Driver>
-		<Url>#PREFIX#:tcp://#HOST#:#PORT#/#DBHOME##DBNAME#;MODE=PostgreSQL;IGNORECASE=TRUE</Url>
-	</ConnectionDescription>
-
-	<DatabaseInfo id="DerbyServer">
-		<DatabaseHome key="#DBHOME#" />
-		<DatabaseName key="#DBNAME#" value="DerbyDatabase" />
-		<DatabaseType key="#TYPE#" value="derby" />
-		<Prefix key="#PREFIX#" value="jdbc:derby" />
-		<UserName key="#USERNAME#" value="osee" />
-		<Password key="#PASSWORD#" value="oseeadmin" />
-		<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
-		<Port key="#PORT#" value="@AvailableDbServices.port" />
-	</DatabaseInfo>
-
-	<DatabaseInfo id="postgresqlInfo">
-		<DatabaseHome key="#DBHOME#" />
-		<DatabaseName key="#DBNAME#" value="OSEE" />
-		<DatabaseType key="#TYPE#" value="postgresql" />
-		<Prefix key="#PREFIX#" value="jdbc:postgresql" />
-		<UserName key="#USERNAME#" value="osee" />
-		<Password key="#PASSWORD#" value="osee" />
-		<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
-		<Port key="#PORT#" value="@AvailableDbServices.port" />
-	</DatabaseInfo>
-
-	<ConnectionDescription id="postgresql">
-		<Driver>org.postgresql.Driver</Driver>
-		<Url>#PREFIX#://#HOST#:#PORT#/#DBHOME##DBNAME#</Url>		
-	</ConnectionDescription>
-
-	<ConnectionDescription id="NetDerbyClient">
-		<Driver>org.apache.derby.jdbc.ClientDriver</Driver>
-		<Url>#PREFIX#://#HOST#:#PORT#/#DBHOME##DBNAME#;</Url>
-		<UrlAttributes>
-			<Entry>create=true</Entry>
-		</UrlAttributes>
-	</ConnectionDescription>
-
-	<AvailableDbServices>
-	
-		<Server id="h2" dbInfo="h2.db.info" hostAddress="127.0.0.1" port="1621" connectsWith="h2.db.connection" />
-
-		<Server id="derby" dbInfo="DerbyServer" hostAddress="127.0.0.1" port="1621" connectsWith="NetDerbyClient" />
-
-		<Server id="osee.microdoc" dbInfo="postgresqlInfo" hostAddress="78.46.71.230"
-			port="5432" connectsWith="postgresql" applicationServer="http://osee.microdoc.com:8089/" />
-
-		<Server id="postgresqlLocalhost" dbInfo="postgresqlInfo"
-			hostAddress="localhost" port="5432" connectsWith="postgresql"
-			applicationServer="http://localhost:8089/" />
-
-	</AvailableDbServices>
-</DbConnection>
+<DbConnection>
+
+	<DatabaseInfo id="h2.db.info">
+		<DatabaseHome key="#DBHOME#" value="~/h2/" />
+		<DatabaseName key="#DBNAME#" value="osee.h2.db" />
+		<DatabaseType key="#TYPE#" value="h2" />
+		<Prefix key="#PREFIX#" value="jdbc:h2" />
+		<UserName key="#USERNAME#" value="osee" />
+		<Password key="#PASSWORD#" value="oseeadmin" />
+		<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
+		<Port key="#PORT#" value="@AvailableDbServices.port" />
+	</DatabaseInfo>
+
+	<ConnectionDescription id="h2.db.connection">
+		<Driver>org.h2.Driver</Driver>
+		<Url>#PREFIX#:tcp://#HOST#:#PORT#/#DBHOME##DBNAME#;IGNORECASE=TRUE;SCHEMA_SEARCH_PATH=OSEE, PUBLIC</Url>
+	</ConnectionDescription>
+
+	<DatabaseInfo id="DerbyServer">
+		<DatabaseHome key="#DBHOME#" />
+		<DatabaseName key="#DBNAME#" value="DerbyDatabase" />
+		<DatabaseType key="#TYPE#" value="derby" />
+		<Prefix key="#PREFIX#" value="jdbc:derby" />
+		<UserName key="#USERNAME#" value="osee" />
+		<Password key="#PASSWORD#" value="oseeadmin" />
+		<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
+		<Port key="#PORT#" value="@AvailableDbServices.port" />
+	</DatabaseInfo>
+
+	<DatabaseInfo id="postgresqlInfo">
+		<DatabaseHome key="#DBHOME#" />
+		<DatabaseName key="#DBNAME#" value="OSEE" />
+		<DatabaseType key="#TYPE#" value="postgresql" />
+		<Prefix key="#PREFIX#" value="jdbc:postgresql" />
+		<UserName key="#USERNAME#" value="osee" />
+		<Password key="#PASSWORD#" value="osee" />
+		<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
+		<Port key="#PORT#" value="@AvailableDbServices.port" />
+	</DatabaseInfo>
+
+	<ConnectionDescription id="postgresql">
+		<Driver>org.postgresql.Driver</Driver>
+		<Url>#PREFIX#://#HOST#:#PORT#/#DBHOME##DBNAME#</Url>
+	</ConnectionDescription>
+
+	<ConnectionDescription id="NetDerbyClient">
+		<Driver>org.apache.derby.jdbc.ClientDriver</Driver>
+		<Url>#PREFIX#://#HOST#:#PORT#/#DBHOME##DBNAME#;</Url>
+		<UrlAttributes>
+			<Entry>create=true</Entry>
+		</UrlAttributes>
+	</ConnectionDescription>
+
+	<AvailableDbServices>
+
+		<Server id="h2" dbInfo="h2.db.info" hostAddress="127.0.0.1"
+			port="1621" connectsWith="h2.db.connection" />
+
+		<Server id="derby" dbInfo="DerbyServer" hostAddress="127.0.0.1"
+			port="1621" connectsWith="NetDerbyClient" />
+
+		<Server id="osee.microdoc" dbInfo="postgresqlInfo" hostAddress="78.46.71.230"
+			port="5432" connectsWith="postgresql" applicationServer="http://osee.microdoc.com:8089/" />
+
+		<Server id="postgresqlLocalhost" dbInfo="postgresqlInfo"
+			hostAddress="localhost" port="5432" connectsWith="postgresql"
+			applicationServer="http://localhost:8089/" />
+
+	</AvailableDbServices>
+</DbConnection>
-- 
cgit v1.2.3