Hi!

I keep getting "java.io.IOException message given: Unexpected end of input stream"- error when I execute a select through mm jdbc-driver (see the error message and the select below).

The same select works fine when I run it with mysql client. When I execute it with mysql client, I get 4232 rows, so I guess it should have nothing to do with the count of rows.

This error seems to have something to do with mm jdbc-driver. The version I'm using is mm.mysql-2.0.9-bin.jar.

I was kind of hoping that Mark could answer these three guestions: Is there a limit of how many characters can a select contain when using mm JDBC driver? Is there a limit of how many LEFT OUTER JOIN's can there be in one select when using mm JDBC driver? Or could this error have something to do with special characters in some of the text fields?

I should not have special characters in text fields, but I'm kind of desperate here, because I have been strugling with this problem for nearly a month now and the deadline of this project is approaching. I have also checked with mysql's --log option, that mysql receives the select as a whole, so the problem should not be the about the length of the select either. I am using InnoDB type of tables.

If any of you have some ideas of how I could try to solve this problem, I would much appreciate it!

The error message is:

[Thu Mar 28 14:48:51 GMT+02:00 2002] error: DTServer: Error loading defects : java.sql.SQLException: Error during query: Unexpected Exception: java.io.IOException message given: Unexpected end of input stream at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Statement.executeQuery(Unknown Source) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Unknown Source) at server.DefectFactory.loadDefects(DefectFactory.java:466) at server._IDefectFactoryImplBase._invoke(_IDefectFactoryImplBase.java:123) at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(Unknown Source) at com.sun.corba.se.internal.iiop.ORB.process(Unknown Source) at com.sun.corba.se.internal.iiop.CachedWorkerThread.doWork(Unknown Source) at com.sun.corba.se.internal.iiop.CachedWorkerThread.run(Unknown Source)

The select is: select defect.defid, defect.status, defect.assigto, defect.title, defect.prodid, defect.deftype, defect.severity, defect.defprior, defect.detect, defect.testsess, defect.testcase, defect.reprod, defect.estfixhr, defect.estfixdt, defect.origin, defect.classif, defect.author, defect.actfixhr, defect.relnotes, defect.location, defect.solution, defect.recordid, defect.newdefid, defect.estfixti, cfldval1.fieldid, cfldval1.nvalue, cfldval2.fieldid, cfldval2.nvalue, cfldval3.fieldid, cfldval3.svalue, cfldval4.fieldid, cfldval4.svalue, cfldval5.fieldid, cfldval5.nvalue, cfldval6.fieldid, cfldval6.nvalue, cfldval7.fieldid, cfldval7.tvalue, definst.ordno, definst.custid, definst.userid, definst.media, definst.edate, definst.etime, definst.entered, definst.custrefe, definst.descrip, definst.platform, definst.crequest , defhist.ordno, defhist.action, defhist.doneby, defhist.assigto, defhist.actdate, defhist.acttime, defhist.comments, defhist.custid from defect defect LEFT OUTER JOIN cfldval cfldval1 ON defect.defid = cfldval1.nitemid and cfldval1.fieldid = 2032 LEFT OUTER JOIN cfldval cfldval2 ON defect.defid = cfldval2.nitemid and cfldval2.fieldid = 2033 LEFT OUTER JOIN cfldval cfldval3 ON defect.defid = cfldval3.nitemid and cfldval3.fieldid = 2034 LEFT OUTER JOIN cfldval cfldval4 ON defect.defid = cfldval4.nitemid and cfldval4.fieldid = 2035 LEFT OUTER JOIN cfldval cfldval5 ON defect.defid = cfldval5.nitemid and cfldval5.fieldid = 2036 LEFT OUTER JOIN cfldval cfldval6 ON defect.defid = cfldval6.nitemid and cfldval6.fieldid = 2037 LEFT OUTER JOIN cfldval cfldval7 ON defect.defid = cfldval7.nitemid and cfldval7.fieldid = 2038 LEFT OUTER JOIN definst definst ON defect.defid = definst.defid LEFT OUTER JOIN defhist defhist ON defect.defid = defhist.defid LEFT OUTER JOIN p_list p_list ON defect.status = p_list.pid where defect.status in ( 10, 11, 12, 13, 14, 15, 17 ) and defect.newdefid is null order by p_list.porder, defect.defid

Best Regards

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.