ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nicholoz Koka Kiknadze" <kikna...@gmail.com>
Subject Re: Mapping HSQLDB's binary using iBatis
Date Tue, 27 May 2008 14:53:47 GMT
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 <
jonathan.alvarsson@gmail.com> 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 <
> Richard.Yee.ctr@osd.pentagon.mil> 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:jonathan.alvarsson@gmail.com]
>> 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', '[
>> B@1107304' );     ]
>> 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', '[
>> B@1107304' );     ]
>>
>>
>> How can I make this work?
>>
>> --
>> // Jonathan
>>
>
>
>
> --
> // Jonathan

Mime
View raw message