Example Properties file for IBM DB2

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

The login and passwords are just examples.

<jdbc
    driver="COM.ibm.db2.jdbc.app.DB2Driver"
    url="jdbc:db2:DOSE"
    connectFormat="1"
    login="admin"
    password="admin"
    cache="y"
	createTableIndicies="y"
	escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler"
/>

		<type-mapping>
			<java-type>LONGVARCHAR</java-type>
			<db-type>VARCHAR(240)</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>DATALINK</java-type>
			<expresso-type>VARCHAR(240)</expresso-type>
		</type-mapping>
		<type-mapping>
			<java-type>BIGINT</java-type>
			<expresso-type>long</expresso-type>
		</type-mapping>
		<type-mapping>
			<java-type>BIT</java-type>
			<db-type>CHAR</db-type>
		</type-mapping>
		<type-mapping>
			<expresso-type>text</expresso-type>
			<db-type>CLOB</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>FLOAT</java-type>
			<db-type>FLOAT</db-type>
		</type-mapping>

Last Modified: 08-Sept-02