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
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 'image', 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
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.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
subject: Retrive column of type 'image'
Setting column size for BLOB using hbm2ddl
how to use spaced column names in hibernate orderby mapping xml
Load Image in a database..Pls help me
Inserting image into the oracle database
errors uploading an image to the database
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014