file uploadin in java

[rijuthakona]

i need code for image uploading into oracle 10g express edition database
actuallt i have tried the code it works properly when i try to retrieve it in the database, it shows expectd number got blob

[Tolls]

Show us your code that's causing the problem then.
In code tags.
As well as the full exception (with stack trace).

[rijuthakona]

import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**

public class ImageUpload extends HttpServlet {


protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();

FileInputStream fis = null;
PreparedStatement ps = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:sample ","system","root");
String INSERT_PICTURE = "insert into MyPictures(id, name, photo) values (?, ?, ?)";

conn.setAutoCommit(false);
File file = new File("C:/Users/Rijju/Pictures/Pictures/sdfgsdfg.jpg");
fis = new FileInputStream(file);
ps = conn.prepareStatement(INSERT_PICTURE);
ps.setString(1, "001");
ps.setString(2, "name");
ps.setBinaryStream(3, fis, (int) file.length());
ps.executeUpdate();
conn.commit();
} catch(Exception e)
{
e.printStackTrace();
}
}
}

[Tolls]

Code tags?
Full stack trace?
Where you are getting your error?

Come on...if you want help then you have to provide us the information.

[rijuthakona]

package sample;

import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;


public class ImageUpload extends HttpServlet {

/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();

FileInputStream fis = null;
PreparedStatement ps = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:sample ","system","root");
String INSERT_PICTURE = "insert into MyPictures(id, name, photo) values (?, ?, ?)";

conn.setAutoCommit(false);
File file = new File("C:/Users/Rijju/Pictures/Pictures/sdfgsdfg.jpg");
fis = new FileInputStream(file);
ps = conn.prepareStatement(INSERT_PICTURE);
ps.setString(1, "001");
ps.setString(2, "name");
ps.setBinaryStream(3, fis, (int) file.length());
ps.executeUpdate();
conn.commit();
} catch(Exception e)
{
e.printStackTrace();
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}



well i am using this code in netbeans 5.5 this code doesnt show any error
when i try to retireve the image in the database with qurey "select * from MyPictures;" i will get error ORA-00932: inconsistent datatypes: expected NUMBER got BLOB

[Tolls]

Use code tags!

Put code in here

As for the error, that says it's expecting a NUMBER and you gave it a BLOB. Which means your picture column is a NUMBER...not a BLOB.

[rijuthakona]

i have declared the datatype as blob only what code tags we have to use???

[Tolls]

If you quote my post above you'll see them.

I just noticed that it's on the select you;re having the problem...so why are you showing me the insert?
If the insert wasn't working you'd be getting errors on that.
So...how are you doing the select?