ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Alvarsson" <jonathan.alvars...@gmail.com>
Subject Re: Mapping HSQLDB's binary using iBatis
Date Tue, 27 May 2008 14:32:35 GMT
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