Re: How to do if I need the DAS and SDO to support reading and writing the BLOB or CLOB field

[Amita Vadhavkar <am...@gmail.com>]

Clob can be mapped to SDO Type Object. (can not be mapped to Bytes , due to
incompatible type casting)

Array is not well supported in Derby -
http://wiki.apache.org/db-derby/JDBCSupport.
In Oracle - there is Record definition and Table of Records can be IN/OUT
for StoredProcs, which is the way to represent ARRAY.
http://forum.springframework.org/showthread.php?t=11805

In order to preserve the contents of ARRAY, it can also be mapped to SDO
Type Object.

Providing test cases for Blob and Clob in JIRA-1463.

Suggestions?

Regards,
Amita

On 7/19/07, Luciano Resende <lu...@gmail.com> wrote:
>
> Let's just create a new one. It would be great to have some test cases
> provided as well, as suggested by Kevin.
>
> On 7/19/07, Amita Vadhavkar <am...@gmail.com> wrote:
> > Hi Folks,
> > JIRA-1453 opened for this issue is perfectly fixing Blob and ByteArray.
> >
> > Clob and Array, seem to be the only remaining types where
> > TypeHelper.getType("commonj.sdo",...) returns null. Same approach
> > as JIRA-1453 can work the Clob , but for Array? Any hints?
> > Can the same JIRA be used or new JIRA be opened, so this issue does
> > not remain half complete?
> >
> > Regards,
> > Amita
> >
> > On 7/19/07, Kevin Williams <kj...@gmail.com> wrote:
> > >
> > > ---------- Forwarded message ----------
> > > From: Kevin Williams <kj...@gmail.com>
> > > Date: Jul 18, 2007 1:33 PM
> > > Subject: Re: How to do if I need the DAS and SDO to support reading
> > > and writing the BLOB or CLOB field
> > > To: tuscany-user@ws.apache.org, LiTaojian@foresee.com.cn
> > >
> > >
> > > Hello Li Taojian,
> > >
> > > You have uncovered a bug and also found a good fix.  It would be very
> > > helpful if you could open a JIRA for this bug and also submit your fix
> > > as a patch.  You can find instruction for doing this here:
> > > http://incubator.apache.org/tuscany/issue-tracking.html
> > >
> > > It would be even better if you could submit an addition to the DAS
> > > testuite to verify your fix.
> > >
> > > Thanks for your interest in the DAS.
> > >
> > > --Kevin
> > >
> > > On 7/18/07, LiTaojian@foresee.com.cn <Li...@foresee.com.cn> wrote:
> > > >
> > > > Hi All ,
> > > >     I modified  the ByteArry and BLOB  to Bytes in  the
> > > > ResultSetTypeMap.java   , and then I could run a sample of reading
> the
> > > BLOB
> > > > field ,
> > > > I test the sample on Mysql 5.0  , It could  run  correctly .
> > > >
> > > > Maybe this is a bug .
> > > >
> > > > ResultSetTypeMap.java
> > > >
> > > >         case Types.BINARY:
> > > >         case Types.VARBINARY:
> > > >         case Types.LONGVARBINARY:
> > > >                  return helper.getType("commonj.sdo", "Bytes");  //
> > > before
> > > > is return helper.getType("commonj.sdo", "ByteArray");
> > > >
> > > >         case Types.BLOB:
> > > >                 return helper.getType("commonj.sdo", "Bytes"); //
> before
> > > is
> > > > return helper.getType("commonj.sdo", "Blob");
> > > >
> > > >
> > > >
> > > > -----邮件原件-----
> > > > 发件人: LiTaojian@Foresee.com.cn [mailto:LiTaojian@Foresee.com.cn]
> > > > 发送时间: 2007年7月18日 16:54
> > > > 收件人: tuscany-user@ws.apache.org
> > > > 主题: How to do if I need the DAS and SDO to support reading and
> writing
> > > the
> > > > BLOB or CLOB field
> > > >
> > > >
> > > > Hi  All ,
> > > >
> > > >      I  need the DAS to support  reading and write the BLOB field ,
> but
> > > > TypeHelper.getType("commonj.sdo", "Blob") is return null  , Could
> you
> > > give
> > > > me some tips to implement the function or fix out the bugs ?
> > > > Or How could I implement the function immediately ?
> > > >
> > > >
> > > > Li Taojian .
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> > > > For additional commands, e-mail: tuscany-user-help@ws.apache.org
> > > >
> > > >
> > >
> >
>
>
> --
> Luciano Resende
> Apache Tuscany Committer
> http://people.apache.org/~lresende
> http://lresende.blogspot.com/
>