Database Administration (MOSC)

MOSC Banner

Oracle XA Support - ORA-17023: Unsupported feature

edited Feb 22, 2024 3:10PM in Database Administration (MOSC) Question

I am trying to both administer 2 Oracle 21c Enterprise on-prem databases and write a Java app that uses XA transactions against them. I've never administered XA support on databases and have had a hard time finding step-by-step instructions on Oracle's site and others to ensure my database supports XA transactions, as well as my database user.

When I run the following Java code...

oracle.jdbc.xa.client.OracleXADataSource xaDataSource = new OracleXADataSource xaDataSource = new OracleXADataSource();
xaDataSource.setURL(...);
xaDataSource.setURL(...);
xaDataSource.setPassword(...);
Connection xaConn = xaDataSource.getConnection();OracleXADataSource();

I get this exception...

java.sql.SQLException: ORA-17023: Unsupported feature
https://docs.oracle.com/error-help/db/ora-17023/
    at oracle.jdbc.driver.SQLStateMapping$SqlExceptionType$1.newInstance(SQLStateMapping.java:58)
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:169)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:175)
    at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:226)
    at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:299)
    at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:320)
    at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:456)
    at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:437)
    at oracle.jdbc.datasource.impl.OracleConnectionPoolDataSource.getConnection(OracleConnectionPoolDataSource.java:243)
    at com.mycompany.XATest.main(XATest.java:25)
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center