Re: Insert oracle BLOB's with iBatis

2008-09-25 Thread LinaTomy
Hi This is how I do it. Hope it works for you My java bean class has two attributes MyBean.java Blob myBlob; InputStream myStream; MyBean.xml .. Custom type handler import com.ibatis.sqlmap.client.extensions.ParameterSetter; import com

Re: Insert oracle BLOB's with iBatis

2008-09-24 Thread AbelGG
Hi! In reply to my own post I've discovered my problem. It was in the code generated by abator; in the instruction "insert" puts the function nvl in all columns, including the BLOB column and this is causing, attempting to insert a NUMBER instead of a BLOB (BINARY). I don't know why but seems that

Re: Insert oracle BLOB's with iBatis

2008-09-24 Thread AbelGG
Hi! In reply to my own post I've discovered my problem. It was in the code generated by abator; in the instruction "insert" puts the function nvl in all columns, including the BLOB column and this is causing, attempting to insert a NUMBER instead of a BLOB (BINARY). I don't know why but seems that

Re: Insert oracle BLOB's with iBatis

2008-09-24 Thread AbelGG
Hi! In reply to my own post I've discovered my problem. It was in the code generated by abator; in the instruction "insert" puts the function nvl in all columns, including the BLOB column and this is causing, attempting to insert a NUMBER instead of a BLOB (BINARY). I don't know why but seems that

Insert oracle BLOB's with iBatis

2008-09-23 Thread AbelGG
Hi!, I've a DB Oracle 9i and I want to insert a BLOB using iBatis. I've mapped a BLOB column as follows: The java class that I mapped here has the property "fichero" as byte[] with getter's and setter's. The iBatis versión that I'm using is 2.3.0 and the oracle driver ojdbc14.jar (is the versi

Insert oracle BLOB's with iBatis

2008-09-23 Thread AbelGG
Hi!, I've a DB Oracle 9i and I want to insert a BLOB using iBatis. I've mapped a BLOB column as follows: The java class that I mapped here has the property "fichero" as byte[] with getter's and setter's. The iBatis versión that I'm using is 2.3.0 and the oracle driver ojdbc14.jar (is the versi

Insert oracle BLOB's with iBatis

2008-09-23 Thread AbelGG
Hi!, I've a DB Oracle 9i and I want to insert a BLOB using iBatis. I've mapped a BLOB column as follows: The java class that I mapped here has the property "fichero" as byte[] with getter's and setter's. The iBatis versión that I'm using is 2.3.0 and the oracle driver ojdbc14.jar (is the versi