Example express-config.xml for Postgres SQL Database

This file has been updated for the PostgreSQL JDBC Driver version 7.4. Your mileage may vary for older JDBC driver versions.

<context name="postgresDB">
	<description>PGSQL Database</description>
	<jdbc driver="org.postgresql.Driver"
	 url="jdbc:postgresql://yourservername/yourPGSQLDBName"
	 connectFormat="3"
	 login="postgres"
	 password="postgres"
	 cache="y"
	 createTableIndicies="true"/>

		<type-mapping>
			<java-type>INTEGER</java-type>
			<db-type>INTEGER</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>FLOAT</java-type>
			<db-type>NUMERIC</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>VARCHAR</java-type>
			<db-type>VARCHAR</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>LONGVARCHAR</java-type>
			<db-type>TEXT</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BINARY</java-type>
			<db-type>BYTEA</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BLOB</java-type>
			<db-type>BYTEA</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>CLOB</java-type>
			<db-type>TEXT</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BOOLEAN</java-type>
			<db-type>BOOLEAN</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>BIT</java-type>
			<db-type>BOOLEAN</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>DECIMAL</java-type>
			<db-type>DECIMAL</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>REAL</java-type>
			<db-type>DECIMAL</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>TINYINT</java-type>
			<db-type>SMALLINT</db-type>
		</type-mapping>
	<images>%context%/%expresso-dir%/images</images>
	<startJobHandler>n</startJobHandler>
	<showStackTrace>y</showStackTrace>	
	<mailDebug>n</mailDebug>
</context>

 

Last Modified: 25 Oct, 2004