v8.1
2008/1/4, Stephen Boyd <[EMAIL PROTECTED]>: > > what version of db2? I have not seen a sqlstate of FFFFF before with db2 > v8+ > > On Jan 2, 2008 2:49 AM, Curro <[EMAIL PROTECTED]> wrote: > > > Hi and happy new year for everyone... > > > > This is one of the querys that is failing > > > > <resultMap id="imagenModel" class="beans.ImagenModelBean"> > > <result property="idImagen" column="ID_IMAGEN" /> > > <result property="cdgoTipoImagen" column="CDGO_TIPO_IMG"/> > > <result property="fileName" column="FILE_NAME"/> > > <result property="contentType" column="CONTENT_TYPE"/> > > <result property="length" column="LENGTH"/> > > <result property="imagenBlob" column="IMAGEN" jdbcType="BLOB"/> > > <result property="idModelo" column="ID_MODELO" /> > > </resultMap> > > > > <sql id="getImagen"> > > SELECT > > imagen.ID_IMAGEN, > > imagen.CDGO_TIPO_IMG, > > imagen.FILE_NAME, > > imagen.CONTENT_TYPE, > > imagen.LENGTH, > > imagen.IMAGEN > > </sql> > > > > <select id="getImageByPk" parameterClass=" beans.ImagenModelBean" > > resultMap="imagenModeloCoche"> > > <include refid="getImagen"/> > > FROM > > schema.T_IMAGES imagen, > > schema.T_MODELS modelo > > LEFT OUTER JOIN schema.T_MODEL_PZ as clase > > ON modelo.CDGO_CLASE_PLZ = clase.CDGO_CLASE_PLZ > > WHERE > > imagen.ID_IMAGEN = $idImagen$ > > AND imagen.ID_MODELO = modelo.ID_MODELO > > </select> > > > > The only error code that i have is this: SQL state [FFFFF]; error code > > [-4]; > > I hope that anyone can help me. > > > > Thanks. > > > > > > 2007/12/18, Abhigyan Agrawal1 <[EMAIL PROTECTED]>: > > > > > > Hi, > > > To solve the problem, I will require the error code and the query > > > that is failing. All other queries without BLOB (in same table) are > > > working > > > in both, right? > > > > > > Cheers, > > > Abhigyan Agrawal > > > > > > > > > > > > > > > > > > Curro > > > <[EMAIL PROTECTED] > > > om> To > > > > > > [email protected] > > > 17/12/2007 14:30 > > > cc > > > > > > Subject > > > > > > Please respond to Problem with DB2 and BLOB!! > > > [EMAIL PROTECTED] > > > apache.org > > > > > > > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > > I have a problem with all the querys that work with BLOB data in DB2 > > > v8.1. > > > In my local site (Windows) works fine, but in production (Unix) don't > > > work, > > > this is the log error: > > > > > > > > > ---> SqlMapClient operation; uncategorized SQLException for SQL []; > > > SQL > > > state [FFFFF]; error code [-4]; > > > > > > > > > --- The error occurred in mySqlMap.xml. > > > > > > > > > --- The error occurred while executing query. . > > > > > > > > > --- Check the SQL Statement (preparation failed). > > > > > > > > > --- Cause: java.sql.SQLException: DB2JDBCCursor Received Error > > > in > > > Method describe:RETURN CODE==> -4 SQLSTATE ==> FFFFF Error Tokens ==> > > > <<DB2 > > > 8.1 SQLJ/JDBC>> ; nested exception is > > > com.ibatis.common.jdbc.exception.NestedSQLException : > > > > > > > > > I'm using ibatis 2.3.0.677 > > > > > > Any idea? > > > > > > > > >
