给你一个连接 相信会对你有帮助
http://www.csdn.net/develop/article/16/16158.shtm

解决方案 »

  1.   

    to raymondcen(无尽的星空) 我基本上是这么做的。
    我用的是oracle数据库
    但是在jboss控制台中提示如下信息:
    org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : 
    datasource-mapping OracleDS not found我的jboss.xml内容如下:
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE jboss PUBLIC '-//JBoss//DTD JBOSS 3.0//EN' 'http://www.jboss.org/j2ee/dtd/jboss_3_0.dtd'>
    <jboss>
        <enterprise-beans>
            <entity>
                <ejb-name>aaa</ejb-name>
                <jndi-name>aaaRemote</jndi-name>
            </entity>
        </enterprise-beans>
    </jboss>
    我的jbosscmp-jdbc.xml内容如下:
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE jbosscmp-jdbc PUBLIC '-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN' 'http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd'>
    <jbosscmp-jdbc>
        <defaults>
            <datasource>java:/OracleDS</datasource>
            <datasource-mapping>OracleDS</datasource-mapping>
            <create-table>true</create-table>
            <remove-table>true</remove-table>
            <pk-constraint>id</pk-constraint>
            <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
        </defaults>
        <enterprise-beans>
            <entity>
                <ejb-name>aaa</ejb-name>
                <table-name>aaa</table-name>
                <cmp-field>
                    <field-name>id</field-name>
                    <column-name>id</column-name>
                </cmp-field>
                <cmp-field>
                    <field-name>aname</field-name>
                    <column-name>aname</column-name>
                </cmp-field>
                <cmp-field>
                    <field-name>adate</field-name>
                    <column-name>adate</column-name>
                </cmp-field>
                <cmp-field>
                    <field-name>rmb</field-name>
                    <column-name>rmb</column-name>
                </cmp-field>
            </entity>
        </enterprise-beans>
    </jbosscmp-jdbc>
      

  2.   

    oracle-ds.xml你配置了没有?
      

  3.   

    to raymondcen(无尽的星空)配置了内容如下:
    <?xml version="1.0" encoding="UTF-8"?>
    <datasources>
      <local-tx-datasource>
        <jndi-name>OracleDS</jndi-name>
        <connection-url>jdbc:oracle:thin:@10.49.253.46:1521:oracle</connection-url>
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <user-name>scott</user-name>
        <password>tiger</password>
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </local-tx-datasource>
    </datasources>
      

  4.   

    确保你的oracle-ds.xml在正确的目录
      

  5.   

    jboss的lib下面有没有Oracle的driver?