Index: lams_build/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_build/build.xml,v
diff -u -r1.99 -r1.100
--- lams_build/build.xml	26 Feb 2012 19:53:15 -0000	1.99
+++ lams_build/build.xml	6 Mar 2012 11:16:14 -0000	1.100
@@ -121,8 +121,6 @@
 		<copy todir="${deploy.tool}/lib" overwrite="yes" flatten="true">
 			<fileset dir="../${lams_tool_deploy}/lib">
 				<include name="jakarta-commmons/*.jar" />
-				<include name="mysql/*.jar" />
-				<include name="xstream/*.jar" />
 			</fileset>
 		</copy>
 		
@@ -169,7 +167,7 @@
 					<include name="jakarta-taglibs/*.jar" />
 					<include name="jdom/*.jar" />
 					<include name="jfreechart/*.jar" />
-					<include name="mysql/*.jar" />
+					<include name="mysql/mysql-connector-java-*.jar" />
 					<include name="odmg/*.jar" />
 					<include name="smack/smack.jar"/>
 					<include name="smack/smackx.jar"/>
@@ -201,7 +199,16 @@
 				<include name="${lams_gradebook}/${sub.build.lib}/*.jar"/>
 				<include name="${lams_gradebook}/${sub.build.lib}/*.war"/>
 			</fileset>
-		</copy> 
+		</copy>
+		
+		<!-- Copy connectors for embedded MySQL, if they are available -->
+		<copy todir="${assembly}/temp" verbose="true" overwrite="true" failonerror="false">
+			<fileset dir="../mysql_embedded/connectors">
+				<include name="*-driver.jar" />
+				<include name="*-db-files-${osPropertiesName}.jar" />
+			</fileset>
+		</copy>
+
 		<!-- lams-central.war is already expanded -->
 		<copy todir="${assembly}/temp/" failonerror="true">
 			<fileset dir="../${lams_central}/${sub.build.lib}/">
@@ -491,7 +498,9 @@
 				<include name="mysql*.xml" />
 			</fileset>
 	        <filterset>
-	            <filter token="db.name" value="${db.name}"/>
+	        	<filter token="db.driver" value="${db.driver}"/>
+	        	<filter token="db.url.run" value="${db.url.run}"/>
+	        	<filter token="db.location" value="${db.location}"/>
                 <filter token="db.username" value="${db.username}"/>
                 <filter token="db.password" value="${db.password}"/>
 	        </filterset>
Index: lams_build/buildcombinedtasks.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_build/Attic/buildcombinedtasks.xml,v
diff -u -r1.4 -r1.5
--- lams_build/buildcombinedtasks.xml	28 Oct 2009 05:23:33 -0000	1.4
+++ lams_build/buildcombinedtasks.xml	6 Mar 2012 11:16:14 -0000	1.5
@@ -16,13 +16,14 @@
 		
 			<path id="deploy.lib.classpath">
 				<fileset dir="${deploy.tool.dir}">
-					<include name="lib/*.jar"/>
+					<include name="lib/*.jar" />
 				</fileset>
-			</path> 
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 				  
 			<mkdir dir="${assembly.activity}/"/>
-			<mkdir dir="${assembly.activity}/lib"/> 
-			<mkdir dir="${assembly.activity}/sql"/> 
 			<mkdir dir="${assembly.activity}/language"/> 
 			<mkdir dir="${dest.language.file.folder}" />
 		
@@ -60,11 +61,6 @@
 		        </filterchain>
 		    </copy>
 
-			<copy overwrite="yes" todir="${assembly.activity}/lib">
-				<fileset dir="${deploy.tool.dir}/lib">
-					<include name="*.jar"/>
-				</fileset>
-			</copy>
 
 			<taskdef name="generateDeployLibraryProperties" 
 				classname="org.lamsfoundation.lams.tool.deploy.libraryActivity.CreateLibraryPackageTask">
@@ -77,17 +73,10 @@
 				configFile="${assembly.activity}/deploy.xml"
 				dbPassword="${db.password}"
 				dbUsername="${db.username}"
-				dbDriverUrl="${db.url}"
+				dbDriverUrl="${db.url.build}"
 				dbDriverClass="com.mysql.jdbc.Driver"	
 				/>
 		
-			<!-- Do the actual deployment -->
-			<path id="deploy.classpath">
-				<fileset dir="${assembly.activity}">
-					<include name="lib/*.jar"/>
-				</fileset>
-			</path> 
-		
 			<!-- copy the language files to the assembly folder -->
 			<echo>Copying language files</echo>
 			<copy overwrite="yes" todir="${dest.language.file.folder}">
@@ -98,7 +87,7 @@
 	
 			<java
 				classname="org.lamsfoundation.lams.tool.deploy.libraryActivity.DeployLibrary"
-				classpathref="deploy.classpath"
+				classpathref="deploy.lib.classpath"
 				fork="true">
 					<arg file="${assembly.activity}/deploy.xml"/>
 					<arg file="${assembly.activity}/language"/>
Index: lams_build/common.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_build/common.properties,v
diff -u -r1.38 -r1.39
--- lams_build/common.properties	30 Jul 2009 18:23:15 -0000	1.38
+++ lams_build/common.properties	6 Mar 2012 11:16:14 -0000	1.39
@@ -42,21 +42,44 @@
 #deploy tool directory
 tag.web.dir=../lams_central/web/WEB-INF
 
-#database access
-db.name=${conf.application}
+
+#=========DATABASE PROPERTIES==========
+db.driver.dir=${sharedlib}/mysql/
 db.driver=com.mysql.jdbc.Driver
-db.url=jdbc:mysql://localhost/${db.name}?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&useUnicode=true
+db.name=${conf.application}
 db.encoding=utf8
 db.username=lams
 db.password=lamsdemo
-db.driver.jar=${sharedlib}/mysql/mysql-connector-java-5.0.8-bin.jar
 db.scripts=${basedir}/db/sql
 db.schema=
 db.catalog=
-
 # db scripts
 lamsconf.table.sql=insert_${conf.application}_${osPropertiesName}_config_data.sql
 
+
+# Basedir of embedded MySQL server. This is also the place where data is stored.
+# Set it if you use MXJ for running and/or building LAMS.
+db.location=C:/${conf.application}/database
+
+# To build LAMS using standalone MySQL server, use properties below
+db.url.build=jdbc:mysql://localhost:3306/${db.name}?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&useUnicode=true
+db.url.init.build=${db.url.build}
+
+# To build LAMS using embedded MySQL server, use properties below
+# If you build LAMS this way, you will also need to run it using the embedded server.
+# db.config.build configuration is a replacement for my.ini and it's optional. If left blank, server defaults will be used.
+#db.config.build=&server.skip-external-locking&server.key_buffer_size=16K&server.max_allowed_packet=1M&server.table_open_cache=4&server.sort_buffer_size=64K&server.read_buffer_size=256K&server.read_rnd_buffer_size=257K&server.net_buffer_length=2K&server.thread_stack=128K
+#db.url.build=jdbc:mysql:mxj://localhost:13306/${db.name}?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&useUnicode=true&server.basedir=${db.location}${db.config.build}
+#db.url.init.build=${db.url.build}&server.initialize-user=true&createDatabaseIfNotExist=true
+
+# To run LAMS using standalone MySQL server, use properties below
+db.url.run=jdbc:mysql://localhost:3306/${db.name}
+
+# To run LAMS using embedded MySQL server, use properties below
+#db.url.run=jdbc:mysql:mxj://localhost:13306/${db.name}
+
+#======END OF DATABASE PROPERTIES=======
+
 #xdoclet version number
 xdoclet.version=1.2.3
 
Index: lams_build/conf/unix/jboss/service/mysql-ds.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_build/conf/unix/jboss/service/mysql-ds.xml,v
diff -u -r1.8 -r1.9
--- lams_build/conf/unix/jboss/service/mysql-ds.xml	1 Jul 2009 02:48:32 -0000	1.8
+++ lams_build/conf/unix/jboss/service/mysql-ds.xml	6 Mar 2012 11:16:14 -0000	1.9
@@ -9,12 +9,26 @@
   <!-- lams-ds datasource for use by LAMS Core and Services -->
   <local-tx-datasource>
     <jndi-name>jdbc/lams-ds</jndi-name>
