I'm not too surprised that any particular driver makes this work, however
my reading of the spec makes this behavior outside the spec:
jdbc3.0 pfd 3:
table b1 and b2 indicate the only java object corresponding to a BLOB field
is Blob! byte[] goes with Binary, VarBinary or LongVarBinary, NOT BLOB.
So I think a spec compliant driver will not allow access to BLOB fields
except from Blob objects, which can't be created... obviously I think this
is an error in the spec.
david jencks
On 2001.07.20 06:29:35 -0400 Burkhard Vogel wrote:
> Hi,
> the described pattern works on oracle 8.0.x and MS SQL 7 as well.
> Burkhard
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, July 19, 2001 7:27 PM
> Subject: RE: [JBoss-user] BLOB
>
>
> > Hi,
> >
> > > Well, I wonder if it can work, I could find no way in the jdbc spec
> to
> > > create a new blob! So maybe you could read the picture but I
> > > don't know
> > > how JAWS could insert a new row. I hope I'm wrong, please
> > > tell me how.
> >
> > Well... In case of Firebird 0.9.4 + InterClient 1.6 this works for me.
> I
> > just have a mapping java.lang.Object -> BLOB -> BLOB and its works
> fine.
> >
> > I have find no createBlob() method in JDBC specs, but nobody prevents
> >
> > st = con.prepareStatement("INSERT INTO (blobcol) VALUES(?)");
> > st.setBytes(myBlobData);
> >
> > to work correctly (and because this works in case of InterClient's
> > implementation I believe that JAWS uses this way of setting BLOB data).
> >
> > And I completely agree with you that this behaviour is completely
> > implementation dependent, so one have to check it before using in live
> > configuration.
> >
> > Regards,
> > Roman.
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
