File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Retrive column of type 'image'
Joined: Sep 28, 2004
Feb 01, 2007 07:08:00
I have a column in MS SQL - Server database with data type '
', but it has a chunk of text stored in a binary format. Can any one throw light on retrieving the values of this column.
Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
author & internet detective
Joined: May 26, 2003
Feb 01, 2007 17:21:00
You can use rs.getBlob() or rs.getBinaryStream() to get the result. One or two databases call their binary data column "image" even though it is misleading.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Retrive column of type 'image'
Load Image in a database..Pls help me
Inserting image into the oracle database
Setting column size for BLOB using hbm2ddl
errors uploading an image to the database
how to use spaced column names in hibernate orderby mapping xml
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015