configure postgresql datasource in EAP 6.3 / Wildfly 8

最新推荐文章于 2025-11-24 15:52:13 发布

原创最新推荐文章于 2025-11-24 15:52:13 发布 · 132 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #java

本文详细介绍如何在JBoss Wildfly应用服务器上安装并配置PostgreSQL JDBC驱动及数据源，包括添加模块、安装驱动和创建数据源的具体步骤。

find JBoss / Wildfly application server

./jboss-cli.sh

Install module containing the JDBC Driver. Specify the module name and the location where the jdbc driver has been downloaded:

module add --name=org.postgres --resources=/tmp/postgresql-9.3-1101.jdbc41.jar --dependencies=javax.api,javax.transaction.api

Now install the JDBC Driver on the application server:

/subsystem=datasources/jdbc-driver=postgres:add(driver-name="postgres",driver-module-name="org.postgres",driver-class-name=org.postgresql.Driver)

Finally install the datasource which will connect to the default "postgres" database on localhost:

data-source add --jndi-name=java:/PostGreDS --name=PostgrePool --connection-url=jdbc:postgresql://localhost/postgres --driver-name=postgres --user-name=postgres --password=postgres

ref:

http://www.mastertheboss.com/jboss-server/jboss-datasource/configuring-a-datasource-with-postgresql-and-jboss-wildfly