dbloader.xml

JA-SIG Home
About uPortal
dbloader.xml

<?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/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/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>HypersonicSQL</db-name>
    <db-version>1.7.0</db-version>
    <driver-name>HypersonicSQL Driver</driver-name>
    <driver-version>1.7.0</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>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  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>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.40-log</db-version>
    <driver-name>Mark Matthews' MySQL Driver</driver-name>
    <driver-version>2.0.4</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.40-log</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.40-log</db-version>
    <driver-name>Mark Matthews' MySQL Driver</driver-name>
    <driver-version>2.0.11</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>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>
  </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>
  </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>
  </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>
  </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>
  </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>
  </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>
JA-SIG Home
About uPortal
FAQ
Download
Documentation
Getting Involved
Code Repository
Reporting Bugs
License