[jboss-user] [Datasource Configuration] - Re: Error in JBoss 7.1.0 datasource configuration

[Areak Huang]

Areak Huang [https://community.jboss.org/people/areakbaby] created the discussion

"Re: Error in JBoss 7.1.0 datasource configuration"

To view the discussion, visit: https://community.jboss.org/message/726832#726832

--------------------------------------------------------------
I know how to bound the datasource.I use AS7.1

First at standalone.xml or domain.xml

<subsystem xmlns="urn:jboss:domain:datasources:1.0">
            <datasources>
                <datasource jndi-name="*java:jboss/OracleDS*" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
                    <connection-url>
                       jdbc:oracle:thin:@*.*.*.:1521:*
                    </connection-url>
                    <driver>
*oracle*
                    </driver>
                    <transaction-isolation> TRANSACTION_READ_COMMITTED </transaction-isolation>
                     <pool>
                                                                                <min-pool-size> 20 </min-pool-size>
                                                                                <max-pool-size> 300</max-pool-size>
                                                                 </pool>                    
                    <security>
                        <user-name>*</user-name>
                         <password>*</password>
                    </security>                    
                                                  <statement>
                                                                      <prepared-statement-cache-size> 100 </prepared-statement-cache-size>
                                                                      <share-prepared-statements/>
                                                  </statement>                    
                 </datasource>
 *<drivers>*
*                    <driver name="oracle" module="com.oracle.ojdbc14">*
*                       <driver-class>oracle.jdbc.OracleDriver</driver-class>* 
*                    </driver>*
                </drivers>
            </datasources>
        </subsystem>

then remember to add folder like this:     *jboss-as-7.1.0.Final\modules\com\oracle\ojdbc14\main*

in the "main" folder you must create module.xml and ojdbc14.jar

module.xml:

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.1" name="com.oracle.ojdbc14">
    <resources>
        <resource-root path="ojdbc14.jar"/>
        <!-- Insert resources here -->
    </resources>
    <dependencies>
        <module name="javax.api"/>
                    <module name="javax.transaction.api"/>
    </dependencies>
</module>

so, you can start the server, and input  http://localhost:9990/.can http://localhost:9990/ you can see the datasource:

Name                                               JNDI                                             Enabled?
| java:jboss/OracleDS                   | OracleDS                                      | true |
| 
 | 
 | 
 |


OK.
Areak.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/726832#726832]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120328/27eb9c0c/attachment-0001.html