Looping Chain Of Synonyms In Java App From A 12c Database.

(Doc ID 2270721.1)

Last updated on MAY 26, 2017

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


java.sql.SQLException: ORA-01775: looping chain of synonyms is received when running a Java application deletion of data in a 12c database.

       java.sql.SQLException: ORA-01775: looping chain of synonyms
       at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
       at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
       at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
       at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)

The specific delete SQL statements work fine when run manually through TOAD or directly on the database.

Database errorstack shows the SQL statement where the failure occurs:

ORA-01775: looping chain of synonyms
----- Current SQL Statement for this session (sql_id=c4pnsj4znmcng) -----
delete from MPTDATA p where exists ( select 1 from netwtran t join netwbatch b on B.BATCHID=T.BATCHID join netwfile f on F.FILEID=B.FILEID where P.NETWTRANID=T.NETWTRANID and f.fileid=:1)

No looping synonyms exist.




Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms