B.8. Ingres
Example B.25. Ingres Datasource
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>IngresDS</jndi-name> <use-java-context>false</use-java-context> <driver-class>com.ingres.jdbc.IngresDriver</driver-class> <connection-url>jdbc:ingres://localhost:II7/testdb</connection-url> <datasource-class>com.ingres.jdbc.IngresDataSource</datasource-class> <datasource-property name="ServerName">localhost</datasource-property> <datasource-property name="PortName">II7</datasource-property> <datasource-property name="DatabaseName">testdb</datasource-property> <datasource-property name="User">testuser</datasource-property> <datasource-property name="Password">testpassword</datasource-property> <new-connection-sql>select count(*) from iitables</new-connection-sql> <check-valid-connection-sql>select count(*) from iitables</check-valid-connection-sql> <metadata> <type-mapping>Ingres</type-mapping> </metadata> </local-tx-datasource> </datasources>