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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > > > > ---------- Forwarded message ---------- > > > From: Kevin Williams <[EMAIL PROTECTED]> > > > 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: [EMAIL PROTECTED], [EMAIL PROTECTED] > > > > > > > > > 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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"); > > > > > > > > > > > > > > > > -----邮件原件----- > > > > 发件人: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > 发送时间: 2007年7月18日 16:54 > > > > 收件人: [EMAIL PROTECTED] > > > > 主题: 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: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > -- > Luciano Resende > Apache Tuscany Committer > http://people.apache.org/~lresende > http://lresende.blogspot.com/ >
