Jboss里使用JNDI设置Derby数据源

1.  到这个/docs/examples/jca目录下，找到Derby设置数据源的sample文件derby-ds.xml

2.  copy derby-ds.xml文件到/server/default/deploy目录下(默认的发布路径)

3.  修改derby-ds.xml

 

<datasources> <local-tx-datasource> <!-- The jndi name of the DataSource, it is prefixed with java:/ --> <!-- Datasources are not available outside the virtual machine --> <jndi-name>jdbc/sampleDS</jndi-name> <!-- for in-process persistent db, saved when jboss stops. The org.jboss.jdbc.DerbyDatabase mbean is necessary for properly db shutdown --> <connection-url>jdbc:derby:D:/Databases/sampleDB;create=false</connection-url> <!-- The driver class --> <driver-class>org.apache.derby.jdbc.EmbeddedDriver</driver-class> <!-- The login and password --> <user-name></user-name> <password></password> <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use --> <min-pool-size>5</min-pool-size> <!-- The maximum connections in a pool/sub-pool --> <max-pool-size>20</max-pool-size> <!-- The time before an unused connection is destroyed --> <idle-timeout-minutes>5</idle-timeout-minutes> <!-- Whether to check all statements are closed when the connection is returned to the pool, this is a debugging feature that should be turned off in production --> <track-statements/> <!-- This mbean can be used when using in process persistent derby --> <!-- <depends>jboss:service=Derby</depends> --> </local-tx-datasource> <!-- <mbean code="org.jboss.jdbc.DerbyDatabase" name="jboss:service=Derby"/> --> </datasources>

 

 

4. copy 这个jar(derby*.jar)到/jboss-x.x.x/server/default/lib

 

5. 在项目WEB-INF/目录下的web.xml文件中加入下面的代码

<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/sampleDS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>

 

6. 在项目WEB-INF/ 目录下添加jboss-web.xml文件，并且加入如下代码

<jboss-web> <resource-ref> <res-ref-name>jdbc/sampleDS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <jndi-name>java:jdbc/sampleDS</jndi-name> </resource-ref> </jboss-web>