websphere « DataSource « Java Database Q&A

1. WebSphere 5.1: Setting JDBC datasource connection as "unshareable" stackoverflow.com

L.S. Our DB provider has suggested that we use "unshareable" connections when connecting to their DB. I have a reasonable understanding about the pros/cons of using "unshareable" connections, and our programming model ...

2. Data Source configuration on WebSphere 7 stackoverflow.com

I am working on WebSphere application server recently. And now i have to use DataSourceConnectionProvider for it. So i know how to configure it for JBOSS but I need the configuration ...

3. Call to DataSource.getConnection not returning the expected connection stackoverflow.com

I have the following code:

        Hashtable env1 = new Hashtable();

        env1.put(javax.naming.Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
       ...

4. Websphere 6.1, Datasource, two apps stackoverflow.com

I've got a webapp running on a Websphere 6.1 Server which JNDI lookups for a datasource. This webapp runs fine, the Websphere server recognizes the datasource ref in the web.xml etc.. Now ...

5. Accessing a JNDI DataSource without the java:comp/env prefix stackoverflow.com

I've noticed that both ways of looking up a DataSource using JNDI work:

jdbc/DataSource
java:comp/env/jdbc/DataSource

With the added bonus that the first one doesn't seem to anger Websphere when used from an unmanaged thread ...

6. java.lang.IllegalAccessException while setting up data source in websphere stackoverflow.com

While trying to setup a datasource connection in WAS 6.1 through the admin console, I get the error: java.sql.SQLException: java.lang.IllegalAccessExceptionDSRA0010E: SQL State = null, Error Code = 0 Looking up the definition here ...