Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Win a copy of
Clojure in Action
this week in the
JDBC and Relational Databases
What happens when you read large blob data from Oracle db using jdbc connection?
posted 6 years ago
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?
I agree. Here's the link:
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