Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Date: Sat, 19 Feb 2005 10:24:52 -0800
From: Craig Russell <Craig.Russell@Sun.COM>
Subject: Re: How to invoke methods of Blob interface
In-reply-to: <20050219053747.96276.qmail@web31101.mail.mud.yahoo.com>
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <c784c270c82d50c8f3af5c100b8d5b3c@Sun.COM>
MIME-version: 1.0
Content-type: multipart/signed; protocol="application/pkcs7-signature";
 boundary=Apple-Mail-131--466209605; micalg=sha1
References: <20050219053747.96276.qmail@web31101.mail.mud.yahoo.com>


--Apple-Mail-131--466209605
Content-Type: multipart/alternative;
	boundary=Apple-Mail-130--466210126


--Apple-Mail-130--466210126
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=ISO-8859-1;
	format=flowed

Hi Mithun,

I think that Barnet was talking about using the PreparedStatement=20
interface and avoiding the Blob interface entirely.

That is,

PreparedStatement ps =3D conn.PrepareStatement("insert into EMPLOYEE(ID,=20=

IMAGE) values(?,?)");
ps.setInt(1, id);
byte[] b =3D ... // serialize arbitrary object to byte[]
ByteArrayInputStream ins =3D new ByteArrayInputStream(b);
ps.setBinaryStream(2, ins, b.length);
int result =3D ps.executeUpdate();

You can use a similar technique on input, using the getBinaryStream=20
method of ResultSet. The binary stream methods of PreparedStatement and=20=

ResultSet are highly portable across vendors.

Craig

On Feb 18, 2005, at 9:37 PM, Mithun Ruikar wrote:

> Hello ,
>  =A0
> Barnet Wagman replied me , to use setBinaryStream method of Blob=20
> interface.
> But How can I instantiate Blob object , as it is interface and I dont=20=

> know it's implemetation ?
> =A0
> How I can get blob object to call setBinaryStream.
> =A0
> that is :
> ps.setBinaryStream(psParamIndex, ins, b.length);
> from where you got this ps and what is the value of psParamIndex.
>
> thank you
>
>  -- mithun
> Barnet Wagman <b.wagman@comcast.net> wrote:
> I always serialize the object to a byte[]=A0 and then use=20
> setBinaryStream(), e.g.
>
> byte[] b =3D ... // serialize arbitrary object to byte[]
>
> ByteArrayInputStream ins =3D new ByteArrayInputStream(b);
> ps.setBinaryStream(psParamIndex, ins, b.length);
>
> I've found this to be reliable. FYI Problems with using setObject ()=20=

> with blobs is not
>  specific to Derby.=A0 I've had to use the above with MySQL and Oracle=20=

> as well.
>
> bw
>
> Suavi Ali Demir wrote:
> How about you first serialize your object into a
> byte[] and then do a setBytes() ? And then to read it
> back you can do getBytes() and then deserialize from
> that byte[]. Would that work?
> Regards,
> Ali
>
>
>  __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!

--Apple-Mail-130--466210126
Content-Transfer-Encoding: quoted-printable
Content-Type: text/enriched;
	charset=ISO-8859-1

Hi Mithun,


I think that Barnet was talking about using the PreparedStatement
interface and avoiding the Blob interface entirely.


That is,


PreparedStatement ps =3D conn.PrepareStatement("insert into EMPLOYEE(ID,
IMAGE) values(?,?)");

ps.setInt(1, id);

byte[] b =3D ... // serialize arbitrary object to byte[]

ByteArrayInputStream ins =3D new ByteArrayInputStream(b);

ps.setBinaryStream(2, ins, b.length);

int result =3D ps.executeUpdate();


You can use a similar technique on input, using the getBinaryStream
method of ResultSet. The binary stream methods of PreparedStatement
and ResultSet are highly portable across vendors.


Craig


On Feb 18, 2005, at 9:37 PM, Mithun Ruikar wrote:


<excerpt>Hello ,

 =A0

Barnet Wagman replied me , to use setBinaryStream method of Blob
interface.

But How can I instantiate Blob object , as it is interface and I dont
know it's implemetation ?

=A0

How I can get blob object to call setBinaryStream.

=A0

that is :

<fixed><fontfamily><param>Courier =
New</param>ps.setBinaryStream(psParamIndex,
ins, b.length);</fontfamily></fixed>

<fixed><fontfamily><param>Courier New</param>from where you got this
ps and what is the value of psParamIndex.</fontfamily></fixed>


<fixed><fontfamily><param>Courier New</param>thank =
you</fontfamily></fixed>


<fixed><fontfamily><param>Courier New</param> -- =
mithun</fontfamily></fixed>

<bold><italic>Barnet Wagman <<b.wagman@comcast.net></italic></bold>
wrote:

I always serialize the object to a byte[]=A0 and then use
<fixed>setBinaryStream()</fixed>, e.g.


<fixed>byte[] b =3D </fixed>... <fixed>// serialize arbitrary object to
byte[]</fixed>


<fixed>ByteArrayInputStream ins =3D new ByteArrayInputStream(b);</fixed>

<fixed>ps.setBinaryStream(psParamIndex, ins, b.length);</fixed>


I've found this to be reliable. FYI Problems with using setObject ()
with blobs is not

 specific to Derby.=A0 I've had to use the above with MySQL and Oracle
