Example expresso-config for SapDB

This configuration works with the latest SapDB version. Please note that you will need to download the 'patched' JDBC driver for SapDB to work with Expresso. You can get them from http://www.sapdb.org/

		<jdbc driver="com.sap.dbtech.jdbc.DriverSapDB" 
			url="jdbc:sapdb://<databaseServer>/<databaseName>"
					 connectFormat="3" 
					 login="yourname"
					 password="yourpassword"
					 cache="y"
					 createTableIndicies="true"
					 skipText="true" 
					escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler"/>

		<type-mapping>
			<java-type>NUMERIC</java-type>
			<db-type>FIXED</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BIGINT</java-type>
			<db-type>INTEGER</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>TINYINT</java-type>
			<db-type>SMALLINT</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>FLOAT</java-type>
			<db-type>FIXED</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BINARY</java-type>
			<db-type>LONG BYTE</db-type>
		</type-mapping>

Last Modified: 1 Sep, 2002