great stuff steve. Keep it up. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > Stephen Coy > Sent: Friday, September 27, 2002 4:40 AM > To: [EMAIL PROTECTED] > Subject: [JBoss-dev] Cleaning up LOB support in JDBCUtil.java > > > Hi Dain, > > I've been doing some work on making the "binary data" support more > portable in JDBCUtil.java. > > In particular, I wanted to get all use cases of this working with > Oracle, where (despite what I may have said before) there are still > issues with BLOBS. > > Current Oracle JDBC drivers absolutely do support the use of the > java.sql.* apis for accessing LOBS and the other forms of binary data > (VARBINARY, etc). > > I believe that you added the code that uses > org.jboss.ejb.plugins.cmp.jdbc.ByteArrayBlob to try and resolve the > Oracle issues. Please correct me if I am wrong as I've ditched it > because Oracle barfs on it (technically, the provision of a > java.sql.Blob implementation is in the driver's domain). > > The only other issue was the use of "byte[] bytes = > rs.getBytes(index);" in getResult. According to the javadoc, > ResultSet.getBytes() returns "raw" bytes from the driver. In Oracle's > case, this seems to be the LOB pointer or something, rather than the > LOB data. However, going direct to ResultSet.getBinaryStream works > fine, so I've modified convertByteArrayToObject to take an InputStream > instead, which seems to be a bit more streamlined as you were wrapping > the array in a ByteArrayInputStream anyway, unless it already happened > to be expecting a byte array. > > Currently, I have my changes working in Branch_3_0, and the cmp2 test > suite passes using both Hypersonic and Oracle. I'll get it working in > Branch_3_2 as well. > > I want to emphasize that I have not used any Oracle apis for this work, > only the java.sql.* interfaces. > > This will not fix the Oracle issues with LOB size when using the "thin" > drivers. The only way to fix that problem is to use the "oci" drivers. > > Anyway, I wanted to run this past you and make sure that I'm not > working at cross purposes with anyone else before checking it in. > > Steve Coy > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
