I'm inserting images into MS Sql (table field type is image i.e.
variable-length binary data) without problems with no special configuration.
I have an Image class with two properties
String imageID
byte[] imageBytes
and the insert looks like
<insert id='insertImage' parameterClass='Image'>
insert into images (ImageID,image)
values ( #imageID#,#imageBytes#)
</insert>
Maybe you should try different DB engine to identify whether it's DB/jdbc
driver issue or your app/configuration problem?
On Tue, May 27, 2008 at 6:32 PM, Jonathan Alvarsson <
[EMAIL PROTECTED]> wrote:
> Okey this was a really long time ago but attempt to circumvent this is not
> working. I really need the BINARY data type in the database because I need
> to perform bitwise and during a query (btw: would you do that in a stored
> procedure?). I am using HSQLDB for the moment and I see that they use byte[]
> for internal representation of a binary so I thought I would try that but
> that was of course not the way to go. How do I insert to a binary column
> using iBatis? It must be possible to do somehow right?
>
> On Fri, Sep 28, 2007 at 5:35 PM, Yee, Richard K CTR DMDC <
> [EMAIL PROTECTED]> wrote:
>
>> What does the code look like that you are using to call the
>> sqlMap.insert() with? It looks like you are passing in a string for the
>> byte[]
>>
>> -Richard
>>
>> -----Original Message-----
>> From: Jonathan Alvarsson [mailto:[EMAIL PROTECTED]
>> Sent: Friday, September 28, 2007 4:56 AM
>> To: user-java@ibatis.apache.org
>> Subject: Mapping HSQLDB's binary using iBatis
>>
>> I am trying persist a serializable object to hsqldb's binary datatype. I
>> am currently building a byte[] but obviously there is no iBatis standard
>> type handler for this operation because I get the following errorwhen
>> trying to persist:
>>
>>
>> org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation;
>> bad SQL grammar []; nested exception is
>> com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in sqlMap.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the Structure.insertWithoutLibrary-InlineParameterMap.
>> --- Check the statement (update failed).
>> --- Cause: java.sql.SQLException : Wrong data type: java.io.IOException:
>> hexadecimal string contains non hex character in statement [
>> INSERT INTO Structure ( id, baseObject, smiles,
>> fingerPrintString, molecule ) VALUES (
>> '07bdad55-1433-4b12-8446-aa7d0fe644f9',
>> '07bdad55-1433-4b12-8446-aa7d0fe644f9', '',
>> '0000000000000000000000000000000000000000000000000000000000000000', '[
>> [EMAIL PROTECTED]' ); ]
>> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in sqlMap.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the Structure.insertWithoutLibrary-InlineParameterMap .
>> --- Check the statement (update failed).
>> --- Cause: java.sql.SQLException: Wrong data type: java.io.IOException:
>> hexadecimal string contains non hex character in statement [
>> INSERT INTO Structure ( id, baseObject, smiles,
>> fingerPrintString, molecule ) VALUES (
>> '07bdad55-1433-4b12-8446-aa7d0fe644f9',
>> '07bdad55-1433-4b12-8446-aa7d0fe644f9', '',
>> '0000000000000000000000000000000000000000000000000000000000000000', '[
>> [EMAIL PROTECTED]' ); ]
>>
>>
>> How can I make this work?
>>
>> --
>> // Jonathan
>>
>
>
>
> --
> // Jonathan
