Test Database Connection on WebSphere Admin console is not a "full" test connection

  • 30 Jan, 2012

A developer got this error

Error = Invalid Oracle URL specified DSRA0010E: SQL State = 99999, Error Code = 17,067

 when use the code bellow:

private void connectLookup() throws Exception {
try {
                InitialContext ctx = new InitialContext();
                DataSource ds = (DataSource) ctx.lookup(“jdbc/abcd1234”);
                connection = ds.getConnection();

if (connection == null) {
throw new Exception(“Connection error….bla…bla..bla.”);
                }
        } catch (Exception e) {
                e.printStackTrace();
throw e;
        }
}

When you test the connection on the websphere admin console everything is fine

Image:JDBC Connection and error

The problem was i forgot to set the field Authentication Alias for XA recovery.

Image:JDBC Connection and error

Related Posts

WebSphere Application Server Configuration Comparison Tool

  • 06 Sep, 2019

The Configuration Comparison Tool (CCT) is a lightweight wsadmin script and Python report generation script which will produce HTML reports on configuration settings for the following types of resourc

WebSphere Application Server Configuration Comparison ToolRead More

Configuring Cross Origin Resource Sharing on a Liberty server

  • 08 Mar, 2018

You can enable Cross Origin Resource Sharing (CORS) for your web applications on a Liberty server. Enabling CORS will allow JavaScript clients to make requests against your application on the Liberty

Configuring Cross Origin Resource Sharing on a Liberty serverRead More

Recommended values for web server plug-in config

  • 26 Sep, 2017

In the web server plug-in, what do the LoadBalanceWeight, MaxConnections, ConnectTimeout, ServerIOTimeout, RetryInterval, IgnoreAffinityRequests, and GetDWLMTable options mean and what are the recomme

Recommended values for web server plug-in configRead More