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 > > > > user-java@ibatis.apache.org > > 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? > > > > >
