MySQL Bugs: #26148: Got: java.sql.SQLException: Column Index out of range, 6

Bug #26148	Got: java.sql.SQLException: Column Index out of range, 6 > 5.
Submitted:	7 Feb 2007 14:37	Modified:	31 Mar 2014 12:15
Reporter:	Sasi Levi	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / J	Severity:	S1 (Critical)
Version:		OS:	Windows (WIN-XP)
Assigned to:	Alexander Soklakov	CPU Architecture:	Any

Description:
I work with JBoss-messaging and configure my DS to work with MySQL.
After I do restart to the application server I get the following error in the log:
java.sql.SQLException: Column Index out of range, 6 > 5. 
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
	at com.mysql.jdbc.ResultSet.checkColumnBounds(ResultSet.java:662)
	at com.mysql.jdbc.ResultSet.getNativeString(ResultSet.java:4342)
	at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5633)
	at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5431)
	.....

How to repeat:
Install JBossMessaging, after awhile do a restart.

the full stack dump

Attachment: log.txt (text/x-delimtext), 30.10 KiB.

Thank you for a problem report. What version of Connector/J and MySQL server do you use?

i'm using MySQL server 5.0.27-community-nt via TCP/IP.
and the connector is mysql-connector-java-5.0.3-bin.jar (I just copyed the name as it is).

Hi Sasi and thanks for your report. 

Please, try to provide as much data as possible when reporting a problem. "Install JBossMessaging, after awhile do a restart." is not a bug report! Have you reported this problem *with* JBossMessaging to JBoss?

It is virtualy impossible to tell what happened just by looking into stack trace. Let me try to clear this a bit:
 - Are you able to repeat this error in standalone Java test case (not using JBOSS)? If so, please attach full test case.
 - What are your table structures?
 - Attach general query log please. I am curious as to what reaches the server.
 - How is JBoss datasource configured exactly?
 - What is JDK/JRE version you're using?

For now, you can start by downloading latest c/J (5.0.4) if not snapshot from http://downloads.mysql.com/snapshots/mysql-connector-java-5.0/mysql-connector-java-5.0-nig... and inform me if the problem has gone away.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I close this report as "Can't repeat" because there is no feedback for a long time and codebase is too old. Please, feel free to reopen it if the problem still exists in current driver.