This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How can I put the image into the DataBase?" Watch "How can I put the image into the DataBase?" New topic
Author

How can I put the image into the DataBase?

Jewel Young
Greenhorn

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

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
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");

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

PreparedStatement ps = con.prepareStatement("insert image (value) values (?)");
ps.setBinaryStream(1,fis,3098);
ps.executeUpdate();
ps.close();
try{
fis.close();
} catch(IOException e) {}
System.out.println ("Image Items have been inserted, you can now run the QueryCoffees program");
con.close();
}
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();
System.out.println("");
}
}
}
}
=================================================
Run:
get the message:
'SQLState:22001'
'ErrorCode:8152'
'SQLState:01000'
'ErrorCode:3621'
[ 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
 
jQuery in Action, 2nd edition
 
subject: How can I put the image into the DataBase?
 
Similar Threads
Accessing variable from another method
Urgent....
getting batchupdate exception while inserting recored for second time...
data mismatch error
oracle connection with jdbc