-    <connection-url>jdbc:mysql://localhost:3306/@db.name@</connection-url>
-    <driver-class>com.mysql.jdbc.Driver</driver-class>
+    <connection-url>@db.url.run@</connection-url>
+    <driver-class>@db.driver@</driver-class>
     <!-- Tell MySQL Connector to use UTF-8 character encoding, -->
     <!-- and convert MySQL zero times to null -->
     <connection-property name="characterEncoding">utf8</connection-property>
     <connection-property name="zeroDateTimeBehavior">convertToNull</connection-property>
+
+    <!-- Properties below are used only for embedded MySQL server -->
+    <connection-property name="server.basedir">@db.location@</connection-property>
+    <connection-property name="createDatabaseIfNotExist">false</connection-property>
+    <connection-property name="server.initialize-user">false</connection-property>
+	<connection-property name="server.key_buffer">16K</connection-property>
+    <connection-property name="server.max_allowed_packet">1M</connection-property>
+    <connection-property name="server.table_cache">4</connection-property>
+    <connection-property name="server.sort_buffer_size">64K</connection-property>
+    <connection-property name="server.read_buffer_size">256K</connection-property>
+    <connection-property name="server.read_rnd_buffer_size">256K</connection-property>
+    <connection-property name="server.net_buffer_length">2K</connection-property>
+    <connection-property name="server.thread_stack">128K</connection-property>
+
     <!-- Set transaction isolation level to match db -->
     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>	
     <user-name>@db.username@</user-name>
Index: lams_build/conf/windows/jboss/service/mysql-ds.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_build/conf/windows/jboss/service/mysql-ds.xml,v
diff -u -r1.7 -r1.8
--- lams_build/conf/windows/jboss/service/mysql-ds.xml	26 Mar 2009 10:00:27 -0000	1.7
+++ lams_build/conf/windows/jboss/service/mysql-ds.xml	6 Mar 2012 11:16:14 -0000	1.8
@@ -9,12 +9,26 @@
   <!-- lams-ds datasource for use by LAMS Core and Services -->
   <local-tx-datasource>
     <jndi-name>jdbc/lams-ds</jndi-name>
-    <connection-url>jdbc:mysql://localhost:3306/@db.name@</connection-url>
-    <driver-class>com.mysql.jdbc.Driver</driver-class>
+    <connection-url>@db.url.run@</connection-url>
+    <driver-class>@db.driver@</driver-class>
     <!-- Tell MySQL Connector to use UTF-8 character encoding, -->
     <!-- and convert MySQL zero times to null -->
     <connection-property name="characterEncoding">utf8</connection-property>
     <connection-property name="zeroDateTimeBehavior">convertToNull</connection-property>
+
+    <!-- Properties below are used only for embedded MySQL server -->
+    <connection-property name="server.basedir">@db.location@</connection-property>
+    <connection-property name="createDatabaseIfNotExist">false</connection-property>
+    <connection-property name="server.initialize-user">false</connection-property>
+	<connection-property name="server.key_buffer">16K</connection-property>
+    <connection-property name="server.max_allowed_packet">1M</connection-property>
+    <connection-property name="server.table_cache">4</connection-property>
+    <connection-property name="server.sort_buffer_size">64K</connection-property>
+    <connection-property name="server.read_buffer_size">256K</connection-property>
+    <connection-property name="server.read_rnd_buffer_size">256K</connection-property>
+    <connection-property name="server.net_buffer_length">2K</connection-property>
+    <connection-property name="server.thread_stack">128K</connection-property>
+
     <!-- Set transaction isolation level to match db -->
     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>	
     <user-name>@db.username@</user-name>
Index: lams_build/deploy-tool/lib/lams-tool-deploy.jar
===================================================================
RCS file: /usr/local/cvsroot/lams_build/deploy-tool/lib/lams-tool-deploy.jar,v
diff -u -r1.29 -r1.30
Binary files differ
Index: lams_build/lib/mysql/.cvsignore
===================================================================
RCS file: /usr/local/cvsroot/lams_build/lib/mysql/.cvsignore,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_build/lib/mysql/.cvsignore	6 Mar 2012 11:16:14 -0000	1.1
@@ -0,0 +1 @@
+mysql-connector-mxj-*.jar
Index: lams_common/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/build.xml,v
diff -u -r1.73 -r1.74
--- lams_common/build.xml	13 Feb 2011 23:45:23 -0000	1.73
+++ lams_common/build.xml	6 Mar 2012 11:16:44 -0000	1.74
@@ -10,6 +10,7 @@
 	<property file="build.properties"/>
 	<property file="../lams_build/common.properties"/>
 	<property file="../lams_build/${osPropertiesName}.properties" />
+
 	
 	<path id="all-libs">
 		<fileset dir="${sharedlib}">
@@ -65,12 +66,12 @@
 	</target>
 
 	<target name="check-driver-present">
-		<available file="${db.driver.jar}" type="file" property="driver.present"/>
+		<available file="${db.driver.dir}" type="dir" property="driver.present"/>
 	</target>
 	<target name="panic-if-driver-not-present" unless="driver.present">
 		<fail>
 	      The JDBC driver you have specified by including one of the files in ${basedir}/config/database
-	      doesn't exist. You have to download this driver separately and put it in ${db.driver.jar}
+	      doesn't exist. You have to download this driver separately and put it in ${db.driver.dir}
 	      Please make sure you're using a version that is equal or superior to the one we looked for.
 	      If you name the driver jar file differently, please update the database.driver.jar property
 	      in the ${basedir}/config/database/xxx.xml file accordingly.
@@ -97,7 +98,7 @@
          appname="learningdesign"
          prefsdir="${middlegen}"
          gui="${middlegen.gui}"
-         databaseurl="${db.url}"
+         databaseurl="${db.url.build}"
          driver="${db.driver}"
          username="${db.username}"
          password="${db.password}"
@@ -297,11 +298,19 @@
                     <filter token="dbname" value="${db.name}"/>
 	        </filterset>
 		</copy>
-
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}" encoding="${db.encoding}">
+		
+		<!-- Copy connectors for embedded MySQL, if they are available -->
+		<copy todir="${db.driver.dir}" verbose="true" overwrite="true" failonerror="false">
+			<fileset dir="../mysql_embedded/connectors">
+				<include name="*-driver.jar" />
+				<include name="*-db-files-${osPropertiesName}.jar" />
+			</fileset>
+		</copy>
+		
+		<sql driver="${db.driver}" url="${db.url.init.build}" userid="${db.username}"
+				password="${db.password}" encoding="${db.encoding}" >
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${build}/create_lams_11_db.sql"/>
 			<transaction src="${db.scripts}/drop_lams_11_tables.sql"/>
@@ -333,10 +342,10 @@
 	<!-- =================================================================== -->
 	<target name="insert-test-data" depends="rebuild-db"
 		description="insert test data to lams database">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_test_data.sql"/>
 		</sql>
Index: lams_learning/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_learning/build.xml,v
diff -u -r1.30 -r1.31
--- lams_learning/build.xml	16 Oct 2008 06:23:35 -0000	1.30
+++ lams_learning/build.xml	6 Mar 2012 11:15:38 -0000	1.31
@@ -147,7 +147,7 @@
 		</fail>
 	</target>
 	<!-- target name="check-driver-present">
-		<available file="${database.driver.file}" type="file" property="driver.present"/>
+		<available file="${database.driver.file}" type="dir" property="driver.present"/>
 		</target>
 		<target name="panic-if-driver-not-present" unless="driver.present">
 		<fail>
Index: lams_monitoring/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_monitoring/build.xml,v
diff -u -r1.30 -r1.31
--- lams_monitoring/build.xml	5 Dec 2011 16:03:31 -0000	1.30
+++ lams_monitoring/build.xml	6 Mar 2012 11:15:52 -0000	1.31
@@ -168,7 +168,7 @@
    </target>
 
    <target name="check-driver-present">
