Example context entity for IBM DB2 on AS400

This assumes of course that you have the DB2 drivers installed and available in your WEB-INF/lib directory.

The login, password, host name, and database name are just examples.

<context name="default">
	<description>default</description>
	<hasSetupTables>true</hasSetupTables>
	<jdbc driver="com.ibm.as400.access.AS400JDBCDriver"
		url="jdbc:as400://host/test"
		connectFormat="3"
		login="test"
		password="test"
		cache="y"
		createTableIndicies="true"
		limitationPosition=""
		dateTimeSelectFormat="yyyy-MM-dd-HH.mm.ss"
		dateTimeUpdateFormat="yyyy-MM-dd-HH.mm.ss"
		dateSelectFormat="yyyy-MM-dd"
		dateUpdateFormat="yyyy-MM-dd"
		timeSelectFormat="HH:mm.ss"
		timeUpdateFormat="HH.mm.ss"    
		escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler"
	/>

		<type-mapping>
			<java-type>LONGVARCHAR</java-type>
			<db-type>LONG VARCHAR</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>VARCHAR</java-type>
			<db-type>VARCHAR</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>TEXT</java-type>
			<db-type>LONG VARCHAR</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BIT</java-type>
			<db-type>CHAR(1)</db-type>
		</type-mapping>
		<images>%context%/%expresso-dir%/images</images>
		<startJobHandler>y</startJobHandler>
		<showStackTrace>y</showStackTrace>
		<mailDebug>n</mailDebug>
	</context>

Last Modified: 28 Oct, 2004