Example express-config.xml for Oracle DBMS

<?xml version="1.0" encoding="ISO-8859-1" ?>

<!DOCTYPE expresso-config PUBLIC
          "-//Jcorporate Ltd//DTD Expresso Configuration 4.0//EN"
          "http://www.jcorporate.com/dtds/expresso-config_4_0.dtd">

<expresso-config>
   <logDirectory>%web-app%WEB-INF/log</logDirectory>
   <strongCrypto>n</strongCrypto>
   <servletAPI>2_3</servletAPI>
   <cryptoKey>Change this to something random</cryptoKey>
   <context name="default">
		<description>Oracle Database</description>
		<jdbc 
			driver="oracle.jdbc.driver.OracleDriver" 
			url="jdbc:oracle:thin:@dev:1521:dev"
			connectFormat="1"
			login="username"
			password="password"

            dateSelectFormat="yyyy-MM-dd"
            dateSelectFunction="TO_CHAR(%s,'YYYY-MM-DD') %s"
            dateUpdateFormat="yyyy-MM-dd"
            dateUpdateFunction="TO_DATE('%s','YYYY-MM-DD')"

			dateTimeSelectFormat="yyyy-MM-dd HH:mm:ss"
			dateTimeSelectFunction="TO_CHAR(%s,'YYYY-MM-DD HH24:MI:SS') %s"
			dateTimeUpdateFormat="yyyy-MM-dd HH:mm:ss"
			dateTimeUpdateFunction="TO_DATE('%s','YYYY-MM-DD HH24:MI:SS')"
			cache="y"
			createTableIndicies="true"
			limitationPosition=""
			escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler">

			<dbWildcard>%</dbWildcard>
		</jdbc>
		<type-mapping>
			<java-type>LONGVARCHAR</java-type>
			<db-type>varchar(4000)</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>DATE</java-type>
			<db-type>DATE</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>DOUBLE</java-type>
			<db-type>FLOAT</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>INTEGER</java-type>
			<db-type>NUMBER</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>DATETIME</java-type>
			<db-type>DATE</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>TIMESTAMP</java-type>
			<db-type>DATE</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BIT</java-type>
			<db-type>NUMBER</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BIGINT</java-type>
			<db-type>NUMBER</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BINARY</java-type>
			<db-type>LONG RAW</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>FLOAT</java-type>
			<db-type>NUMBER</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>REAL</java-type>
			<db-type>NUMBER</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>TINYINT</java-type>
			<db-type>NUMBER</db-type>
		</type-mapping>

	<images>%context%/%expresso-dir%/images</images>
    <startJobHandler>n</startJobHandler>
    <showStackTrace>y</showStackTrace>
    <mailDebug>n</mailDebug>

  </context>
</expresso-config>

Last Modified: 10 Oct, 2002