-      <available file="${database.driver.file}" type="file" property="driver.present"/>
+      <available file="${database.driver.file}" type="dir" property="driver.present"/>
    </target>
    <target name="panic-if-driver-not-present" unless="driver.present">
       <fail>
Index: lams_tool_assessment/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_assessment/build.xml,v
diff -u -r1.6 -r1.7
--- lams_tool_assessment/build.xml	14 Dec 2010 23:17:26 -0000	1.6
+++ lams_tool_assessment/build.xml	6 Mar 2012 11:16:04 -0000	1.7
@@ -154,20 +154,20 @@
 	<!-- Assessment Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean assessment database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_assessment.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_assessment.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_assessment.sql"/>
@@ -176,10 +176,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_assessment_data.sql"/>
 		</sql>
@@ -360,12 +360,14 @@
 		<echo>+------------------------------------------+</echo>
 		<path id="deploy.lib.classpath">
 			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
+				<include name="lib/*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -408,12 +410,6 @@
 				<include name="*.*"/>
 			</fileset>
 		</copy>
-
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
 		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
@@ -439,7 +435,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -474,11 +470,13 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
-		</path> 
-
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 		<echo>Deploying the Assessment tool</echo>
 	
 		<java
Index: lams_tool_chat/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/build.xml,v
diff -u -r1.25 -r1.26
--- lams_tool_chat/build.xml	6 Apr 2009 17:08:49 -0000	1.25
+++ lams_tool_chat/build.xml	6 Mar 2012 11:15:45 -0000	1.26
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_chat.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_chat.sql" />
 		</sql>
@@ -339,10 +339,13 @@
 			<fileset dir="${deploy.tool.dir}">
 				<include name="lib/*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/language" />
 
@@ -386,12 +389,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -416,7 +413,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -449,9 +446,12 @@
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<echo>Deploying the Chat Tool</echo>
Index: lams_tool_daco/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_daco/build.xml,v
diff -u -r1.8 -r1.9
--- lams_tool_daco/build.xml	6 Apr 2009 17:07:20 -0000	1.8
+++ lams_tool_daco/build.xml	6 Mar 2012 11:15:48 -0000	1.9
@@ -150,20 +150,20 @@
 	<!-- Daco Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean daco database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_daco.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_daco.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_daco.sql"/>
@@ -172,10 +172,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_daco_data.sql"/>
 		</sql>
@@ -306,12 +306,15 @@
 		<echo>+------------------------------------------+</echo>
 		<path id="deploy.lib.classpath">
 			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
+				<include name="lib/*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -354,12 +357,6 @@
 				<include name="*.*"/>
 			</fileset>
 		</copy>
-
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
 		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
@@ -385,7 +382,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrL="${db.url}"
+			dbDriverUrL="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -419,11 +416,14 @@
 	</target>
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+					<path id="deploy.classpath">
+						<fileset dir="${deploy.tool.dir}/lib">
+							<include name="*.jar" />
+						</fileset>
+						<fileset dir="${sharedlib}">
+							<include name="**/*.jar" />
+						</fileset>
+					</path>
 
 		<echo>Deploying the Daco tool</echo>
 	
Index: lams_tool_deploy/.classpath
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_deploy/.classpath,v
diff -u -r1.4 -r1.5
--- lams_tool_deploy/.classpath	16 Apr 2009 07:58:13 -0000	1.4
+++ lams_tool_deploy/.classpath	6 Mar 2012 11:16:28 -0000	1.5
@@ -3,17 +3,21 @@
 	<classpathentry kind="src" path="src/java"/>
 	<classpathentry kind="src" path="test/java"/>
 	<classpathentry kind="lib" path="lib/ant/ant.jar"/>
-	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-configuration-1.1.jar"/>
-	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-dbutils-1.0.jar"/>
-	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-io-1.0.jar"/>
-	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-lang-2.0.jar"/>
-	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-logging.jar"/>
-	<classpathentry kind="lib" path="lib/junit/junit.jar"/>
-	<classpathentry kind="lib" path="lib/mysql/mysql-connector-java-5.0.8-bin.jar"/>
 	<classpathentry kind="lib" path="test/file/test-dummy.jar"/>
 	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
-	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-collections.jar"/>
-	<classpathentry kind="lib" path="lib/xstream/xstream-1.1.2.jar"/>
 	<classpathentry combineaccessrules="false" kind="src" path="/lams_common"/>
+	<classpathentry kind="lib" path="/lams_build/lib/mysql/mysql-connector-mxj-gpl-5-0-12.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/jakarta-commons/commons-collections.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/jakarta-commons/commons-io-1.4.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/jakarta-commons/commons-lang-2.0.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/jakarta-commons/commons-logging.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/mysql/mysql-connector-java-5.0.8-bin.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/junit/junit.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/xstream/xstream-1.1.3.jar"/>
+	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-configuration-1.1.jar"/>
+	<classpathentry kind="lib" path="lib/jakarta-commmons/commons-dbutils-1.0.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/mysql/mysql-connector-mxj-gpl-5-0-12-db-files-linux.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/mysql/mysql-connector-mxj-gpl-5-0-12-db-files-mac.jar"/>
+	<classpathentry kind="lib" path="/lams_build/lib/mysql/mysql-connector-mxj-gpl-5-0-12-db-files-win.jar"/>
 	<classpathentry kind="output" path="bin"/>
 </classpath>
Index: lams_tool_deploy/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_deploy/build.xml,v
diff -u -r1.10 -r1.11
--- lams_tool_deploy/build.xml	13 Feb 2007 00:28:53 -0000	1.10
+++ lams_tool_deploy/build.xml	6 Mar 2012 11:16:28 -0000	1.11
@@ -7,6 +7,7 @@
         <property name="build.dir" value="build/lib"/>
     	<property name="build.report.dir" value="build/report"/>
         <property name="lib.dir" value="lib"/>
+		<property name="sharedlib" value="../lams_build/lib"/>
         <property name="src.dir" value="src/java"/>
         <property name="test.src.dir" value="test/java"/>
         <property name="jar.file" value="${build.dir}/lams-tool-deploy.jar"/>
@@ -19,6 +20,12 @@
             <fileset dir="${lib.dir}">
                 <include name="**/*.jar"/>
             </fileset>
+    		<fileset dir="${sharedlib}">
+    			<include name="**/*.jar" />
+    		</fileset>
+    		<fileset dir="${deploy.tool.dir}">
+    			<include name="commons-*.jar" />
+    		</fileset>
         </path>
         
         <path id="test.class.path">
Index: lams_tool_dimdim/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_dimdim/build.xml,v
diff -u -r1.4 -r1.5
--- lams_tool_dimdim/build.xml	6 Apr 2009 17:07:26 -0000	1.4
+++ lams_tool_dimdim/build.xml	6 Mar 2012 11:15:54 -0000	1.5
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_dimdim.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_dimdim.sql" />
 		</sql>
@@ -339,10 +339,13 @@
 			<fileset dir="${deploy.tool.dir}">
 				<include name="lib/*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -386,12 +389,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -416,7 +413,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -449,9 +446,12 @@
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<echo>Deploying the Dimdim Tool</echo>
Index: lams_tool_eadventure/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_eadventure/build.xml,v
diff -u -r1.4 -r1.5
--- lams_tool_eadventure/build.xml	12 Dec 2011 09:21:50 -0000	1.4
+++ lams_tool_eadventure/build.xml	6 Mar 2012 11:16:35 -0000	1.5
@@ -154,20 +154,20 @@
 	<!-- Eadventure Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean eadventure database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_eadventure.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_eadventure.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_eadventure.sql"/>
@@ -176,10 +176,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_eadventure_data.sql"/>
 		</sql>
@@ -311,14 +311,17 @@
 		<echo>+------------------------------------------+</echo>
 		<echo>| Generate the deployment package.         |</echo>
 		<echo>+------------------------------------------+</echo>
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+					<path id="deploy.lib.classpath">
+						<fileset dir="${deploy.tool.dir}">
+							<include name="lib/*.jar" />
+						</fileset>
+						<fileset dir="${sharedlib}">
+							<include name="**/*.jar" />
+						</fileset>
+					</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -362,12 +365,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
 					<include name="*.jar"/>
