Setting up a datasource with WebSphere Liberty Profile 8.5

Question

My web app is getting a data source from JNDI with:

javax.naming.InitialContext ctx = new javax.naming.InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource) 
    ctx.lookup("java:comp/env/jdbc/db");

In the app's WEB-INF/web.xml, I have:

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

In the app's WEB-INF/ibm-web-bnd.xml, I have:

<web-bnd
    xmlns="http://websphere.ibm.com/xml/ns/javaee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://websphere.ibm.com/xml/ns/javaee http://websphere.ibm.com/xml/ns/javaee/ibm-web-bnd_1_0.xsd"
    version="1.0">
    <virtual-host name="default_host"/>
    <resource-ref name="jdbc/db" binding-name="jdbc/db"/>
</web-bnd>

In WebSphere Liberty Profile's server.xml, I have (keeping on the relevant parts):

<server description="new server">

    <featureManager>
        <feature>jsp-2.2</feature>
        <feature>jdbc-4.0</feature>
    </featureManager>

    <library id="oracle-lib">
        <fileset dir="lib" includes="ojdbc5_g.jar"/>
    </library>

    <dataSource jndiName="jdbc/db" jdbcDriverRef="oracle-driver" type="javax.sql.DataSource">
        <jdbcDriver libraryRef="oracle-lib" id="oracle-driver"/>
        <connectionManager numConnectionsPerThreadLocal="10" id="ConnectionManager" minPoolSize="1"/>
        <properties user="user" password="password"
                    url="jdbc:oracle:thin:@//db-server:1521/db"/>
    </dataSource>

</server>

When the app attempts to get the datasource from JNDI, it fails with the following error:

CWNEN0030E: The @Resource factory encountered a problem getting
the object instance jdbc/oracle binding object.  The exception message was: 
failed to resolve jdbc/oracle to javax.sql.DataSource: 
javax.naming.NameNotFoundException: 
Intermediate context does not exist: jdbc/oracle

What I am missing here?

score 12 · Accepted Answer · edited Dec 14 '16 at 03:56

WebSphere server.xml

<server>    
    <featureManager>
        <feature>jndi-1.0</feature>
        <feature>jdbc-4.1</feature>
    </featureManager>

    <httpEndpoint id="defaultHttpEndpoint"
                  host="localhost"
                  httpPort="9080"
                  httpsPort="9443" />

    <library id="oracle-lib">
        <fileset dir="lib" includes="ojdbc6_g.jar"/>
    </library>

    <dataSource jndiName="jdbc/oracle">
        <jdbcDriver libraryRef="oracle-lib"/>
        <properties.oracle user="orbeon" password="password"
                           url="jdbc:oracle:thin:@//localhost:1521/orbeon"/>
    </dataSource>

    <application name="orbeon" location="war/orbeon" type="war">
        <classloader commonLibraryRef="oracle-lib"/>
    </application>    
</server>

WEB-INF/ibm-web-bnd.xml

<web-bnd version="1.0"
        xmlns="http://websphere.ibm.com/xml/ns/javaee"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://websphere.ibm.com/xml/ns/javaee http://websphere.ibm.com/xml/ns/javaee/ibm-web-bnd_1_0.xsd">
    <virtual-host name="default_host"/>
    <resource-ref name="jdbc/oracle" binding-name="jdbc/oracle"/>
</web-bnd>

WEB-INF/web.xml

<resource-ref>
    <res-ref-name>jdbc/oracle</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

Resource injection (instead of web.xml + ibm-web-bnd.xml):

@Resource(lookup = "jdbc/oracle")
DataSource ds;

I have Websphere Liberty Profile 8.5.5.9, and `WEB-INF/ibm-web-bnd.xml` isn't required by that. Also, for my app just including the ojdbc jar wasn't enough, it needed the orai18n jar as well. `` worked. — sigint, May 21 '16 at 10:10

score 3 · Answer 2 · answered Jul 25 '13 at 06:59

3

we use DB2 on Liberty 8.5.5 and we have in server.xml

