Re: error

Hi,

See the transactions section in the Mckoi documentation here;
   http://www.mckoi.com/database/Transactions.html

Transaction Conflict 4 happens when one connection, at commit time, is 
found to have selected from a table that was changed by a concurrent 
connection.  It is a pragmatic check that is on by default to adhere 
strictly with the SQL serializable transaction isolation level 
requirements.  You can turn off testing for this conflict by adding 
'transaction_error_on_dirty_select=disabled' to your configuration.

Toby.

Nasser Dawoud /MEM/PRO wrote:

> what does the following error mean:
>  
> CAUSE: com.mckoi.database.TransactionException: Concurrent Serializable 
> Transaction Conflict(4): Select from table that has committed changes: 
> archivecontent
>  at 
> com.mckoi.database.TableDataConglomerate.processCommit(TableDataConglomerate.java:2522)
>  at com.mckoi.database.Transaction.closeAndCommit(Transaction.java:2066)
>  at 
> com.mckoi.database.DatabaseConnection.commit(DatabaseConnection.java:1542)
>  at 
> com.mckoi.database.interpret.CompleteTransaction.evaluate(CompleteTransaction.java:56)
>  at 
> com.mckoi.database.interpret.SQLQueryExecutor.execute(SQLQueryExecutor.java:147)
>  at 
> com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.execQuery(AbstractJDBCDatabaseInterface.java:461)
>  at 
> com.mckoi.database.jdbcserver.JDBCDatabaseInterface.execQuery(JDBCDatabaseInterface.java:251)
>  at 
> com.mckoi.database.jdbcserver.JDBCProcessor.queryCommand(JDBCProcessor.java:352)
>  at 
> com.mckoi.database.jdbcserver.JDBCProcessor.processQuery(JDBCProcessor.java:293)
>  at 
> com.mckoi.database.jdbcserver.JDBCProcessor.processJDBCCommand(JDBCProcessor.java:196)
>  at 
> com.mckoi.database.jdbcserver.StreamJDBCServerConnection.processRequest(StreamJDBCServerConnection.java:133)
>  at 
> com.mckoi.database.jdbcserver.MultiThreadedConnectionPoolServer$1.run(MultiThreadedConnectionPoolServer.java:171)
>  at com.mckoi.database.WorkerThread.run(WorkerThread.java:123)



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]