Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

java.sql.SQLException: Smart-large-object error.

Status
Not open for further replies.

ROMANGELOV

Programmer
Feb 22, 2006
1
0
0
BG
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 :)?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top