@@ -392,7 +389,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -427,10 +424,13 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 
 		<echo>Deploying the Eadventure tool</echo>
 	
Index: lams_tool_example/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_example/build.xml,v
diff -u -r1.15 -r1.16
--- lams_tool_example/build.xml	15 Feb 2007 04:47:39 -0000	1.15
+++ lams_tool_example/build.xml	6 Mar 2012 11:16:40 -0000	1.16
@@ -118,20 +118,20 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 		<target name="clean-db"	description="Deletes the Tool Tables">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_example.sql"/>
 			</sql>
 		</target>
 		
 		<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 								password="${db.password}"  encoding="${db.encoding}">
 							<classpath>
-								<pathelement location="${db.driver.jar}"/>
+								<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 							</classpath>
 					<transaction src="${db.scripts}/create_lams_tool_example.sql"/>
 			</sql>
@@ -285,14 +285,17 @@
 		<target name="create-deploy-package" depends="build-war" 
 				description="Generate the deployment package.">
 
-				<path id="deploy.lib.classpath">
-					<fileset dir="${deploy.tool.dir}">
-						<include name="lib/*.jar"/>
-					</fileset>
-				</path> 
+			<path id="deploy.lib.classpath">
+				<fileset dir="${deploy.tool.dir}">
+					<include name="lib/*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 					  
 				<mkdir dir="${build.deploy}"/>
-				<mkdir dir="${build.deploy}/lib"/> 
+				
 				<mkdir dir="${build.deploy}/sql"/> 
 				<mkdir dir="${build.deploy}/language"/>
 				 
@@ -326,12 +329,6 @@
 					</fileset>
 				</copy>
 
-				<copy overwrite="yes" todir="${build.deploy}/lib">
-					<fileset dir="${deploy.tool.dir}/lib">
-						<include name="*.jar"/>
-					</fileset>
-				</copy>
-
 				<copy overwrite="yes" todir="${build.deploy}/language">
 					<fileset dir="${conf.language.dir}">
 						<include name="*.properties"/>
@@ -355,7 +352,7 @@
 					outputPath="${build.deploy}"
 					dbPassword="${db.password}"
 					dbUsername="${db.username}"
-					dbDriverUrl="${db.url}"
+					dbDriverUrl="${db.url.build}"
 					dbDriverClass="com.mysql.jdbc.Driver"
 					deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 					toolJarFileName="${product}.jar"
@@ -387,10 +384,13 @@
 			<target name="run-deploy-package" description="Run the deploy tool.">
 
 				<path id="deploy.classpath">
-					<fileset dir="${build.deploy}">
-						<include name="lib/*.jar"/>
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
 					</fileset>
-				</path> 
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 
 				<echo>Deploying the Example Tool</echo>
 		
Index: lams_tool_forum/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/build.xml,v
diff -u -r1.58 -r1.59
--- lams_tool_forum/build.xml	6 Oct 2010 10:16:15 -0000	1.58
+++ lams_tool_forum/build.xml	6 Mar 2012 11:16:26 -0000	1.59
@@ -154,20 +154,20 @@
 	<!-- Forum Database tasks                                               -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_forum.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_forum.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_forum.sql"/>
@@ -176,10 +176,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_forum_data.sql"/>
 		</sql>
@@ -339,12 +339,15 @@
 		<echo>+------------------------------------------+</echo>
 		<path id="deploy.lib.classpath">
 			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
+				<include name="lib/*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/>
 		 
@@ -389,12 +392,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties"/>
@@ -420,7 +417,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -453,10 +450,13 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 
 		<echo>Deploying the Forum tool</echo>
 	
Index: lams_tool_gmap/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_gmap/build.xml,v
diff -u -r1.7 -r1.8
--- lams_tool_gmap/build.xml	6 Apr 2009 17:08:01 -0000	1.7
+++ lams_tool_gmap/build.xml	6 Mar 2012 11:15:23 -0000	1.8
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_gmap.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_gmap.sql" />
 		</sql>
@@ -358,10 +358,13 @@
 			<fileset dir="${deploy.tool.dir}">
 				<include name="lib/*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -405,12 +408,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -435,7 +432,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -467,11 +464,14 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
-			</fileset>
-		</path>
+				<path id="deploy.classpath">
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 
 		<echo>Deploying the Gmap Tool</echo>
 
Index: lams_tool_images/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_images/build.xml,v
diff -u -r1.5 -r1.6
--- lams_tool_images/build.xml	9 Jun 2011 14:44:42 -0000	1.5
+++ lams_tool_images/build.xml	6 Mar 2012 11:16:21 -0000	1.6
@@ -156,20 +156,20 @@
 	<!-- ImageGallery Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean imageGallery database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_imageGallery.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_imageGallery.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_imageGallery.sql"/>
@@ -178,10 +178,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_imageGallery_data.sql"/>
 		</sql>
@@ -310,14 +310,17 @@
 		<echo>+------------------------------------------+</echo>
 		<echo>| Generate the deployment package.         |</echo>
 		<echo>+------------------------------------------+</echo>
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+			<path id="deploy.lib.classpath">
+				<fileset dir="${deploy.tool.dir}">
+					<include name="lib/*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -361,12 +364,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
 					<include name="*.jar"/>
@@ -391,7 +388,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -425,12 +422,14 @@
 	</target>
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
-
+				<path id="deploy.classpath">
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 		<echo>Deploying the ImageGallery tool</echo>
 	
 		<java
Index: lams_tool_imscc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_imscc/build.xml,v
diff -u -r1.2 -r1.3
--- lams_tool_imscc/build.xml	10 Dec 2011 20:51:05 -0000	1.2
+++ lams_tool_imscc/build.xml	6 Mar 2012 11:16:38 -0000	1.3
@@ -154,20 +154,20 @@
 	<!-- CommonCartridge Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean commonCartridge database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_commonCartridge.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_commonCartridge.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_commonCartridge.sql"/>
@@ -176,10 +176,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_commonCartridge_data.sql"/>
 		</sql>
@@ -311,14 +311,17 @@
 		<echo>+------------------------------------------+</echo>
 		<echo>| Generate the deployment package.         |</echo>
 		<echo>+------------------------------------------+</echo>
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+			<path id="deploy.lib.classpath">
+				<fileset dir="${deploy.tool.dir}">
+					<include name="lib/*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -362,12 +365,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
 					<include name="*.jar"/>
@@ -392,7 +389,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -426,12 +423,14 @@
 	</target>
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
-
+				<path id="deploy.classpath">
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 		<echo>Deploying the CommonCartridge tool</echo>
 	
 		<java
Index: lams_tool_lamc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/build.xml,v
diff -u -r1.47 -r1.48
--- lams_tool_lamc/build.xml	22 Feb 2012 22:38:25 -0000	1.47
+++ lams_tool_lamc/build.xml	6 Mar 2012 11:15:17 -0000	1.48
@@ -53,14 +53,14 @@
 		</target>
 
 		<target name="check-driver-present">
-			<available file="${db.driver.jar}" type="file" property="driver.present"/>
+			<available file="${db.driver.dir}" type="dir" property="driver.present"/>
 		</target>
 		<target name="panic-if-driver-not-present" unless="driver.present">
 			<fail>
 		      The JDBC driver you have specified by including one of the files in ${basedir}/config/database
-		      doesn't exist. You have to download this driver separately and put it in ${db.driver.jar}
+		      doesn't exist. You have to download this driver separately and put it in ${db.driver.dir}
 		      Please make sure you're using a version that is equal or superior to the one we looked for.
-		      If you name the driver jar file differently, please update the db.driver.jar property
+		      If you name the driver jar file differently, please update the db.driver.dir property
 		      in the ${basedir}/config/database/xxx.xml file accordingly.
 		     </fail>
 	   </target>
@@ -73,7 +73,7 @@
 			<middlegen appname="lams_tool_lamc11" 
 					   prefsdir="${conf.middlegen.dir}"
 					   gui="${middlegen.gui}"
