There is a patch for this on source forge that I plan on adding to JBossCMP. The patch was written for JAWS in JBoss 2.4, so I will have to rewrite it. Oracle claims that has been fixed in the 9.0.2 driver, which just came out or will be out shortly.
-dain Eric Kaplan wrote: > Speaking of BLOBs... > We are using BMP and are storing the standard Date, Integer, Double, String. > We also store serialized objects, but have resorted to storing them on the > filesystem > because when we looked into storing them in the database, it seemed as if > Oracle > required very specific, non-standard code to store and retrieve, and our > code needs > to be database agnostic. Does anyone have any database neutral code for > storing/ > retrieving blobs? > > Regards > > Eric > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of James > Higginbotham > Sent: Monday, May 13, 2002 5:52 PM > To: Dain Sundstrom > Cc: Stefan Damian; [EMAIL PROTECTED] > Subject: RE: [JBoss-user] BLOB type in a CMP > > > Right.. We have a script that creates the tables ahead of time per the > targeted DB for our project. So, I just made sure that Jboss doesn't > delete or create and all is well. BLOB in MySQL is limited to 64k, which > isn't enough for serializing most useful classes. So, LONGBLOB works > better. This could be a change in the default mapping if everyone > thought it was worth it in the MySQL case - since 64k *may not* be all > that useful for a BLOB column. > > James > > >>-----Original Message----- >>From: Dain Sundstrom [mailto:[EMAIL PROTECTED]] >>Sent: Monday, May 13, 2002 4:11 PM >>To: James Higginbotham >>Cc: Stefan Damian; [EMAIL PROTECTED] >>Subject: Re: [JBoss-user] BLOB type in a CMP >> >> >>Is BLOB the wrong mapping? We shoot for 80% on these >>mappings, meaning >>we try to make 80% of the users happy. I can change it >>LONGBLOB or put >>a comment in like some of the other mappings. >> >>BTW, you can always override the default mapping for a single >>field, or >>just create your own private mapping (that is what I do for >>my projects). >> >>-dain >> >>James Higginbotham wrote: >> >> >>>Everything worked for me on JBoss 3.0 (the work was >>> >>originally done on >> >>>2.4 and ported to 3.0 I think - I inherited the work) using >>> >>the following: >> >>> >>> >>> <cmp-field> >>> <field-name>data</field-name> >>> <column-name>data</column-name> >>> <jdbc-type>JAVA_OBJECT</jdbc-type> >>> <sql-type>BLOB</sql-type> >>> </cmp-field> >>> >>>and creating the table ahead of time, rather than allowing jboss to >>>create it using a LONGBLOB. Jboss will only create a BLOB type by >>>default and thus limit the size of the blob storage, so >>> >>make sure to: >> >>> >>> >>> <create-table>false</create-table> >>> <remove-table>false</remove-table> >>> >>>HTH, >>> >>>James >>> >>> -----Original Message----- >>> From: Stefan Damian [mailto:[EMAIL PROTECTED]] >>> Sent: Tuesday, May 07, 2002 4:43 PM >>> To: [EMAIL PROTECTED] >>> Subject: [JBoss-user] BLOB type in a CMP >>> >>> Hello, >>> >>> I use MySQL and jBoss 2.4 >>> >>> I want to store binary data in database greater then 2k and the >>> programming interface is a CMP. >>> >>> For data less then 2k it's work very fine with data >>> >>type = Object >> >>> and jaws mapping like: >>> >>> java.lang.Object >>> >>> JAVA_OBJECT >>> >>> BLOB >>> >>> Can define someone a real hint or an advice? >>> >>> Stefan >>> >>> >> >>-- >>xxxxxxxxxxxxxxxxxxxxxxxxx >>Dain Sundstrom >>Chief Architect, JBossCMP >>JBoss Group, LLC >>xxxxxxxxxxxxxxxxxxxxxxxxx >> >> >> >> > > _______________________________________________________________ > > Have big pipes? SourceForge.net is looking for download mirrors. We supply > the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > _______________________________________________________________ > > Have big pipes? SourceForge.net is looking for download mirrors. We supply > the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > -- xxxxxxxxxxxxxxxxxxxxxxxxx Dain Sundstrom Chief Architect, JBossCMP JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxxx _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
