loadDataFromFile() method not working
- From: "onlymullapudi" <u21551@uwe>
- Date: Fri, 05 May 2006 12:09:09 GMT
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
.
- Prev by Date: Re: Oracle sql function SPLIT?
- Next by Date: Re: Oracle sql function SPLIT?
- Previous by thread: Oracle sql function SPLIT?
- Next by thread: Character encoding problem Using Java 1.4.2 and Mysql 5.0
- Index(es):