ROMANGELOV
Programmer
Hi all,
I use trial version of Informix 9.4,
I use Java and this piece of code for store my information:
Connection conn = session.connection();
IfxCblob clob = new IfxCblob(conn, document);
this.tsod_store_date = new Date();
if (lrn_mrn != null) {
if (lrn_mrn.length() == 22) {
this.tsod_lrn = lrn_mrn;
} else {
this.tsod_mrn = lrn_mrn;
}
}
this.setTsod_msg_type(msgType);
this.tsod_document = clob;
this.cnt_sid = cnt_sid;
this.is_pdf = isPDF;
session.save(this);
session is org.hibernate.Session...
But my application work strange...there is a exception with trace like this:
java.sql.SQLException: Smart-large-object error.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.T(IfxSqli.java:6824)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2347)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2268)
at com.informix.jdbc.IfxSqli.executeWriteSmBlob(IfxSqli.java:6654)
at com.informix.jdbc.IfxSmartBlob.IfxLoWrite(IfxSmartBlob.java:1018)
at com.informix.jdbc.IfxSmartBlob.IfxLoWrite(IfxSmartBlob.java:1008)
at com.informix.jdbc.IfxLob.a(IfxLob.java:235)
at com.informix.jdbc.IfxLob.<init>(IfxLob.java:159)
at com.informix.jdbc.IfxCblob.<init>(IfxCblob.java:220)
at bg.latona.bca.hibernate.wp.TEMP_STORE_OF_DOCS.storePdfDocument(TEMP_STORE_OF_DOCS.java:
at bg.latona.nca.utils.BusinessExecuterOnline.storePdfDocument(BusinessExecuterOnline.java
at bg.latona.nca.utils.BusinessExecuterOnline.declarationProcess(BusinessExecuterOnline.ja
at bg.latona.nca.dti.actions.SubmitDeclarationAction.execute(SubmitDeclarationAction.java:
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:41
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.ja
at bg.latona.bca.utils.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.ja
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:286
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
at org.mortbay.http.HttpServer.service(HttpServer.java:863)
at org.jboss.jetty.Jetty.service(Jetty.java:460)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)
and I don't know the reason for this error because, it's throwed when the DB is with a few record, if the DB is empty there isn't this error. Can you help me ?
I use trial version of Informix 9.4,
I use Java and this piece of code for store my information:
Connection conn = session.connection();
IfxCblob clob = new IfxCblob(conn, document);
this.tsod_store_date = new Date();
if (lrn_mrn != null) {
if (lrn_mrn.length() == 22) {
this.tsod_lrn = lrn_mrn;
} else {
this.tsod_mrn = lrn_mrn;
}
}
this.setTsod_msg_type(msgType);
this.tsod_document = clob;
this.cnt_sid = cnt_sid;
this.is_pdf = isPDF;
session.save(this);
session is org.hibernate.Session...
But my application work strange...there is a exception with trace like this:
java.sql.SQLException: Smart-large-object error.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.T(IfxSqli.java:6824)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2347)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2268)
at com.informix.jdbc.IfxSqli.executeWriteSmBlob(IfxSqli.java:6654)
at com.informix.jdbc.IfxSmartBlob.IfxLoWrite(IfxSmartBlob.java:1018)
at com.informix.jdbc.IfxSmartBlob.IfxLoWrite(IfxSmartBlob.java:1008)
at com.informix.jdbc.IfxLob.a(IfxLob.java:235)
at com.informix.jdbc.IfxLob.<init>(IfxLob.java:159)
at com.informix.jdbc.IfxCblob.<init>(IfxCblob.java:220)
at bg.latona.bca.hibernate.wp.TEMP_STORE_OF_DOCS.storePdfDocument(TEMP_STORE_OF_DOCS.java:
at bg.latona.nca.utils.BusinessExecuterOnline.storePdfDocument(BusinessExecuterOnline.java
at bg.latona.nca.utils.BusinessExecuterOnline.declarationProcess(BusinessExecuterOnline.ja
at bg.latona.nca.dti.actions.SubmitDeclarationAction.execute(SubmitDeclarationAction.java:
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:41
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.ja
at bg.latona.bca.utils.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.ja
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:286
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
at org.mortbay.http.HttpServer.service(HttpServer.java:863)
at org.jboss.jetty.Jetty.service(Jetty.java:460)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)
and I don't know the reason for this error because, it's throwed when the DB is with a few record, if the DB is empty there isn't this error. Can you help me ?