as well.


bw


Suavi Ali Demir wrote:

<fixed>How about you first serialize your object into a

byte[] and then do a setBytes() ? And then to read it

back you can do getBytes() and then deserialize from

that byte[]. Would that work?

Regards,

Ali

</fixed>


<fixed> </fixed>__________________________________________________

Do You Yahoo!?

Tired of spam? Yahoo! Mail has the best spam protection around=20

http://mail.yahoo.com


</excerpt>Craig Russell

Architect, Sun Java Enterprise System http://java.sun.com/products/jdo

408 276-5638 mailto:Craig.Russell@sun.com

P.S. A good JDO? O, Gasp!


--Apple-Mail-130--466210126--

--Apple-Mail-131--466209605
Content-Transfer-Encoding: base64
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Disposition: attachment;
	filename=smime.p7s

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGHjCCAtcw
ggJAoAMCAQICAw3FWTANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwHhcNMDUwMTEwMDA0MTA5WhcNMDYwMTEwMDA0MTA5WjBHMR8wHQYDVQQD
ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSQwIgYJKoZIhvcNAQkBFhVDcmFpZy5SdXNzZWxsQFN1
bi5DT00wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDti7ZE4rO6oXKbLM02AG9WY55t
udmBVL53fb3V3X5S1kvcJOk1NEMIYT/T7Ww+/hE955zvHT29+mIoNe8AW/yj1WUH8uGG2HxhwCHI
UQTHmN/ioVJgjwUaYbtNMKbL/NRpnL0QWewdMJS+6IFzFyX7ADFW5cJ+UWNLvNeWAQtN0mtLildn
vdOgh50i8YPvACNkCHoomGjXx0azcXbe1X3c5AgRI6e2CZe5k2lRFQFUMqkjdoMtQPoNqJ1BxH9l
i4cnabl8mcTwHHl44hrvb8ThqwRf2pfJh2vVuwmgK6z4IWjOk4RQM+0ODsRdq67mBdimJYmPMK1p
RMBHzrUsfKxNAgMBAAGjMjAwMCAGA1UdEQQZMBeBFUNyYWlnLlJ1c3NlbGxAU3VuLkNPTTAMBgNV
HRMBAf8EAjAAMA0GCSqGSIb3DQEBBAUAA4GBAIj86LzxCHedStDLMEeqHLy+UFG7zIRHfChSIV42
+MvXicydXEBh8v0Ry1V2d/lY4jS78G5yW5R9fKt1U5nlRBCOVzdhomvSolnNRIT71wPVVDrAIVlA
YpXKxSmVBq7+4hV+3ZLHDeq3qZnNmiJR0sTEUD16xZX1RJs9dRYPCHoRMIIDPzCCAqigAwIBAgIB
DTANBgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTES
MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMf
Q2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFs
IEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29t
MB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT
HFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG
cmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEpjxVc1X7TrnK
mVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph8r9RzgHU5VAKMNcCY1osiRVwjt3J8CuFWqo/cVbL
rzwLB+fxH5E2JCoTzyvV84J3PQO+K/67GD4Hv0CAAmTXp6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZ
cmC3+wIDAQABo4GUMIGRMBIGA1UdEwEB/wQIMAYBAf8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0
cDovL2NybC50aGF3dGUuY29tL1RoYXd0ZVBlcnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQD
AgEGMCkGA1UdEQQiMCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0B
AQUFAAOBgQBIjNFQg+oLLswNo2asZw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3h
YWLD2ToZfoSxmRsAxRoLgnSeJVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1
TXfjViF4gtwhGTXeJLHTHUb/XV9lTzGCAucwggLjAgEBMGkwYjELMAkGA1UEBhMCWkExJTAjBgNV
BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBJc3N1aW5nIENBAgMNxVkwCQYFKw4DAhoFAKCCAVMwGAYJKoZIhvcNAQkDMQsG
CSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDUwMjE5MTgyNDUyWjAjBgkqhkiG9w0BCQQxFgQU
3A6tCFOOx14f1HJwtv7kpHjnOjwweAYJKwYBBAGCNxAEMWswaTBiMQswCQYDVQQGEwJaQTElMCMG
A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw3FWTB6BgsqhkiG9w0BCRACCzFroGkwYjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAgMNxVkwDQYJKoZIhvcNAQEBBQAEggEA
BRXm7duiXZrGucoN8BEc7VmaDivny90i3VumsW1m8uKXYlNsxvJ8SljNbQn3hMFN4jKd5jdd8VnF
TN+EphKgceGR7sjo+UvrX2QPQ/1I/8EAgvPrgsWM5h/ZRMySvjB2+6oHoUc4LKDJdl5G2KcEOGdu
hL4MVjiDhAcf0VAjZMgalLKMXAyQWFD+NuCWc9tf8+XvuF0GSwfmzDpe6p8XyFuyh5x7O/0DaYaD
p9ewVdg9+iiJjs3Itbu82duK6HVH5QJxZCJfyoxqD32XqszunCLKAca3kWVfTN5b6uyus2uOdork
k3zqWMRfHY8p3vvsjtAVo7mk+fpjETQD5Y4pygAAAAAAAA==

--Apple-Mail-131--466209605--