onlymullapudi
Programmer
Hai
I am trying to retrive the video file from a table, and it is saying general error.can anyone try to solve the problem. i am using oracle 10g,tomcat5 and jdk
The code is
<HTML>
<HEAD>
</HEAD>
<BODY bgcolor="pink">
<%@ page import="oracle.ord.im.OrdVideo" %>
<%@ page import="oracle.jdbc.OraclePreparedStatement" %>
<%@ page import="oracle.jdbc.OracleResultSet" %>
<%@ 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("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbcdbc:intelligent","system","indublin");
try
{
OrdVideo vp;
out.println("gdjhg");
out.println("gdjhg");
OraclePreparedStatement ps=(OraclePreparedStatement)con.prepareStatement("select vid from t1 where id= ? for update");
ps.setString(1,"12");
OracleResultSet rs = (OracleResultSet)ps.executeQuery( );
out.println("gdjhg");
while(rs.next())
{
OrdVideo videoproxy = (OrdVideo)rs.getORAData("vid", OrdVideo.getORADataFactory());
videoproxy.loadDataFromFile("er.wma");
}
}
catch(IOException e)
{
out.println(e.getMessage()+"I/O exception");
}
finally {
try {
if(con != null) con.close();
} catch (SQLException ignored) { }
}
%>
</center>
</body>
</html>
And the error message is:
java.sql.SQLException: General error
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6987)
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
sun.jdbc.odbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:4831)
sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:475)
sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:443)
org.apache.jsp.home.ret2_jsp._jspService(ret2_jsp.java:89)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
I am trying to retrive the video file from a table, and it is saying general error.can anyone try to solve the problem. i am using oracle 10g,tomcat5 and jdk
The code is
<HTML>
<HEAD>
</HEAD>
<BODY bgcolor="pink">
<%@ page import="oracle.ord.im.OrdVideo" %>
<%@ page import="oracle.jdbc.OraclePreparedStatement" %>
<%@ page import="oracle.jdbc.OracleResultSet" %>
<%@ 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("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbcdbc:intelligent","system","indublin");
try
{
OrdVideo vp;
out.println("gdjhg");
out.println("gdjhg");
OraclePreparedStatement ps=(OraclePreparedStatement)con.prepareStatement("select vid from t1 where id= ? for update");
ps.setString(1,"12");
OracleResultSet rs = (OracleResultSet)ps.executeQuery( );
out.println("gdjhg");
while(rs.next())
{
OrdVideo videoproxy = (OrdVideo)rs.getORAData("vid", OrdVideo.getORADataFactory());
videoproxy.loadDataFromFile("er.wma");
}
}
catch(IOException e)
{
out.println(e.getMessage()+"I/O exception");
}
finally {
try {
if(con != null) con.close();
} catch (SQLException ignored) { }
}
%>
</center>
</body>
</html>
And the error message is:
java.sql.SQLException: General error
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6987)
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
sun.jdbc.odbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:4831)
sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:475)
sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:443)
org.apache.jsp.home.ret2_jsp._jspService(ret2_jsp.java:89)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)