-					   databaseurl="${db.url}"
+					   databaseurl="${db.url.build}"
 					   driver="${db.driver}"
 					   username="${db.username}"
 					   password="${db.password}"
@@ -286,10 +286,10 @@
 		<!-- =================================================================== -->
 		<target name="rebuild-db"
 			description="rebuild MCQ tables">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_mc.sql"/>
 				<transaction src="${db.scripts}/create_lams_tool_mc.sql"/>
@@ -302,10 +302,10 @@
 		<!-- =================================================================== -->
 		<target name="clean-tool-db"
 			description="rebuild Mc tables">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_mc.sql"/>
 			</sql>
@@ -320,12 +320,15 @@
 
 			<path id="deploy.lib.classpath">
 				<fileset dir="${deploy.tool.dir}">
-					<include name="lib/*.jar"/>
+					<include name="lib/*.jar" />
 				</fileset>
-			</path> 
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 				  
 			<mkdir dir="${build.deploy}"/>
-			<mkdir dir="${build.deploy}/lib"/> 
+			
 			<mkdir dir="${build.deploy}/sql"/> 
 			<mkdir dir="${build.deploy}/language"/>
 			 
@@ -369,12 +372,6 @@
 				</fileset>
 			</copy>
 
-			<copy overwrite="yes" todir="${build.deploy}/lib">
-				<fileset dir="${deploy.tool.dir}/lib">
-					<include name="*.jar"/>
-				</fileset>
-			</copy>
-
 			<copy overwrite="yes" todir="${build.deploy}/language">
 				<fileset dir="${conf.language.dir}">
 					<include name="*.properties"/>
@@ -399,7 +396,7 @@
 				generateForInstallers="${generate.for.installers}"
 				dbPassword="${db.password}"
 				dbUsername="${db.username}"
-				dbDriverUrl="${db.url}"
+				dbDriverUrl="${db.url.build}"
 				dbDriverClass="com.mysql.jdbc.Driver"
 				deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 				toolJarFileName="${product}.jar"
@@ -430,11 +427,14 @@
 		</target>
 	
 		<target name="run-deploy-package" description="Run the deploy tool.">
-			<path id="deploy.classpath">
-				<fileset dir="${build.deploy}">
-					<include name="lib/*.jar"/>
-				</fileset>
-			</path> 
+					<path id="deploy.classpath">
+						<fileset dir="${deploy.tool.dir}/lib">
+							<include name="*.jar" />
+						</fileset>
+						<fileset dir="${sharedlib}">
+							<include name="**/*.jar" />
+						</fileset>
+					</path>
 
 			<echo>Deploying the MCQ tool</echo>
 	
Index: lams_tool_laqa/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/build.xml,v
diff -u -r1.49 -r1.50
--- lams_tool_laqa/build.xml	28 Feb 2011 12:21:58 -0000	1.49
+++ lams_tool_laqa/build.xml	6 Mar 2012 11:16:01 -0000	1.50
@@ -59,14 +59,14 @@
 	</target>
 
 	<target name="check-driver-present">
-		<available file="${db.driver.jar}" type="file" property="driver.present" />
+		<available file="${db.driver.dir}" type="dir" property="driver.present" />
 	</target>
 	<target name="panic-if-driver-not-present" unless="driver.present">
 		<fail>
 		      The JDBC driver you have specified by including one of the files in ${basedir}/config/database
-		      doesn't exist. You have to download this driver separately and put it in ${db.driver.jar}
+		      doesn't exist. You have to download this driver separately and put it in ${db.driver.dir}
 		      Please make sure you're using a version that is equal or superior to the one we looked for.
-		      If you name the driver jar file differently, please update the db.driver.jar property
+		      If you name the driver jar file differently, please update the db.driver.dir property
 		      in the ${basedir}/config/database/xxx.xml file accordingly.
 		     </fail>
 	</target>
@@ -76,7 +76,7 @@
 	<target name="middlegen" description="Run Middlegen For QA Tool" unless="middlegen.skip" depends="init,fail-if-no-xdoclet-1.2.x,check-driver-present,panic-if-driver-not-present">
 		<taskdef name="middlegen" classname="middlegen.MiddlegenTask" classpathref="all-libs" />
 
-		<middlegen appname="lams_tool_laqa11" prefsdir="${conf.middlegen.dir}" gui="${middlegen.gui}" databaseurl="${db.url}" driver="${db.driver}" username="${db.username}" password="${db.password}" includeViews="false">
+		<middlegen appname="lams_tool_laqa11" prefsdir="${conf.middlegen.dir}" gui="${middlegen.gui}" databaseurl="${db.url.build}" driver="${db.driver}" username="${db.username}" password="${db.password}" includeViews="false">
 
 			<hibernate destination="${conf.hibernate.mapping.dir}" package="${laqa11.package}" genXDocletTags="true" javaTypeMapper="middlegen.plugins.hibernate.HibernateJavaTypeMapper" />
 
@@ -255,9 +255,9 @@
 	<!-- Clean and rebuild the database. 									 -->
 	<!-- =================================================================== -->
 	<target name="rebuild-db" description="rebuild QA tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_qa.sql" />
 			<transaction src="${db.scripts}/create_lams_tool_qa.sql" />
@@ -269,9 +269,9 @@
 	<!-- Clean tool database. 									 -->
 	<!-- =================================================================== -->
 	<target name="clean-tool-db" description="rebuild qa tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_qa.sql" />
 		</sql>
@@ -287,10 +287,13 @@
 			<fileset dir="${deploy.tool.dir}">
 				<include name="lib/*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/language" />
 
@@ -334,12 +337,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -357,7 +354,7 @@
 			<classpath refid="deploy.lib.classpath" />
 		</taskdef>
 
-		<generateDeployProperties depends="compile" mode="development" outputPath="${build.deploy}" generateForInstallers="${generate.for.installers}" dbPassword="${db.password}" dbUsername="${db.username}" dbDriverUrl="${db.url}" dbDriverClass="com.mysql.jdbc.Driver" deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" toolJarFileName="${product}.jar" toolSignature="${signature}" toolVersion="${tool.version}" hideTool="${hideTool}" minServerVersionNumber="${min.server.version.number}" toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql" toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_qa.sql" toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_qa.sql" toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" languageFilesPackage="org.lamsfoundation.lams.tool.qa">
+		<generateDeployProperties depends="compile" mode="development" outputPath="${build.deploy}" generateForInstallers="${generate.for.installers}" dbPassword="${db.password}" dbUsername="${db.username}" dbDriverUrl="${db.url.build}" dbDriverClass="com.mysql.jdbc.Driver" deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" toolJarFileName="${product}.jar" toolSignature="${signature}" toolVersion="${tool.version}" hideTool="${hideTool}" minServerVersionNumber="${min.server.version.number}" toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql" toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_qa.sql" toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_qa.sql" toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" languageFilesPackage="org.lamsfoundation.lams.tool.qa">
 
 			<!-- language files go as a fileset. Not nice but can't work out how to embed them in a tag. -->
 			<fileset dir="${build.deploy}/language">
@@ -386,11 +383,14 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
-			</fileset>
-		</path>
+				<path id="deploy.classpath">
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 
 		<echo>Deploying the QA tool</echo>
 
Index: lams_tool_larsrc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/build.xml,v
diff -u -r1.26 -r1.27
--- lams_tool_larsrc/build.xml	18 Aug 2009 04:29:08 -0000	1.26
+++ lams_tool_larsrc/build.xml	6 Mar 2012 11:15:50 -0000	1.27
@@ -154,20 +154,20 @@
 	<!-- Share Resources Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean share resources database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_rsrc.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_rsrc.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_rsrc.sql"/>
@@ -176,10 +176,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_rsrc_data.sql"/>
 		</sql>
@@ -314,14 +314,17 @@
 		<echo>+------------------------------------------+</echo>
 		<echo>| Generate the deployment package.         |</echo>
 		<echo>+------------------------------------------+</echo>
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+			<path id="deploy.lib.classpath">
+				<fileset dir="${deploy.tool.dir}">
+					<include name="lib/*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -365,12 +368,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
 					<include name="*.jar"/>
