Reference Citations to Herong's Tutorial Notes - Version 2.30, by Dr. Herong Yang

insert a photo document in to the oracle database through JDBC

'Inserting BLOB Values with setBinaryStream() Method' tutorial was cited in a CodeRanch forum post in 2009.

The Inserting BLOB Values with setBinaryStream() Method tutorial was cited in a CodeRanch forum post in 2009.

Subject: unable to insert a photo document in to the oracle database
   through JDBC
Date: September 23, 2009
Author: Tim McGuire
Source: http://www.coderanch.com/t/463616/JDBC/java
   /unable-insert-photo-document-oracle

>Is there a reason you all are avoiding "photoStream.available()"?
>You're reading data from the stream so you should use a stream
>parameter to determine how much to read. Using the photo.length() is
>not valid to me since there's no guarantee photo.length() and
>photoStream.available() are actually the same value. Either way, its
>safer to use a stream parameter to read from the stream.

photoStream.available() seems good to me. In fact, I'm going to use
it from now on.

All the examples I can find online though, use File.length() when
doing an operation like this.

http://www.java2s.com/Tutorial/Java
   /0340__Database...edStatementsetBinaryStream.htm

http://www.herongyang.com/jdbc/MySQL-BLOB-setBinaryStream.html

Google code search, on the other hand, shows plenty of both uses:
http://www.google.com/codesearch?hl=en&lr=&q=setBi...
   Stream+lang%3Ajava&sbtn=Search
http://www.google.com/codesearch?hl=en&lr=&q=setBi...
   ryStream+available&sbtn=Search

Table of Contents

 About This Book

 Reference Citations in 2013

 Reference Citations in 2012

 Reference Citations in 2011

 Reference Citations in 2010

Reference Citations in 2009

 Java Database Connectivity (JDBC) Overview

 Upgrading to a Mantis UTF8

 getting database connection in netbeans

 Delphi 2010 "£" sign issues and Parameters

 Scambio cedrtificati Server/Client

 BSOD with win 7 64 bit when playing games

 Win7: SYSTEM IGMP 224.0.0.22 connection

 SCDJWS 5 Study Notes

 Public key in reply and keystore don't match

 How do I get rid of SDHelper.dll errors?

 Not Another Damn Password! Its the 21st Century After All

insert a photo document in to the oracle database through JDBC

 Chinese Characters in I.E. 8

 COMS 6998 Search Engine Technology

 mysterious [object Object]

 checking DTD when writing XML

 JHOVE2 XML module

 AVI Files to DVD

 Hibernate Annotatins duvida

 Transfer of VHS tapes to DVD

 Scripting file types

 Using RSA encryption with Java

 Setting up SOAP in PHP, why am I getting these errors?

 how to insert a value in a column with another value

 Oracle query

 Webservices mit PHP

 Inserir ficheiro numa base de dados MySql com vb.net

 Connection String - SQL Server 2005

 QLAuthenticator password encryption/decryption

 UTF Encoding in java

 CGI Error - HTTP Errors

 Wweb dynpro application Localization in chinese

 C# code for MySql Stored Procedures IN, OUT, and INOUT parameters

 SSL simple chat

 What are Scoping Rules in Javascript?

 connect two ubuntu computers together using a cable

 can not establish a connection with SQL

 Oracle Portal 10.1.4 help

 Conectar Java Con SQL Server 2005 Express

 Use of undefined constant SOAP_1_2

 Help forming a SOAP client call with PHP

 Automatisch einen Benutzer anlegen

 Android Developers - SSL client authentication

 Insert and reterive the image into BLOB type

 Compile error... what's wrong?

 Java IRC Logs

 java ile sql server

 MD5 source code

 PHP 5.2.6 coming soon to Firmware 2.1

 Can't create a cert

 Reference Citations in 2008

 Reference Citations in 2007

 Reference Citations in 2006

 Reference Citations in 2005

 Reference Citations in 2004

 Reference Citations in 2003

 Printable Copy - PDF Version

insert a photo document in to the oracle database through JDBC - Updated in 2013, by Dr. Herong Yang