Subject Re: [Firebird-Java] Sorted DatabaseMetaData ResultSets
Author Blas Rodriguez Somoza

At 27/04/2004 19:36, you wrote:
>I have the follow lines:
>c = java.sql.DriverManager.getConnection(databaseURL, user, password);
>java.sql.DatabaseMetaData dbMetaData = c.getMetaData ();
>java.sql.ResultSet rsIndices = dbMetaData.getPrimaryKeys(null,null,table);
>String[] strIndices = {rsIndices.getString"KEY_SEQ"),tables.getString
>My work will be more easier if the returning ResultSet is ordered by
>KEY_SEQ. I need this
>ResultSet to be ordered. Now I have to code a new routine to sort it.
>Can you guys make all the ResultSets in the DatabaseMetaData sortered
>by default (columns, indexes,
>tables ...) ?

The jdbc standard states very clearly that the ResultSet from a
getPrimaryKeys should be ordered by "COLUMN_NAME".

Could be wise or not but this is the standard.


Blas Rodriguez Somoza