A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
What happens when you read large blob data from Oracle db using jdbc connection?
Joined: Sep 18, 2009
Oct 27, 2009 12:53:16
when we try to read blob data from an oracle db using
Connection con = DriverManager.getConnection(connectionurl, username, password); PreparedStatement ps = con.prepareStaement("select blob_data from table_name"); ResultSet rs = ps.executeQuery(); Blob blob = rs.getBlob(1);
now suppose the blob data is having size more than 80MB , i mean its large data, then how does
jdbc code in oracle driver class interacts with data base to read such large data from db?
It is sorta covered in the
JavaRanch Style Guide
subject: What happens when you read large blob data from Oracle db using jdbc connection?
Blob Problem on OAS 10.1.2.0.2
How to store & retrieve a video file from database?
Copying BLOB from SQL Server 2000 to Oracle 8
Awkward Memory Issues
how to create BLOB and CLOB data
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015