org.springframework.dao.InvalidDataAccessApiUsageException: Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode. COMMIT /AUTO or remove 'readOnly' marker from transaction definition.
SET READ_COMMITTED_SNAPSHOT ON MS SQL server isolation level by default is Read Committed ( No Dirty Read) but it poses stricter pessimistic concurrency model (meaning share lock on every read operation, which results in deadlock behavior in heavy transactional cases). By changing it to Read Committed Snapshot ON read operations are more optimistic by using readonly (tempdb) database for versioning (no shared lock used).
Note that full-text indexes are added after the main deploy activity finishes and the full database transaction is committed . If the operation fails, no error messages appear in the deploy log; however, a message is added to the Event Viewer that indicates if a failure occurred. The following message indicates a problem during deployment:
org.springframework.dao.InvalidDataAccessApiUsageException: Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode. COMMIT /AUTO or remove 'readOnly' marker from transaction definition.
Serena utilizes standard Microsoft and J2EE technologies and approaches for building and deploying a scalable enterprise solution. The Windows 2003 Server and Windows 2008 Server platforms provide industry-leading capabilities to manage and grow enterprise application performance and availability in an economical way. The price and performance of Microsoft SQL Server and Windows 2003/2008-based servers are consistently among the best as measured by the Transaction Processing Performance Council (TPC; reference http://www.tpc.org).
We use standard Microsoft and J2EE technologies and approaches for building and deploying a scalable enterprise solution. The Windows 2003 Server and Windows 2008 Server platforms provide industry-leading capabilities to manage and grow enterprise application performance and availability in an economical way. The price and performance of Microsoft SQL Server and Windows 2003/2008-based servers are consistently among the best as measured by the Transaction Processing Performance Council (TPC; reference http://www.tpc.org).
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate. transaction .JDBCTransaction. commit (JDBCTransaction.java:106)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365) at org.hibernate. transaction .JDBCTransaction. commit (JDBCTransaction.java:137) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)
