ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Elangovan, Kumaravel" <kumaravel.elango...@fmr.com>
Subject How to insert byte[] using iBatis into DB
Date Thu, 27 Mar 2008 13:32:52 GMT


We have a encrypted byte array for the password. We will construct a
String (String pwd = new String(byte[] password) insert in to DB2 (The
column definition is CHARACTER(64) NOT NULL  FOR BIT DATA).
The sqlmap for this is as follows.

<parameter property="Pwd" 	jdbcType="CHARACTER"
javaType="java.lang.String" mode="IN"/>

The issue is the constructed String does not have the same bytes in
different OS, thus results in junk value while decrypting. So we wanted
to store it as byte[] in to DB.

Can any one let me know how to accomplish this.

Thanks & Regards,

Important: This e-mail, including any attachment(s) hereto, is intended
only for the individual or entity to whom it is addressed. It may
contain proprietary, confidential or privileged information or attorney
work product belonging to Fidelity Business Services India Pvt. Ltd.
(FBS India) or its affiliates. If you are not the intended recipient of
this e-mail, or if you have otherwise received this e-mail in error,
please immediately notify the sender via return e-mail and permanently
delete the original mail, any print outs and any copies, including any
attachments. Any dissemination, distribution, alteration or copying of
this e-mail is strictly prohibited. The originator of this e-mail does
not guarantee the security of this message and will not be responsible
for any damages arising from any dissemination, distribution, alteration
or copying of this message and/or any attachments to this message by a
third party or as a result of any virus being passed on. Any comments or
statements made in this are not necessarily those of FBS India or any
other Fidelity entity. All e-mails sent from or to FBS India may be
subject to our monitoring and recording procedures. FBS India is an
Appointed Representative of Fidelity Investments International, which is
authorized and regulated by the United Kingdom Financial Services
Authority . Fidelity Investments International only gives information on
its products and services and does not give investment advice to private
clients based on individual circumstances

View raw message