@@ -395,7 +392,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -429,11 +426,14 @@
 	</target>
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+				<path id="deploy.classpath">
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 
 		<echo>Deploying the Share Resources tool</echo>
 	
Index: lams_tool_mindmap/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_mindmap/build.xml,v
diff -u -r1.2 -r1.3
--- lams_tool_mindmap/build.xml	6 Apr 2009 17:08:42 -0000	1.2
+++ lams_tool_mindmap/build.xml	6 Mar 2012 11:15:26 -0000	1.3
@@ -148,21 +148,21 @@
 		===================================================================
 	-->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 			password="${db.password}" encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_mindmap.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends=""
 		description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 			password="${db.password}" encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_mindmap.sql" />
 		</sql>
@@ -400,14 +400,17 @@
 	<target name="create-deploy-package" depends="build-war"
 		description="Generate the deployment package.">
 
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar" />
-			</fileset>
-		</path>
+			<path id="deploy.lib.classpath">
+				<fileset dir="${deploy.tool.dir}">
+					<include name="lib/*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -452,12 +455,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -480,7 +477,7 @@
 		<generateDeployProperties depends="compile"
 			mode="development" outputPath="${build.deploy}"
 			generateForInstallers="${generate.for.installers}" dbPassword="${db.password}"
-			dbUsername="${db.username}" dbDriverUrl="${db.url}" dbDriverClass="com.mysql.jdbc.Driver"
+			dbUsername="${db.username}" dbDriverUrl="${db.url.build}" dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar" toolSignature="${signature}"
 			toolVersion="${tool.version}" hideTool="${hideTool}"
@@ -509,9 +506,12 @@
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<echo>Deploying the Mindmap Tool</echo>
Index: lams_tool_nb/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/build.xml,v
diff -u -r1.42 -r1.43
--- lams_tool_nb/build.xml	29 Feb 2012 21:30:20 -0000	1.42
+++ lams_tool_nb/build.xml	6 Mar 2012 11:16:07 -0000	1.43
@@ -133,30 +133,30 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 		<target name="clean-db"	description="Deletes the Noticeboard Tool Tables">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_nb.sql"/>
 			</sql>
 		</target>
 		
 		<target name="build-db" depends="" description="Deletes and Creates the Noticeboard Tool tables and inserts default content">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 								password="${db.password}"  encoding="${db.encoding}">
 							<classpath>
-								<pathelement location="${db.driver.jar}"/>
+								<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 							</classpath>
 					<transaction src="${db.scripts}/init_lams_tool_nb.sql"/>
 			</sql>
 		</target>	
 	
 	<!--	<target name="insert-test-data" depends="build-db" description="Inserts test data for noticeboard tool in order for test cases to run">
-				<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+				<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 									password="${db.password}"  encoding="${db.encoding}">
 								<classpath>
-									<pathelement location="${db.driver.jar}"/>
+									<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 								</classpath>
 						<transaction src="${db.scripts}/insert_lams_tool_nb_data.sql"/>
 				</sql>
@@ -171,10 +171,10 @@
 		                <filter token="default_content_id" value="${test.contentid}"/>
 			        </filterset>
 			    </copy>
-				<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+				<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_nb.sql"/>
 				<transaction src="${build.sql}/create_lams_tool_nb_test.sql"/>
@@ -271,7 +271,7 @@
 	         appname="${name}"
 	         prefsdir="${middlegen}"
 	         gui="${middlegen.gui}"
-	         databaseurl="${db.url}"
+	         databaseurl="${db.url.build}"
 	         initialContextFactory="${java.naming.factory.initial}"
 	         providerURL="${java.naming.provider.url}"
 	         datasourceJNDIName="${datasource.jndi.name}"
@@ -389,14 +389,17 @@
 		<target name="create-deploy-package" depends="build-war" 
 				description="Generate the deployment package.">
 
-				<path id="deploy.lib.classpath">
-					<fileset dir="${deploy.tool.dir}">
-						<include name="lib/*.jar"/>
-					</fileset>
-				</path> 
+			<path id="deploy.lib.classpath">
+				<fileset dir="${deploy.tool.dir}">
+					<include name="lib/*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path> 
 					  
 				<mkdir dir="${build.deploy}"/>
-				<mkdir dir="${build.deploy}/lib"/> 
+				
 				<mkdir dir="${build.deploy}/sql"/> 
 				<mkdir dir="${build.deploy}/lang"/> 
 				<mkdir dir="${build.deploy}/language"/>
@@ -441,12 +444,6 @@
 					</fileset>
 				</copy>
 
-				<copy overwrite="yes" todir="${build.deploy}/lib">
-					<fileset dir="${deploy.tool.dir}/lib">
-						<include name="*.jar"/>
-					</fileset>
-				</copy>
-
 				<copy overwrite="yes" todir="${build.deploy}/language">
 					<fileset dir="${conf.language.dir}">
 						<include name="*.properties"/>
@@ -471,7 +468,7 @@
 					generateForInstallers="${generate.for.installers}"
 					dbPassword="${db.password}"
 					dbUsername="${db.username}"
-					dbDriverUrl="${db.url}"
+					dbDriverUrl="${db.url.build}"
 					dbDriverClass="com.mysql.jdbc.Driver"
 					deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 					toolJarFileName="${product}.jar"
@@ -502,11 +499,14 @@
 			</target>
 		
 	<target name="run-deploy-package" description="Run the deploy tool.">
-				<path id="deploy.classpath">
-					<fileset dir="${build.deploy}">
-						<include name="lib/*.jar"/>
-					</fileset>
-				</path> 
+		<path id="deploy.classpath">
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
+			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 
 				<echo>Deploying the Noticeboard Tool</echo>
 		
Index: lams_tool_notebook/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/build.xml,v
diff -u -r1.17 -r1.18
--- lams_tool_notebook/build.xml	30 Jul 2009 18:23:18 -0000	1.17
+++ lams_tool_notebook/build.xml	6 Mar 2012 11:15:35 -0000	1.18
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_notebook.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_notebook.sql" />
 		</sql>
@@ -368,10 +368,13 @@
 			<fileset dir="${deploy.tool.dir}">
 				<include name="lib/*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -415,12 +418,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -445,7 +442,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -478,9 +475,12 @@
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<echo>Deploying the Notebook Tool</echo>
Index: lams_tool_pixlr/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_pixlr/build.xml,v
diff -u -r1.4 -r1.5
--- lams_tool_pixlr/build.xml	24 Apr 2009 01:49:28 -0000	1.4
+++ lams_tool_pixlr/build.xml	6 Mar 2012 11:16:47 -0000	1.5
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_pixlr.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_pixlr.sql" />
 		</sql>
@@ -335,14 +335,17 @@
 	<!-- =================================================================== -->
 	<target name="create-deploy-package" depends="build-war" description="Generate the deployment package.">
 
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar" />
-			</fileset>
-		</path>
+	<path id="deploy.lib.classpath">
+		<fileset dir="${deploy.tool.dir}">
+			<include name="lib/*.jar" />
+		</fileset>
+		<fileset dir="${sharedlib}">
+			<include name="**/*.jar" />
+		</fileset>
+	</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -386,12 +389,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -416,7 +413,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -449,11 +446,13 @@
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
-
 		<echo>Deploying the Pixlr Tool</echo>
 
 		<java classname="org.lamsfoundation.lams.tool.deploy.Deploy" classpathref="deploy.classpath" fork="true">
Index: lams_tool_sbmt/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/build.xml,v
diff -u -r1.52 -r1.53
--- lams_tool_sbmt/build.xml	12 Apr 2011 12:21:32 -0000	1.52
+++ lams_tool_sbmt/build.xml	6 Mar 2012 11:15:28 -0000	1.53
@@ -56,7 +56,7 @@
 		</target>
 
 		<target name="check-driver-present">
-			<available file="${db.driver.jar}" type="file" property="driver.present"/>
+			<available file="${db.driver.dir}" type="dir" property="driver.present"/>
 		</target>
 		<target name="panic-if-driver-not-present" unless="driver.present">
 			<fail>
