loadDataFromFile() method not working



Hai,

There r no errors in the code below, it is supposed to load a video file in
to the database, but the problem is the jsp page is not loading(the page is
not loading even after 30 minutes, continously loading). I think the problem
is with the loadDataFromFile( ) method, can any one solve the problem for mee

<HTML>
<HEAD>
</HEAD>
<BODY bgcolor="pink">
<%@ page import="oracle.ord.im.OrdVideo" %>
<%@ page import="oracle.jdbc.driver.*" %>
<%@ page import="oracle.sql.*" %>



<%@ page import="java.sql.*" %>
<%@ page import="java.io.File" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.io.*" %>


<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*;" %>


<CENTER>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:
orcl","system","indublin");

try
{
PreparedStatement ps =con.prepareStatement("INSERT INTO t1 (id ,vid) values
(16,ORDSYS.ORDVIDEO.INIT( ))");
ps.executeUpdate( );
ps.close();


con.setAutoCommit(false);

Statement st=con.createStatement();
out.println("gdjhg");
out.println("gdjhg");

OracleResultSet rs=(OracleResultSet)st.executeQuery("select vid from t1 where
id=16 for update");


out.println("gdjhg");
rs.next();

OrdVideo videoproxy = (OrdVideo)rs.getORAData("vid", OrdVideo.
getORADataFactory());
String videofile="CAMWIZ 15-APR-06 16=44=52.50.wmv";
videoproxy.loadDataFromFile(videofile);

out.println("gdjhg");

byte[ ] [ ] ctx = new byte[1][64];
videoproxy.setProperties(ctx);


out.println("gdjhg");


String updateSQL = "update t1 set vid=? where id=16";
OraclePreparedStatement opstmt = (OraclePreparedStatement)con.
prepareStatement(updateSQL);
opstmt.setORAData(1, videoproxy);
opstmt.execute();
opstmt.close();
con.commit();

}
catch(Exception e)

{
out.println(e.getMessage()+"I/O exception");
}

%>


</center>
</body>
</html>



Thanks,
bye now
.