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
