I am using Oracle Application Server 10g(18.104.22.168.0) with latest version of IBatis. I am uploading a file and inserting file data as byte in the database field which is a Blob. I keep on getting SQLException:Data size bigger than max size for this type when i try to insert. If i take out the file data from my insert statement , a record is inserted into the table.
Just a thought but have you tried using a Stream instead of a byte array? I know in JDBC clob/blobs can be tricky in that sometimes you have to perform select/insert in two statements instead of one. For example, sometimes you have to read the entire record except the binary data then read each blob/clob separately.