File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes Reading BLOB fields from the database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Reading BLOB fields from the database" Watch "Reading BLOB fields from the database" New topic
Author

Reading BLOB fields from the database

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I would like to read post text directly from the database with SQL. However, since the field is a blob the result is not readable.

I have tried the following SQL:


Does anyone have a clue?

I'm using JForum 2.1.6 with Oracle 9.
[originally posted on jforum.net by frankern]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading BLOB fields from the database
 
Similar Threads
Any datatype to store files of size greater than 20k
Search doesn't work after the crash
Quartz Scheduler - CPU Intesive/DB Intensive
reading BLOB type
java.sql.sqlexception data size bigger than max size for this type