<dataSource id="db2" isolationLevel="TRANSACTION_READ_COMMITTED" jndiName="jdbc/db2" type="javax.sql.DataSource">
    <jdbcDriver>
        <library>
            <fileset dir="/usr/lib/java/ibm-db2-universal-driver" includes="db2jcc4.jar, db2jcc_license_cisuz.jar, db2jcc_license_cu.jar"/>
        </library>
    </jdbcDriver>

    <properties.db2.jcc databaseName="DB2T" portNumber="21020" serverName="db2t.lvm.de"/>
    <containerAuthData password="{xor}KzspMC04" user="tdvorg"/>
</dataSource>

Maybe helps that.

Robert

answered Jul 25 '13 at 06:59

Robert

126
11

Yes, placing the `` inside the `` as you did worked for me. However, I ended up with a ClassCastException` as the classes in the driver where loaded by 2 different classloader: the one in the application and the one for the driver. (I am sure that in lots of cases this is fine, as long as you don't directly use the driver classes.) So I reverted to a top-level library declaration and got it to work. I answered my own question with the setup I used, but this definitely helped! – avernet Jul 27 '13 at 05:56
3

You might wanna hide your user/pass for the db instance if it is not a public database – danial Feb 18 '14 at 19:40
Do we have GUI to do these changes as we have in WAS. – Venkata Ramireddy CH Aug 20 '14 at 09:20

score 0 · Answer 3 · edited Oct 26 '15 at 18:17

In my case, the solution below works fine for me.

I created a "Generic project" in Eclipse called "Resources". Inside this project I created a file dataSource.xml with following content:

<server>
    <dataSource id="ccm" jndiName="jdbc/ccm" type="javax.sql.DataSource">
        <jdbcDriver id="oracle-driver" libraryRef="oracle-lib"/>
        <connectionManager id="ConnectionManager" minPoolSize="1" numConnectionsPerThreadLocal="10"/>
        <properties.oracle password="password" url="jdbc:oracle:thin:@128.1.30.150:1521:ccmdes" user="ccm"/>
    </dataSource>

   <library id="oracle-lib">
        <fileset dir="C:\Oracle\product\10.1.0\Client_1\jdbc\lib" includes="ojdbc14_g.jar"/>
    </library>

    <jdbcDriver id="oracle" libraryRef="oracle-lib"/>

</server>

And I drag and drop this file for server configuration in Eclipse or create the line in server.xml:

<include location="${shared.config.dir}/dataSource.xml"/>

The file server.xml was like this:

<server description="new server">

    <!-- Enable features -->
    <featureManager>
        <feature>jsp-2.3</feature>
        <feature>adminCenter-1.0</feature>
        <feature>jdbc-4.1</feature>
        <feature>jndi-1.0</feature>
        <feature>servlet-3.1</feature>
    </featureManager>

    <httpEndpoint host="localhost" httpPort="9080" httpsPort="9443" id="defaultHttpEndpoint"/>

    <applicationMonitor updateTrigger="mbean"/>                 

<!-- Define your admin user name and password -->
    <quickStartSecurity userName="admin" userPassword="password"/>

<!-- Define a keystore for the HTTPS port -->
    <keyStore id="defaultKeyStore" password="Liberty"/> 

<!-- Allows remote file access for config changes -->
<remoteFileAccess>
  <writeDir>${server.config.dir}</writeDir>
</remoteFileAccess> 

    <!-- <applicationMonitor updateTrigger="mbean"/> -->
    <webApplication id="TestPage" location="TestPage.war" name="TestPage"/>
    <webApplication id="MonitoriaAtendimento" location="MonitoriaAtendimento.war" name="MonitoriaAtendimento"/>

    <include location="${shared.config.dir}/dataSource.xml"/>
</server>

Setting up a datasource with WebSphere Liberty Profile 8.5

3 Answers3

WebSphere server.xml

WEB-INF/ibm-web-bnd.xml

WEB-INF/web.xml

Resource injection (instead of web.xml + ibm-web-bnd.xml):

Linked