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