Skip to end of metadata
Go to start of metadata

This chapter describes considerations when integrating Altibase in Spring.

LOB Data Processing

In order to process LOB data in ALTIBASE, the user must explicitly manage the transaction after changing the autocommit mode to false. Therefore, in order to process LOB in Spring, TransactionManager bean must be specified. In addition, when using a declarative transaction, propagation must be specified as one of PROPAGATION_REQUIRED, PROPAGATION_REQUIRES_NEW, and PROPAGATION_NESTED. 

If TrnasactionManager is not specified or propagation is set to a value other than above described when using the declarative transaction, a null value is returned when querying LOB data, or "java.sql.SQLException:0:LobLocator can not span the transaction 101858625." error will occur. In addition, when entering LOB data, "java.sql.SQLException0:LobLocator ca not span the transaction 101858625" error will occur.

Ex) applicationContext.xml file of LobConnection



  • No labels