Re: How to insert byte[] using iBatis into DB

2008-04-01 Thread Andrey Rogov
uthority . Fidelity Investments International only gives information on its > products and services and does not give investment advice to private clients > based on individual circumstances > > > -------------- > *From:* Andrey Rogov [mailto:[EMAIL PROTECTED]

RE: How to insert byte[] using iBatis into DB

2008-04-01 Thread Elangovan, Kumaravel
om: Andrey Rogov [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2008 6:50 PM To: user-java@ibatis.apache.org Subject: Re: How to insert byte[] using iBatis into DB Kumar, Did you try to pass your secKey object as a parameter ?

RE: How to insert byte[] using iBatis into DB

2008-04-01 Thread Elangovan, Kumaravel
rey Rogov [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2008 6:50 PM To: user-java@ibatis.apache.org Subject: Re: How to insert byte[] using iBatis into DB Kumar, Did you try to pass your secKey object as a parameter ?

Re: How to insert byte[] using iBatis into DB

2008-03-31 Thread Andrey Rogov
s products and services and does not give investment advice to private > clients based on individual circumstances > > > > -Original Message- > From: Tony Lenzi [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2008 6:24 PM > To: user-java@ibatis.apache.org > Subject: R

RE: How to insert byte[] using iBatis into DB

2008-03-31 Thread Elangovan, Kumaravel
l Message- From: Tony Lenzi [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 6:24 PM To: user-java@ibatis.apache.org Subject: Re: How to insert byte[] using iBatis into DB java.lang.Byte On Fri, Mar 28, 2008 at 8:03 AM, Elangovan, Kumaravel <[EMAIL PROTECTED]> wrote: > > >

Re: How to insert byte[] using iBatis into DB

2008-03-28 Thread Tony Lenzi
ized 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 > > > > _____

RE: How to insert byte[] using iBatis into DB

2008-03-28 Thread Elangovan, Kumaravel
java@ibatis.apache.org Subject: Re: How to insert byte[] using iBatis into DB > 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 by

RE: How to insert byte[] using iBatis into DB

2008-03-28 Thread Elangovan, Kumaravel
java@ibatis.apache.org Subject: Re: How to insert byte[] using iBatis into DB > 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 by

Re: How to insert byte[] using iBatis into DB

2008-03-27 Thread Andrey Rogov
> 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. Kumar, this example for Oracle. I think, that it will work for

Re: How to insert byte[] using iBatis into DB

2008-03-27 Thread Tony Lenzi
Kumar, You could base 64 encode your byte array, that would preserve it as you move from OS to OS, then let Java decode the base 64 string and then decrypt it. If you need to store the byte array, we just use a blob JDBC type in our mappings of byte arrays from iBatis to MySQL. Not sure how that

How to insert byte[] using iBatis into DB

2008-03-27 Thread Elangovan, Kumaravel
Hi, 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. The issue is the constructed String does not have the s