wildfly10 append postgresql driver & datasource

最新推荐文章于 2024-10-21 09:35:00 发布

dougfii

最新推荐文章于 2024-10-21 09:35:00 发布

阅读量821

点赞数

分类专栏： jboss/wildfly 文章标签： postgresql wildfly jboss

本文链接：https://blog.csdn.net/dougfii/article/details/51312021

版权

jboss/wildfly 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

append postgresql driver module to wildfly moudules

wget postgresql-9.4.1208.jar form http://jdbc.postgresql.org

cd ${WILDFLY_HOME}/modules/system/layers/base/org/

mkdir -p postgresql/main/

cp postgresql-9.4.1208.jar ./

vi module.xml

[ module.xml ]

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.3" name="org.postgresql">
    <resources>
        <resource-root path="postgresql-9.4.1208.jar"/>
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
        <module name="javax.servlet.api" optional="true"/>
    </dependencies>
</module>

modify standalone.xml file

cd ${WILDFLY_HOME}/standalone/configuration/
vi standalone.xml

[ standalone.xml ]

<subsystem xmlns="urn:jboss:domain:datasources:4.0">
    <datasources>
        <datasource jndi-name="java:jboss/datasources/dbname" pool-name="dbname-pool" enabled="true" use-ccm="true" jta="true">
            <connection-url>jdbc:postgresql://127.0.0.1:5432/dbname</connection-url>
            <driver-class>org.postgresql.Driver</driver-class>
            <driver>postgresql</driver>
            <security>
                <user-name>postgres</user-name>
                <password>xxxxxxxx</password>
            </security>
            <validation>
                <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>
                <background-validation>true</background-validation>
                <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>
            </validation>
        </datasource>
        <drivers>
            <driver name="postgresql" module="org.postgresql">
                <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
            </driver>
        </drivers>
    </datasources>
</subsystem>