@@ -76,7 +76,7 @@
 			<middlegen appname="lams_tool_sbmt" 
 					   prefsdir="${conf.middlegen.dir}"
 					   gui="${middlegen.gui}"
-					   databaseurl="${db.url}"
+					   databaseurl="${db.url.build}"
 					   driver="${db.driver}"
 					   username="${db.username}"
 					   password="${db.password}"
@@ -297,10 +297,10 @@
 		<!-- =================================================================== -->
 		<target name="rebuild-db"
 			description="rebuild Submit Files tables">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_sbmt.sql"/>
 				<transaction src="${db.scripts}/create_lams_tool_sbmt.sql"/>
@@ -312,10 +312,10 @@
 	<!-- =================================================================== -->
 	<target name="insert-test-data" depends="rebuild-db"
 		description="Insert some dummy test data. Removes any data that was in the tables first.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_test_data.sql"/>
 		</sql>
@@ -329,12 +329,15 @@
 
 		<path id="deploy.lib.classpath">
 			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
+				<include name="lib/*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/>
 		 
@@ -378,12 +381,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties"/>
@@ -408,7 +405,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="${db.driver}"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -441,10 +438,13 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 
 		<echo>Deploying the Submission tool</echo>
 
Index: lams_tool_scribe/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_scribe/build.xml,v
diff -u -r1.16 -r1.17
--- lams_tool_scribe/build.xml	6 Apr 2009 17:07:46 -0000	1.16
+++ lams_tool_scribe/build.xml	6 Mar 2012 11:15:31 -0000	1.17
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_scribe.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_scribe.sql" />
 		</sql>
@@ -335,14 +335,17 @@
 	<!-- =================================================================== -->
 	<target name="create-deploy-package" depends="build-war" description="Generate the deployment package.">
 
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar" />
-			</fileset>
-		</path>
+	<path id="deploy.lib.classpath">
+		<fileset dir="${deploy.tool.dir}">
+			<include name="lib/*.jar" />
+		</fileset>
+		<fileset dir="${sharedlib}">
+			<include name="**/*.jar" />
+		</fileset>
+	</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -386,12 +389,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -416,7 +413,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -450,9 +447,12 @@
 
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<echo>Deploying the Scribe Tool</echo>
@@ -463,9 +463,9 @@
 		</java>
 
 		<!-- echo>Marking activity as invalid - set it to valid if debugging or use the combined chat/scribe or forum/scribe activity. This is not an error.</echo>
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/make_activity_invalid.sql" />
 		</sql -->
Index: lams_tool_spreadsheet/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/build.xml,v
diff -u -r1.7 -r1.8
--- lams_tool_spreadsheet/build.xml	6 Apr 2009 17:08:22 -0000	1.7
+++ lams_tool_spreadsheet/build.xml	6 Mar 2012 11:15:20 -0000	1.8
@@ -150,20 +150,20 @@
 	<!-- Spreadsheet Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean spreadsheet database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_spreadsheet.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_spreadsheet.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_spreadsheet.sql"/>
@@ -172,10 +172,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_spreadsheet_data.sql"/>
 		</sql>
@@ -308,14 +308,17 @@
 		<echo>+------------------------------------------+</echo>
 		<echo>| Generate the deployment package.         |</echo>
 		<echo>+------------------------------------------+</echo>
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+			<path id="deploy.lib.classpath">
+				<fileset dir="${deploy.tool.dir}">
+					<include name="lib/*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -359,12 +362,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
 					<include name="*.jar"/>
@@ -389,7 +386,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -423,11 +420,14 @@
 	</target>
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+				<path id="deploy.classpath">
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 
 		<echo>Deploying the Spreadsheet tool</echo>
 	
Index: lams_tool_survey/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/build.xml,v
diff -u -r1.16 -r1.17
--- lams_tool_survey/build.xml	6 Apr 2009 17:09:03 -0000	1.16
+++ lams_tool_survey/build.xml	6 Mar 2012 11:15:43 -0000	1.17
@@ -151,20 +151,20 @@
 	<!-- Survey Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean share surveys database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_survey.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_survey.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_survey.sql"/>
@@ -173,10 +173,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_survey_data.sql"/>
 		</sql>
@@ -307,12 +307,15 @@
 		<echo>+------------------------------------------+</echo>
 		<path id="deploy.lib.classpath">
 			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
+				<include name="lib/*.jar" />
 			</fileset>
-		</path> 
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
+		</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -356,12 +359,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
 					<include name="*.jar"/>
@@ -386,7 +383,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -421,11 +418,14 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+					<path id="deploy.classpath">
+						<fileset dir="${deploy.tool.dir}/lib">
+							<include name="*.jar" />
+						</fileset>
+						<fileset dir="${sharedlib}">
+							<include name="**/*.jar" />
+						</fileset>
+					</path>
 
 		<echo>Deploying the Survey tool</echo>
 	
Index: lams_tool_task/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_task/build.xml,v
diff -u -r1.7 -r1.8
--- lams_tool_task/build.xml	6 Apr 2009 17:07:53 -0000	1.7
+++ lams_tool_task/build.xml	6 Mar 2012 11:15:58 -0000	1.8
@@ -155,20 +155,20 @@
 	<!-- TaskList Database tasks                                       -->
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean taskList database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/cleanup_lams_tool_taskList.sql"/>
 		</sql>
 	</target>
 	
 	<target name="init-db"	description="drop and create forum database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_taskList.sql"/>
 			<transaction src="${db.scripts}/create_lams_tool_taskList.sql"/>
@@ -177,10 +177,10 @@
 	
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.name}"/>
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/insert_lams_tool_taskList_data.sql"/>
 		</sql>
@@ -309,14 +309,17 @@
 		<echo>+------------------------------------------+</echo>
 		<echo>| Generate the deployment package.         |</echo>
 		<echo>+------------------------------------------+</echo>
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+	<path id="deploy.lib.classpath">
+		<fileset dir="${deploy.tool.dir}">
+			<include name="lib/*.jar" />
+		</fileset>
+		<fileset dir="${sharedlib}">
+			<include name="**/*.jar" />
+		</fileset>
+	</path>
 			  
 		<mkdir dir="${build.deploy}"/>
-		<mkdir dir="${build.deploy}/lib"/> 
+		
 		<mkdir dir="${build.deploy}/sql"/> 
 		<mkdir dir="${build.deploy}/language"/> 
 		 
@@ -360,12 +363,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar"/>
-			</fileset>
-		</copy>
-		
 		<copy overwrite="true" todir="${build.deploy}">
 				<fileset dir="${build.lib}">
 					<include name="*.jar"/>
@@ -390,7 +387,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}"
 			dbUsername="${db.username}"
-			dbDriverUrl="${db.url}"
+			dbDriverUrl="${db.url.build}"
 			dbDriverClass="com.mysql.jdbc.Driver"
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 			toolJarFileName="${product}.jar"
@@ -424,11 +421,14 @@
 	</target>
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar"/>
-			</fileset>
-		</path> 
+				<path id="deploy.classpath">
+					<fileset dir="${deploy.tool.dir}/lib">
+						<include name="*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 
 		<echo>Deploying the TaskList tool</echo>
 	
Index: lams_tool_videorecorder/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_videorecorder/build.xml,v
diff -u -r1.5 -r1.6
--- lams_tool_videorecorder/build.xml	7 May 2009 06:15:46 -0000	1.5
+++ lams_tool_videorecorder/build.xml	6 Mar 2012 11:16:32 -0000	1.6
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_videoRecorder.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_videoRecorder.sql" />
 		</sql>
@@ -358,10 +358,13 @@
 			<fileset dir="${deploy.tool.dir}">
 				<include name="lib/*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -405,12 +408,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -435,7 +432,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -467,11 +464,14 @@
 
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
-		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
-			</fileset>
-		</path>
+			<path id="deploy.classpath">
+				<fileset dir="${deploy.tool.dir}/lib">
+					<include name="*.jar" />
+				</fileset>
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 
 		<echo>Deploying the VideoRecorder Tool</echo>
 
