ConnectorJ 3.0.x Null exception

I'm not sure why this is happening, but I've been getting what seems
randomly appearing nulls when I call next() with every 3.0.x driver
version to date. It does not happen with the 2.0.x driver.

I'm currently running mysql 4.0.12, but it has occurred on prior 4.0.x
versions.

My process is reading through a large result set (100,000+ rows), and I
am updating data on another connection. I'm not sure what detail I can
give here, as, the error seems random.

Exception in thread "main" java.sql.SQLException:
Error trying to fetch row:null
at
com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java :280)
at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:244)
at com.mysql.jdbc.ResultSet.next(ResultSet.java:2418)


Has anyone else had this happen? I have never got this exception on the
2.0 driver, but seems to randomly happen on the 3.0.x driver.

If more information is needed, reply to my email address, and I can dig
further.

Thanks.


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ConnectorJ 3.0.x Null exception

Mark Brown writes:
> I'm not sure why this is happening, but I've been getting what seems
> randomly appearing nulls when I call next() with every 3.0.x driver
> version to date. It does not happen with the 2.0.x driver.
>
> I'm currently running mysql 4.0.12, but it has occurred on prior 4.0.x
> versions.
>
> My process is reading through a large result set (100,000+ rows), and I
> am updating data on another connection. I'm not sure what detail I can
> give here, as, the error seems random.
>
> Exception in thread "main" java.sql.SQLException:
> Error trying to fetch row:null
> at
> com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java :280)
> at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:244)
> at com.mysql.jdbc.ResultSet.next(ResultSet.java:2418)
>
>
> Has anyone else had this happen? I have never got this exception on the
> 2.0 driver, but seems to randomly happen on the 3.0.x driver.
>
> If more information is needed, reply to my email address, and I can dig
> further.
>
> Thanks.
>

This looks like a possible bug, but we truly need a repeatable test
case.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ConnectorJ 3.0.x Null exception

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sinisa Milivojevic wrote:
> Mark Brown writes:
>
>>I'm not sure why this is happening, but I've been getting what seems
>>randomly appearing nulls when I call next() with every 3.0.x driver
>>version to date. It does not happen with the 2.0.x driver.
>>
>>I'm currently running mysql 4.0.12, but it has occurred on prior 4.0.x
>>versions.
>>
>>My process is reading through a large result set (100,000+ rows), and I
>>am updating data on another connection. I'm not sure what detail I can
>>give here, as, the error seems random.
>>
>>Exception in thread "main" java.sql.SQLException:
>>Error trying to fetch row:null
>> at
>>com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.ja va:280)
>> at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:244)
>> at com.mysql.jdbc.ResultSet.next(ResultSet.java:2418)
>>
>>
>>Has anyone else had this happen? I have never got this exception on the
>> 2.0 driver, but seems to randomly happen on the 3.0.x driver.
>>
>>If more information is needed, reply to my email address, and I can dig
>>further.
>>
>>Thanks.
>>

Connector/J 2.0.14 didn't have the ability to 'stream' result sets like
3.0 has, and it appears you've changed something in your code to start
using 'streaming' result sets for this particular query (otherwise the
driver would be using RowDataStatic, which is the default).

If the connection that is reading streaming rows is closed by the server
(due to your code taking too long (> than 'net_write_timeout' between
requesting rows, for example), you could get an exception,. Ideally, if
you could run your code in a debugger, and set a breakpoint on line 280
of RowDataDynamic, you could see what the underlying exception is.

Is there a reason you can't use the old form of result sets in this
case? (i.e, the default behavior)?

-Mark


- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+s/WjtvXNTca6JD8RAjmdAJ9YljhGTYebhP02pkJJRBhfkhcQxwCg ygk/
SGaGcC/OUliNJjPq7Bjg3yA=
=dxHm
-----END PGP SIGNATURE-----


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org