I'm using CMP entity beans, which means writing all that custom sql to handle BLOBs isn't possible.
I switched to using MySQL and 10 minutes later everything worked perfectly. All i had to do was point my ejbs at MySQL and set the types for MySQLs type. -----Original Message----- From: Daniel Bruce Lynes [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 7:03 PM To: JBoss Users Subject: Re: [JBoss-user] Store large pdfs with JBoss On Saturday 04 January 2003 04:48, Pete Beck wrote: > I agree with Sun 100% on this. Using the file-system is bad news for > maintenance, scalability and as the article says security. > I've seen the chaos that using the filesystem can cause in clustered > environments and I would say avoid it if you can. > > Of course, the problem is Oracle seems to have totally pathetic support > for large objects from Java. However I am using Postgres and it works > like a charm. Postgres is more natural, yes. However, Oracle's support is still good. You just need to use a combination of the JDBC LOB support with the DBMS_LOB package. We use a combination of stored procedures that manipulate the LOB using DBMS_LOB.getlength(), DBMS_LOB.read(), DBMS_LOB.write(), and DBMS_LOB.copy(), in combination with the getBlob(), select, and select for update operations. Postgres is pretty much the same, but supports most of these operations directly from the JDBC driver, instead of through a database package for LOB operations. The only difference I can see from a usability standpoint, is Postgres lacks a copy operation. You would have to write a stored procedure in C I would imagine, to obtain this goal in Postgres. ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user This transmission contains information solely for intended recipient and may be privileged, confidential and/or otherwise protect from disclosure. If you are not the intended recipient, please contact the sender and delete all copies of this transmission. This message and/or the materials contained herein are not an offer to sell, or a solicitation of an offer to buy, any securities or other instruments. The information has been obtained or derived from sources believed by us to be reliable, but we do not represent that it is accurate or complete. Any opinions or estimates contained in this information constitute our judgment as of this date and are subject to change without notice. Any information you share with us will be used in the operation of our business, and we do not request and do not want any material, nonpublic information. Absent an express prior written agreement, we are not agreeing to treat any information confidentially and will use any and all information and reserve the right to publish or disclose any information you share with us. ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user