Index: lams_tool_vote/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/build.xml,v
diff -u -r1.23 -r1.24
--- lams_tool_vote/build.xml	10 Feb 2012 21:13:21 -0000	1.23
+++ lams_tool_vote/build.xml	6 Mar 2012 11:15:40 -0000	1.24
@@ -73,14 +73,14 @@
 		</target>
 
 		<target name="check-driver-present">
-			<available file="${db.driver.jar}" type="file" property="driver.present"/>
+			<available file="${db.driver.dir}" type="dir" property="driver.present"/>
 		</target>
 		<target name="panic-if-driver-not-present" unless="driver.present">
 			<fail>
 		      The JDBC driver you have specified by including one of the files in ${basedir}/config/database
-		      doesn't exist. You have to download this driver separately and put it in ${db.driver.jar}
+		      doesn't exist. You have to download this driver separately and put it in ${db.driver.dir}
 		      Please make sure you're using a version that is equal or superior to the one we looked for.
-		      If you name the driver jar file differently, please update the db.driver.jar property
+		      If you name the driver jar file differently, please update the db.driver.dir property
 		      in the ${basedir}/config/database/xxx.xml file accordingly.
 		     </fail>
 	   </target>
@@ -93,7 +93,7 @@
 			<middlegen appname="lams_tool_vote11" 
 					   prefsdir="${conf.middlegen.dir}"
 					   gui="${middlegen.gui}"
-					   databaseurl="${db.url}"
+					   databaseurl="${db.url.build}"
 					   driver="${db.driver}"
 					   username="${db.username}"
 					   password="${db.password}"
@@ -302,10 +302,10 @@
 		<!-- =================================================================== -->
 		<target name="rebuild-db"
 			description="rebuild Voting tables">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_vote.sql"/>
 				<transaction src="${db.scripts}/create_lams_tool_vote.sql"/>
@@ -318,10 +318,10 @@
 		<!-- =================================================================== -->
 		<target name="clean-tool-db"
 			description="rebuild Voting tables">
-			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+			<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}"
 					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
-					<pathelement location="${db.driver.jar}"/>
+					<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 				</classpath>
 				<transaction src="${db.scripts}/drop_lams_tool_vote.sql"/>
 			</sql>
@@ -334,14 +334,17 @@
 		<target name="create-deploy-package" depends="lams-vote11-war" 
 			description="Generate the deployment package.">
 
-			<path id="deploy.lib.classpath">
-				<fileset dir="${deploy.tool.dir}">
-					<include name="lib/*.jar"/>
-				</fileset>
-			</path> 
+				<path id="deploy.lib.classpath">
+					<fileset dir="${deploy.tool.dir}">
+						<include name="lib/*.jar" />
+					</fileset>
+					<fileset dir="${sharedlib}">
+						<include name="**/*.jar" />
+					</fileset>
+				</path>
 				  
 			<mkdir dir="${build.deploy}"/>
-			<mkdir dir="${build.deploy}/lib"/> 
+			
 			<mkdir dir="${build.deploy}/sql"/> 
 			<mkdir dir="${build.deploy}/language"/>
 			 
@@ -385,12 +388,6 @@
 				</fileset>
 			</copy>
 
-			<copy overwrite="yes" todir="${build.deploy}/lib">
-				<fileset dir="${deploy.tool.dir}/lib">
-					<include name="*.jar"/>
-				</fileset>
-			</copy>
-
 			<copy overwrite="yes" todir="${build.deploy}/language">
 				<fileset dir="${conf.language.dir}">
 					<include name="*.properties"/>
@@ -415,7 +412,7 @@
 				generateForInstallers="${generate.for.installers}"
 				dbPassword="${db.password}"
 				dbUsername="${db.username}"
-				dbDriverUrl="${db.url}"
+				dbDriverUrl="${db.url.build}"
 				dbDriverClass="com.mysql.jdbc.Driver"
 				deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar"
 				toolJarFileName="${product}.jar"
@@ -448,10 +445,13 @@
 	
 		<target name="run-deploy-package" description="Run the deploy tool.">
 			<path id="deploy.classpath">
-				<fileset dir="${build.deploy}">
-					<include name="lib/*.jar"/>
+				<fileset dir="${deploy.tool.dir}/lib">
+					<include name="*.jar" />
 				</fileset>
-			</path> 
+				<fileset dir="${sharedlib}">
+					<include name="**/*.jar" />
+				</fileset>
+			</path>
 
 			<echo>Deploying the Voting tool</echo>
 	
Index: lams_tool_wiki/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_wiki/build.xml,v
diff -u -r1.5 -r1.6
--- lams_tool_wiki/build.xml	30 Jul 2009 18:23:09 -0000	1.5
+++ lams_tool_wiki/build.xml	6 Mar 2012 11:16:16 -0000	1.6
@@ -152,18 +152,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_wiki.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_wiki.sql" />
 		</sql>
@@ -387,10 +387,13 @@
 			<fileset dir="${deploy.tool.dir}">
 				<include name="lib/*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -434,12 +437,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -464,7 +461,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -497,9 +494,12 @@
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<echo>Deploying the Wiki Tool</echo>
Index: lams_tool_wookie/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_wookie/build.xml,v
diff -u -r1.2 -r1.3
--- lams_tool_wookie/build.xml	6 Aug 2009 04:29:49 -0000	1.2
+++ lams_tool_wookie/build.xml	6 Mar 2012 11:16:23 -0000	1.3
@@ -135,18 +135,18 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/drop_lams_tool_wookie.sql" />
 		</sql>
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
+		<sql driver="${db.driver}" url="${db.url.build}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
-				<pathelement location="${db.driver.jar}" />
+				<fileset dir="${db.driver.dir}" includes="*.jar"/> 
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_tool_wookie.sql" />
 		</sql>
@@ -336,14 +336,17 @@
 	<!-- =================================================================== -->
 	<target name="create-deploy-package" depends="build-war" description="Generate the deployment package.">
 
-		<path id="deploy.lib.classpath">
-			<fileset dir="${deploy.tool.dir}">
-				<include name="lib/*.jar" />
-			</fileset>
-		</path>
+	<path id="deploy.lib.classpath">
+		<fileset dir="${deploy.tool.dir}">
+			<include name="lib/*.jar" />
+		</fileset>
+		<fileset dir="${sharedlib}">
+			<include name="**/*.jar" />
+		</fileset>
+	</path>
 
 		<mkdir dir="${build.deploy}" />
-		<mkdir dir="${build.deploy}/lib" />
+		
 		<mkdir dir="${build.deploy}/sql" />
 		<mkdir dir="${build.deploy}/lang" />
 
@@ -387,12 +390,6 @@
 			</fileset>
 		</copy>
 
-		<copy overwrite="yes" todir="${build.deploy}/lib">
-			<fileset dir="${deploy.tool.dir}/lib">
-				<include name="*.jar" />
-			</fileset>
-		</copy>
-
 		<copy overwrite="yes" todir="${build.deploy}/language">
 			<fileset dir="${conf.language.dir}">
 				<include name="*.properties" />
@@ -417,7 +414,7 @@
 			generateForInstallers="${generate.for.installers}"
 			dbPassword="${db.password}" 
 			dbUsername="${db.username}" 
-			dbDriverUrl="${db.url}" 
+			dbDriverUrl="${db.url.build}" 
 			dbDriverClass="com.mysql.jdbc.Driver" 
 			deployFiles="${build.deploy}/${product}.war,${build.deploy}/${product}.jar" 
 			toolJarFileName="${product}.jar"
@@ -450,9 +447,12 @@
 	<target name="run-deploy-package" description="Run the deploy tool.">
 
 		<path id="deploy.classpath">
-			<fileset dir="${build.deploy}">
-				<include name="lib/*.jar" />
+			<fileset dir="${deploy.tool.dir}/lib">
+				<include name="*.jar" />
 			</fileset>
+			<fileset dir="${sharedlib}">
+				<include name="**/*.jar" />
+			</fileset>
 		</path>
 
 		<echo>Deploying the Wookie Tool</echo>