我们如何从 JBOSS 配置数据库连接? [英] How can we configure database connection from JBOSS?

问题描述

我们可以从 JBOSS 配置数据库连接吗?如果可以的话，JBOSS里有没有配置文件可以配置JBOSS的数据库连接?

Can we configure database connection from JBOSS? If it is possible, than is there any configuration file in JBOSS to configure database connection from JBOSS?

推荐答案

你需要做两件事:

1. 使 JDBC 驱动程序可用于您的应用程序服务器
2. 编写数据源配置

对于#1，您可以下载包含 JDBC 驱动程序的 JAR 并将其放在以下目录中:

For #1, you can download the JAR containing JDBC driver and put it in the following directory:

$JBOSS_HOME/server/default/lib

假设 $JBOSS_HOME 指向您的 JBoss 安装，并且您使用的是 default 安装.

Assuming that $JBOSS_HOME points to your JBoss installation, and you are using default installation.

对于#2，您会在这里找到很多示例:

For #2, you will find a lot of examples here:

$JBOSS_HOME/docs/examples/jca

周围有大多数数据库产品的示例.这是 PostgreSQL 的:

There are examples for most of database products around. Here's PostgreSQL's:

<datasources>
  <local-tx-datasource>
    <jndi-name>PostgresDS</jndi-name>
    <connection-url>jdbc:postgresql://[servername]:[port]/[database name]</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <user-name>x</user-name>
    <password>y</password>
        <!-- sql to call when connection is created.  Can be anything, select 1 is valid for PostgreSQL
        <new-connection-sql>select 1</new-connection-sql>
        -->

        <!-- sql to call on an existing pooled connection when it is obtained from pool.  Can be anything, select 1 is valid for PostgreSQL
        <check-valid-connection-sql>select 1</check-valid-connection-sql>
        -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>PostgreSQL 7.2</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>

这篇关于我们如何从 JBOSS 配置数据库连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！