SAP Knowledge Base Article - Preview

3665210 - SAP DBTech JDBC: [7]: feature not supported: writable statement not allowed in read-enabled replication

Symptom

A Java based application running into hanging status, and found following errors in trace files:

Caused by: java.sql.SQLException: SAP DBTech JDBC: [7]: feature not supported: writable statement not allowed in read-enabled replication: line 1 col 1 (at pos 0) 
    OpenSQLExceptionCategories: [NON_TRANSIENT, DB_ADMINISTRATOR_REQUIRED]
    at com.sap.sql.exception.SQLExceptionFactory.createOpenSQLException(SQLExceptionFactory.java:167)
    at com.sap.sql.exception.SQLExceptionFactory.wrapChainedSQLException(SQLExceptionFactory.java:72)
    at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLExceptionJava6(DirectPooledConnection.java:1017)
    at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLException(DirectPooledConnection.java:943)
    at com.sap.sql.jdbc.direct.DirectConnection.processSQLException(DirectConnection.java:1605)
    at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:1515)
    at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:227)
    at com.sap.sql.jdbc.common.CommonPooledStatement.prepareDirectStatement(CommonPooledStatement.java:688)
    at com.sap.sql.jdbc.common.CommonPooledStatement.<init>(CommonPooledStatement.java:292)
    at com.sap.sql.jdbc.common.CommonConnectionImpl.prepare(CommonConnectionImpl.java:1659)
    at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:281)
    at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:115)
    at com.sap.jms.server.dc.pm.jdbc.impl.QueuePersistenceManagerImpl.storeMessage(QueuePersistenceManagerImpl.java:364)
    ...
* Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.   


Read more...

Environment

  • SAP Netweaver Java
  • System Replication configured
  • SAP HANA Platform Edition 1.0
  • SAP HANA Platform Edition 2.0

Keywords

system replication, Active/Active,  logreplay_readaccess. , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.