Vector of Vectors: "Column Index out of range ( 0 > 11)"

[javaQQ]

How do I load the contents of a JDBC ResultSet into a Vector of Vectors?

This approach returns an error message:

	
	theStmt = con.createStatement();							
	ResultSet tQ = theStmt.executeQuery( theQuery );

	Vector theDataVector = new Vector();	
	Vector	theRowVector;
	
	while ( tQ.next() ) {
	
		theRowVector = new Vector();	

		theRowVector.setElementAt( ricq.getString( "field1" ), 0 );		//	field1
		theRowVector.setElementAt( ricq.getString( "field2" ), 1 );		//	field2
		theRowVector.setElementAt( ricq.getString( "field3" ), 2 );		//	field3
		...
		theRowVector.setElementAt( ricq.getString( "fieldX" ), 10 );	//	fieldX

		theDataVector.addElement( theRowVector );
	
	}

Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 0 >= 0
at java.util.Vector.setElementAt(Vector.java:482)
at ReaderJobUPDATE_PS_2.main(ReaderJobUPDATE_PS_2.java:531)


This code returns another error message:

	
		theStmt = con.createStatement();							
		ResultSet tQ = riConfirmStmt.executeQuery( theQuery );

		while ( tQ.next() ) {
			for( int i = 0; i < 20; i++ ) {
				for( int j = 0; j < 11; j++ ) {
						((Vector)theDataVector.elementAt(i)).setElementAt( tQ.getString(i), j );			//	pop_id
				}
			}
		}

//SQLException: Column Index out of range ( 0 > 11).
//Transaction is being rolled back
//SQLException: Can't call commit when autocommit=true


What do "0 >= 0" and especially "0 > 11" (!!) refer to, and how do I fix them?

Many thanks in advance.

[Goodz13]

Your using setElementAt(...) try using addElement

and this here

while ( tQ.next() ) {
   for( int i = 0; i < 20; i++ ) {
      for( int j = 0; j < 11; j++ ) {
         ((Vector)theDataVector.elementAt(i)).setElementAt( tQ.getString(i), j );			//	pop_id
      }
   }
}

try

while ( tQ.next() ) {
   for( int i = 0; i < theDataVector.size(); i++ ) {
      for( int j = 0; j < ((Vector)theDataVector.elementAt(i)).size(); j++ ) {
         ((Vector)theDataVector.elementAt(i)).setElementAt( tQ.getString(i), j );			//	pop_id
      }
   }
}

[javaQQ]

Last week I posted a two-part question on this problem

Even after trying the suggestions that I received, I still have a the problem which I will describe below.

I want to load the contents of a JDBC ResultSet into an EXISTING Vector of Vectors.

This code builds the Vector of Vectors:

	
	Vector theDataVector = new Vector();	
	Vector	theRowVector;
	
	for( int i = 0; i < 20; i++ ) {
		theRowVector = new Vector();	
		for( int j = 0; j < 11; j++ ) {
			theRowVector.addElement( i + "/" + j ); 	
		}
		theDataVector.addElement( theRowVector );
	}

...

The query statement:

		String bringBackSeqsQry = " SELECT * FROM Sequences WHERE job_id = '222 - A - 006' ";
...

This is supposed to load the ResultSet into the Vector:

		Statement theStmt = con.createStatement();							
		ResultSet tQ = theStmt.executeQuery( theQry );
		
		while ( tQ.next() ) {
			for( int i = 0; i < theDataVector.size(); i++ ) {
				for( int j = 1; j <= theDataVector.size(); j++ ) {
					((Vector)theDataVector.elementAt(i)).setElementAt( tQ.getString(i), j );			//	pop_id
				}
			}
		}

However, it returns this error message:

SQLException: Column Index out of range ( 0 > 11).
Transaction is being rolled back
SQLException: Can't call commit when autocommit=true

There ARE eleven columns in the table and the ResultSet.

What is the point of the nutjob error message?

Many thanks in advance.

[Goodz13]

I made a mistake in my previous post.

ResultSets are 1 based. The error message that you are getting is a little misleading. "Column Index out of range ( 0 > 11)."
It actually should be 0 < 1.

for the first for loop you could use

for (int i=1; i <= 11; i++)

if you know how many Columns are in the ResultSet or you can use ResultSetMetaData to get the Columns count.

the code would be

ResultSetMetaData rsmd = myResultset.getMetaData();
int iColCount = rsmd.getColumnCount();

myResultset would be the tQ object

Sorry about the mistake.

[javaQQ]

Hi, Goodz13;

Thanks for the attention to my problem.
Here Is some code that I got from another forum which solves the problem:

int numCols = tQ.getMetaData().getColumnCount();
int rowIndex = 0;
while ( tQ.next() ) {
Vector row = (Vector)theDataVector.elementAt(rowIndex);
for(int i = 1;i <= numCols;i++){
row.setElementAt( tQ.getString(i), i - 1 );
}
rowIndex++;
}

Again, many thanks. (And sorry about that re-post of my original message--If it was my fault, it was inadvertent)

[Goodz13]

Don't worry about the repost, I just figured that it would be easier for someone to answer if they could see the whole problem, that's why I combined the threads.