<?xml version="1.0"?> <properties xmlns="http://www.jasig.org/uPortal/database/properties"> <!-- Set to false to disable execution of DROP, CREATE, and/or POPULATE TABLE SQL statements --> <drop-tables>true</drop-tables> <create-tables>true</create-tables> <populate-tables>true</populate-tables> <!-- Location of tables.xml file --> <tables-uri>/properties/db/tables.xml</tables-uri> <!-- Location of tables.xsl stylesheet --> <tables-xsl-uri>tables.xsl</tables-xsl-uri> <!-- Location of data.xml file --> <data-uri>/properties/db/data.xml</data-uri> <!-- DbLoader can dump DROP, CREATE, and INSERT statements to a file. If <create-script> is set to true, the script file will be created in <portal base directory>/properties --> <create-script>false</create-script> <script-file-name>dbloader.script</script-file-name> <statement-terminator>;</statement-terminator> <!-- Mappings for cases where database metadata is incomplete. "db-name", "db-version", "driver-name", and "driver-version" must match the values returned by java.sql.Connection.getMetaData().getDatabaseProductName(), java.sql.Connection.getMetaData().getDatabaseProductVersion(), java.sql.Connection.getMetaData().getDriverName(), and java.sql.Connection.getMetaData().getDriverVersion() --> <db-type-mapping> <db-name>HypersonicSQL</db-name> <db-version>1.4</db-version> <driver-name>HypersonicSQL Driver</driver-name> <driver-version>1.4</driver-version> <type><generic>INTEGER</generic><local>INTEGER</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>LONGVARCHAR</generic><local>LONGVARCHAR</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>InstantDB</db-name> <db-version>Version 3.26</db-version> <driver-name>InstantDB JDBC Driver</driver-name> <driver-version>Version 3.26</driver-version> <type><generic>LONGVARCHAR</generic><local>BINARY</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Microsoft SQL Server</db-name> <db-version>08.00.0760</db-version> <driver-name>jTDS Type 4 JDBC Driver for MS SQL Server and Sybase</driver-name> <type><generic>INTEGER</generic><local>INTEGER</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>TEXT</generic><local>TEXT</local></type> <type><generic>TIMESTAMP</generic><local>DATETIME</local></type> <type><generic>LONGVARCHAR</generic><local>NTEXT</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Microsoft SQL Server</db-name> <db-version>07.00.0699</db-version> <driver-name>JDBC-ODBC Bridge (SQLSRV32.DLL)</driver-name> <driver-version>2.0001 (03.70.0820)</driver-version> <type><generic>INTEGER</generic><local>INTEGER</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>TIMESTAMP</generic><local>DATETIME</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Microsoft SQL Server</db-name> <db-version>Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3) </db-version> <driver-name>SQLServer</driver-name> <driver-version>2.2.0029</driver-version> <type><generic>INTEGER</generic><local>INTEGER</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>TIMESTAMP</generic><local>DATETIME</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Microsoft SQL Server</db-name> <db-version>Microsoft SQL Server 7.00 - 7.00.699 (Intel X86) May 21 1999 14:08:18 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4) </db-version> <driver-name>weblogic.jdbc.mssqlserver4.Driver</driver-name> <driver-version>3.1</driver-version> <type><generic>TIMESTAMP</generic><local>DATETIME</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Microsoft SQL Server 2000</db-name> <db-version>8.00.760</db-version> <driver-name>SQLServer</driver-name> <driver-version>2.2.0040</driver-version> <type><generic>INTEGER</generic><local>INTEGER</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>LONGVARCHAR</generic><local>LONGVARCHAR</local></type> <type><generic>SQL_VARIANT</generic><local>VARCHAR</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>MySQL</db-name> <db-version>3.23.34a</db-version> <driver-name>Mark Matthews' MySQL Driver</driver-name> <driver-version>1.2b</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>MySQL</db-name> <db-version>3.23.41</db-version> <driver-name>Mark Matthews' MySQL Driver</driver-name> <driver-version>2.0.7</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>MySQL</db-name> <db-version>3.23.43</db-version> <driver-name>Mark Matthews' MySQL Driver</driver-name> <driver-version>1.2b</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>MySQL</db-name> <db-version>3.23.43</db-version> <driver-name>Mark Matthews' MySQL Driver</driver-name> <driver-version>2.0.7</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>MySQL</db-name> <db-version>3.23.46</db-version> <driver-name>Mark Matthews' MySQL Driver</driver-name> <driver-version>2.0.8</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Oracle</db-name> <!-- Line break has to be here --> <db-version>Oracle8 Enterprise Edition Release 8.0.6.2.0 - Production PL/SQL Release 8.0.6.2.0 - Production</db-version> <driver-name>Oracle JDBC driver</driver-name> <driver-version>8.1.6.0.0</driver-version> <type><generic>TIMESTAMP</generic><local>DATE</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Oracle</db-name> <!-- Line breaks have to be here --> <db-version>Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production</db-version> <driver-name>Oracle JDBC driver</driver-name> <driver-version>8.1.7.0.0</driver-version> <type><generic>TIMESTAMP</generic><local>DATE</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Oracle</db-name> <!-- Line breaks have to be here --> <db-version>Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production</db-version> <driver-name>Oracle JDBC driver</driver-name> <driver-version>9.2.0.3.0</driver-version> <type><generic>TIMESTAMP</generic><local>DATE</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>Oracle</db-name> <!-- Line breaks have to be here --> <db-version>Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production</db-version> <driver-name>Oracle JDBC driver</driver-name> <driver-version>9.2.0.3.0</driver-version> <type><generic>TIMESTAMP</generic><local>DATE</local></type> <!-- map more types here --> </db-type-mapping> <db-type-mapping> <db-name>PostgreSQL</db-name> <db-version>7.2.1</db-version> <driver-name>PostgreSQL Native Driver</driver-name> <driver-version>PostgreSQL 7.2.1 JDBC2</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>LONGVARBINARY</generic><local>BYTEA</local></type> <type><generic>VARBINARY</generic><local>BYTEA</local></type> <type><generic>INTEGER</generic><local>integer</local></type> </db-type-mapping> <db-type-mapping> <db-name>PostgreSQL</db-name> <db-version>7.2.1</db-version> <driver-name>PostgreSQL Native Driver</driver-name> <driver-version>PostgreSQL 7.4.3 JDBC3 with SSL (build 214)</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>LONGVARBINARY</generic><local>BYTEA</local></type> <type><generic>VARBINARY</generic><local>BYTEA</local></type> <type><generic>INTEGER</generic><local>integer</local></type> </db-type-mapping> <db-type-mapping> <db-name>PostgreSQL</db-name> <db-version>7.2</db-version> <driver-name>PostgreSQL Native Driver</driver-name> <driver-version>PostgreSQL 7.2 JDBC2</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>INTEGER</generic><local>integer</local></type> </db-type-mapping> <db-type-mapping> <db-name>PostgreSQL</db-name> <db-version>7.1.3</db-version> <driver-name>PostgreSQL Native Driver</driver-name> <driver-version>PostgreSQL 7.1.3 JDBC2</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>INTEGER</generic><local>integer</local></type> </db-type-mapping> <db-type-mapping> <db-name>PostgreSQL</db-name> <db-version>7.1.2</db-version> <driver-name>PostgreSQL Native Driver</driver-name> <driver-version>PostgreSQL 7.1.3 JDBC2</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>INTEGER</generic><local>integer</local></type> </db-type-mapping> <db-type-mapping> <db-name>PostgreSQL</db-name> <db-version>7.1.2</db-version> <driver-name>PostgreSQL Native Driver</driver-name> <driver-version>PostgreSQL 7.1.2 JDBC2</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>INTEGER</generic><local>integer</local></type> </db-type-mapping> <db-type-mapping> <db-name>PostgreSQL</db-name> <db-version>6.5.2</db-version> <driver-name>PostgreSQL Native Driver</driver-name> <driver-version>7.0</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>INTEGER</generic><local>integer</local></type> </db-type-mapping> <db-type-mapping> <db-name>Sybase SQL Server</db-name> <db-version>Adaptive Server Enterprise/11.9.2.3/1159/P/SWR 9222 ESD 3/RS6000/AIX 4.2.1/FBO/Tue Sep 5 07:09:31 2000</db-version> <driver-name>jConnect (TM) for JDBC (TM)</driver-name> <driver-version>jConnect (TM) for JDBC(TM)/5.2(Build 20765)/P/EBF9109/JDK12/Fri Jun 16 9:31:01 2000</driver-version> <type><generic>INTEGER</generic><local>INTEGER</local></type> <type><generic>VARCHAR</generic><local>VARCHAR</local></type> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> <type><generic>TIMESTAMP</generic><local>DATETIME</local></type> <!-- map more types here --> </db-type-mapping> </properties>
Manage space
Manage content
Integrations