Informix JDBC Text Blob bug
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET, Java & JDBC Development, Jobs, Consulting & Announcements
Hello folks, I have been running into an intermittent bug with Informix Dynamic Server version 7.31.FC2 when using their JDBC driver 1.5. I have a compute intensive Java application that reads millions of records from the Informix database. The exception below only appears every few hundred thousand requests and is not repeatable as far as I can tell. I have run this over the same exact data set sometimes the exception appears and other times it doesnt. Here is the exception: java.sql.SQLException: Blob not found at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java) at com.informix.jdbc.IfxResultSet.blobCheck(IfxResultSet.java) at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java) at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java) at com.eease.lib.edbc.Query.getString(Query.java) I get the same result when using getAsciiStream also. I have even disabled the temp file caching in the driver so that all buffering is done in memory but I still see this exception occuring every few hundred thousand requests. It is, as far as I can tell, completely non-deterministic. I cannot tell if it is a problem with the driver or with the database engine itself. Anyone got any ideas? Thanks in advance. Sam Taha Employease Inc. -- -------------------------------- Employease Inc. tel: 404.467.6432 email: taha@employease.com -------------------------------- Looking for a job? We're hiring! see -> http://www.employease.com/hiring Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.