Open Liberty is an interesting new OSS Java EE application server that originated from WebSphere Liberty. You can configure Open Liberty to use PostgreSQL as its default data source as follows:
Add directives for <datasource>, <jdbcDriver>, and <library> to the server.xml configuration:
<?xml version="1.0" encoding="UTF-8"?>
<server description="OpenLiberty Java EE 8 Server">
<featureManager>
<feature>javaee-7.0</feature>
</featureManager>
<httpEndpoint id="defaultHttpEndpoint" host="*" httpPort="9080" httpsPort="9443"/>
<keyStore id="defaultKeyStore" password="Liberty"/>
<!-- Postgres coffee-shop-db definition -->
<dataSource id="DefaultDataSource"
jndiName="jdbc/sample"
jdbcDriverRef="postgresql-driver"
type="javax.sql.ConnectionPoolDataSource"
transactional="true">
<properties serverName="coffee-shop-db"
portNumber="5432"
databaseName="postgres"
user="postgres"
password="postgres"/>
</dataSource>
<jdbcDriver id="postgresql-driver"
javax.sql.XADataSource="org.postgresql.xa.PGXADataSource"
javax.sql.ConnectionPoolDataSource="org.postgresql.ds.PGConnectionPoolDataSource"
libraryRef="postgresql-library"/>
<library id="postgresql-library">
<fileset id="PostgreSQLFileset" dir="/opt/ol/wlp/lib"
includes="postgresql-9.4-1201.jar"/>
</library>
</server>The database available via host coffee-shop-db will be accessed through the default Postgres port 5432 with postgres as database name, username and password.
The driver library, here postgresql-9.4-1201.jar, needs to reside in the lib/ directory of the server installation.
The default data source can be used transparently from a Java EE application. Only a single persistence unit needs to be specified in the persistence.xml file, similar to the following snippet:
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
<persistence-unit name="prod" transaction-type="JTA"/>
</persistence>If the application comprises multiple databases, the persistence units are required to specify the JNDI names of their corresponding data source.
Tested with the official Docker image open-liberty:javaee7.
| Published on Java Code Geeks with permission by Sebastian Daschner, partner at our JCG program. See the original article here: PostgreSQL on Open Liberty Opinions expressed by Java Code Geeks contributors are their own. |
