ifxSmartBlob IfxLoRelease
Posted in 2011
Topics: Storage & Space Management, Connectivity: ODBC / JDBC / .NET, Java & JDBC Development
Greetings I would like to write and read SmartBlob data from aan IDS and to do soo I've tried the example found at this URL: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.jd bc_pg.doc/jdbc142.htm This works great, nothing wrong with the example. But I'll be writing and reading my SmartBlobs in a different way using transactions in iBatis. To do soo I've made a TypeHandlerCallback in iBatis to handle the ifxSmartBlob creating into an sbspace. This works, gets the job done nicely, until I try to release the ifxLocator: smb.IfxLoRelease(); When I try to release the LO locator I get the following error: Exception in thread "main" java.sql.SQLException: Smart-large-object error. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3461) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3774) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2580) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2496) at com.informix.jdbc.IfxSqli.executeFastPath(IfxSqli.java:5884) at com.informix.jdbc.IfxSqli.executeFastPath(IfxSqli.java:5795) at com.informix.jdbc.IfxSmartBlob.IfxLoRelease(IfxSmartBlob.java:602) at com.informix.jdbc.IfxSmartBlob.IfxLoRelease(IfxSmartBlob.java:629) I assume that somewhere along the lines the transaction gets closed or the pointer to the large object gets closed, but I like to confirm that everything s cleanly ended. Soo can someone please help me to confirm if the LO locator is closed, hand me tools/tips to how to check or lookup for open connections/locators or can someone give me some advice on how to program ifxSmartBlobs correctly. All help is greatly appreciated, Kind regards, Kevin Vertongen