common database related issues with Weblogic Server

<BEA-001112> <Test “SELECT 1 FROM DUAL” set up for pool “Test” failed with exception: “java.sql.SQLException: Io exception: Connection reset by peer: socket write error”.>

Network or the DBMS is killing the connection, you need to check with the Database Admin and the network Admin.

java.lang.ClassCastException: oracle.jdbc.driver.LogicalConnection incompatible with oracle.jdbc.OracleCo

Check if you’ve got multiple versions of the driver in your environment, serverlib, domainlib or added in the server classpath in the startWeblogic.cmd. Keep only one driver in your environment.

ORA-28267: Invalid NameSpace value

This is fixed by Patch 13923804 – Patch Set Update (11G database patch)

weblogic.common.ResourceException: IO Error: Connection reset atweblogic.jdbc.common.internal.XAConnectionEnvFactory.makeConnection(

Try to set the initial capacity of the datasource to zero.

Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource ‘Operational’: XAER_RMERR : A resource manager error has occured in the transaction branch

Issue can occur when you create tables using 10g client on 11g database. Recreate the tables with 11g client.

XAER_RMFAIL : Resource manager is unavailable

Keep your maximum and minimum connection as same.
Set this to true
Keep XA Connection Until Transaction Complete
Check with DBA on the number of process & sessions.

Error when getting datasource
0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Locale not recognized

This is due to the locale configuration of the server.
You can start WLS with the following JVM Params and also make sure the client browser has the correct locale setting.


If it still doesnt solve the issue you can try to set the locale programmatically before getting connection.

return DriverManager.getConnection(URL, username, password);

Caused by: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAER_PROTO : Routine was invoked in an inproper context start() failed on resource ‘MSD_CONN_POOL’: XAER_PROTO : Routine was invoked in an inproper context

This is a known issue and is fixed in 10.3.1
You can set Test Connection on Reserve to true.

java.sql.SQLException: Result set already closed

This is a coding isssue. Avoid calling a closed resultset.

EXCEPTION: (12021) Cannot obtain new connection.

Please make sure your ojdbc14.jar is there in the classpath.
weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool

Check application code if the connections, resultset and jdbc statements have been closed properly.

ExecuteThread: ‘0’ for queue: ‘weblogic.kernel.Default (self-tuning)'” RUNNABLE native Method)
weblogic.jdbc.sqlserver.SQLServerByteOrderedDataReader.makeMoreDataAvailable(Unknown Source)

This is a known issue with MS SQL Server and WLS 10.3 to 10.3.6. Please set the following connection properties.


DatabaseException caused by prior exception: java.sql.SQLException: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Following the steps here generally resolves the problem

java.sql.SQLException: Could not retrieve datasource via JNDI url ‘xxxx‘ weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool data source is Suspended, cannot allocate resources to applications.

The exception is encountered when maximum connection is reached. As a temporary solution the connection can be resumed from the console and later the max connection can be increased.