How to create an web application running on websphere, and which will use the data source provided by websphere?

Question

I'm setting up a web application on websphere, but it can't find the JNDI name of data source provided by webphere.

I'm new to websphere, and haven't used JDNI before, that I found it hard to work on this application directly.

How to create an simple web application which can run on websphere and which uses the data source provided by websphere. Or is there any existing demo I can try?

I think such an application will help me to locate the problem.

If you use a Context lookup, you'll have to declare a new resource reference in the deployment descriptor (web.xml). But that's not all. You'll also have to bind this reference to the server's JDBC resource (ibm-web-bnd.xml). Look at this question : http://stackoverflow.com/q/7167212/2015707. If you need more details, I may give an example. — , Apr 22 '13 at 13:33
@Magleff, please make you comment as an answer, and I will accept it. — Freewind, Apr 25 '13 at 00:10
As you wish. I hope it has been useful and that you managed to use your data source correctly. — , Apr 25 '13 at 07:15

score 4 · Accepted Answer · edited May 23 '17 at 12:13

If you use a Context lookup, you'll have to declare a new resource reference in the deployment descriptor (web.xml) :

<resource-ref>
  <res-ref-name>jdbc/newReference</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
  <res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

But that's not all. You'll also have to bind this new reference to the server's JDBC resource (ibm-web-bnd.xml) :

<resource-ref name="jdbc/newReference" binding-name="jdbc/ressourceOnServer"/>

Note that this mechanism is quite similar to what is done on Glassfish with the sun-web.xml file, except that the binding is a little different :

<resource-ref>
    <res-ref-name>jdbc/newReference</res-ref-name>
    <jndi-name>jdbc/ressourceOnServer</jndi-name>
</resource-ref>

Look at this question : How do I connect to a Websphere Datasource with a given JNDI name?. If you need more details, I may give an example.

score 2 · Answer 2 · answered Apr 22 '13 at 08:50

When you setup a data source in websphere, you're being asked for the JNDI name you want. As far as I know, it is usually something like "jdbc/appname".

Then, if you use JPA, you just put the given name in your persistence.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
    xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
    <persistence-unit name="appname" transaction-type="RESOURCE_LOCAL">

        <non-jta-data-source>jdbc/appname</non-jta-data-source>


        <!-- CLASS TO PERSIST -->

    </persistence-unit>
</persistence>

I now notice that I have the data source listed as non-jta in my application, although I believe WebSphere's data sources are JTA aware. You may want to check that.

Ravi Trivedi · Answer 3 · 2013-04-24T10:28:01.957

Open your Websphere admin console.

Click Resources >> Data Sources.

You will get the list of configured data sources. In the list there will be Default Datasource. Click that. In the configuration form, there is a field called JNDI name. That is the jndi name of the default datasource provided by Websphere.

You can use annotation injection to inject DataSource in your web component.

@Resource(name = "DefaultDatasource")
DataSource ds;

Tutorial is for tomcat but see servlet example and the use of datasource as annotation injection >> http://theopentutorials.com/tutorials/java-ee/servlet/servlet-datasource-resource-injection-in-tomcat/

How to create an web application running on websphere, and which will use the data source provided by websphere?

3 Answers3