It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes How can I put the image into the DataBase? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How can I put the image into the DataBase?" Watch "How can I put the image into the DataBase?" New topic

How can I put the image into the DataBase?

Jewel Young

Joined: Oct 20, 2002
Posts: 1
DataBase:MS SQL Server
the Colume is image(image)
<java file>
import java.sql.*;
public class InsertBlob {
public static void main(String args[]) {
String username;
String password;
String url;
String dropString;
String createString;

try {
}catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
try {
Connection con;
Statement stmt;
con =java.sql.DriverManager.getConnection("jdbc dbc:TryDataBase");
System.out.println ("Ok, connection to the DB worked. Let's see if we can insert something:");
FileInputStream fis=null;
File file = new File("eat.gif");

fis = new FileInputStream(file);
} catch(FileNotFoundException e) {}

PreparedStatement ps = con.prepareStatement("insert image (value) values (?)");
} catch(IOException e) {}
System.out.println ("Image Items have been inserted, you can now run the QueryCoffees program");
catch(SQLException ex) {
System.err.println("==> SQLException: ");
while (ex != null) {
System.out.println("Message: " + ex.getMessage ());
System.out.println("SQLState: " + ex.getSQLState ());
System.out.println("ErrorCode: " + ex.getErrorCode ());
ex = ex.getNextException();
get the message:
[ October 21, 2002: Message edited by: Jewel Young ]
prabhat kumar
Ranch Hand

Joined: Apr 11, 2001
Posts: 114
i am not sure abt sql server, but in oracle
it works olny when you
do these two things:
1. first set the dbCon.setautocommit() to false
2. then insert the blob using emptyblob() function and then set the binary stream.
at least try the first thing and see
I agree. Here's the link:
subject: How can I put the image into the DataBase?
It's not a secret anymore!