Subject | Sorted DatabaseMetaData ResultSets |
---|---|
Author | Marcelo Comazzi Gonçalves |
Post date | 2004-04-27T17:36:15Z |
Hi.
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
("COLUMN_NAME")};
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 ...) ?
Thanks,
Marcelo.
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
("COLUMN_NAME")};
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 ...) ?
Thanks,
Marcelo.