WildFly jdbc connection with Oracle

Question

I try to create jdbc connection. I use WildFly Application Server
9.0.0.CR1 and oracle 11g. I put ojdbc14 and created module.xml in the folder C:\wildfly-9.0.0.CR1\modules\com\oracle\ojdbc14\main:

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

and inserted to the standalone.xml:

<subsystem xmlns="urn:jboss:domain:datasources:1.0">     
            <datasources>
             <datasource jndi-name="java:jboss/datasources/accounting" pool-name="OracleDS" enabled="true" use-java-context="true"> 
                <connection-url>jdbc:oracle:thin:@cmx-itm-03:1521/COREJAVA</connection-url> 
                <driver-class>oracle.jdbc.OracleDriver</driver-class> 
                <driver>oracle</driver> 
                <security> 
                <user-name>Java_Learning</user-name> 
                <password>Qazxsw123</password> 
                </security> 
            </datasource> 
            <drivers>
                <driver name="oracle" module="com.oracle.ojdbc14"/> 
            </drivers>
            </datasources>
        </subsystem>

So, I got the error when try test connection from console:

Unexpected HTTP response: 500

Request
{
    "address" => [
        ("subsystem" => "datasources"),
        ("data-source" => "OracleDS")
    ],
    "operation" => "test-connection-in-pool"
}

Response

Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0042: failed to match pool. Check JndiName: java:jboss/datasources/accounting",
    "rolled-back" => true
}

I googled it and tried all that I found but still have this error. Please, help me.

score 0 · Accepted Answer · edited Jul 06 '16 at 21:22

0

This kind of failures are sometimes difficult to fix, because are exceptions from the own server. However check this, check your invalid jndiName in your code.

https://issues.jboss.org/browse/AS7-2199

edited Jul 06 '16 at 21:22

Buhake Sindi

87,898
29
167
228

answered Jun 29 '15 at 11:27

carlos gil

139
3

This problem I resolved by change my jar to ojdbc.jar. But now I got problem when testing connection - Internal Server Error { "outcome" => "failed", "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0042: failed to match pool. Check JndiName: java:/OracleDS", "rolled-back" => true, "response-headers" => {"process-state" => "reload-required"} } – Revival Jun 30 '15 at 08:09
1

Try this, check you pool connections. And tell us what happens . Also there can be a lot of reasons to fail... https://developer.jboss.org/thread/257721 – carlos gil Jun 30 '15 at 08:20

Revival · Answer 2 · 2015-07-01T07:24:28.907

-1

I changed ojdbc14.jar to ojdbc6.jar;
Locate module.xml with ojdbc6.jar to wildfly-home\modules\com\oracle\ojdbc\main;
Change max-pool-size from 0 to 70.

So, it works

edited Jul 01 '15 at 07:24

answered Jun 30 '15 at 12:04

Revival

71
1
2
6

Rather than renaming a Java 1.4 version of the drivers it would be better to obtain the ojdbc6.jar (or preferably odjbc7.jar) from Oracle. – shonky linux user May 10 '16 at 00:54

WildFly jdbc connection with Oracle

2 Answers2

Linked