[SOLVED] Re: How to know columns names in Derby database table

Hi!

With this code I get the columns names:

<!-- BEGIN CODE -->
public String[] getColumnsNames(String table) {
Vector<String> vNames = new Vector<String>();
String query = "select * from bornes";
String[] names;
try {
PreparedStatement pstmt;
ResultSetMetaData rsmd;
int numColumns, i = 1;
if (con == null) {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
con = DriverManager.getConnection("jdbc:derby:"+
"/home/koxo/tmp/db/tests/ubicharge");
}
pstmt = con.prepareStatement(query);
rsmd = pstmt.getMetaData();
numColumns = rsmd.getColumnCount();
while (i <= numColumns) {
String str = rsmd.getColumnName(i);
System.out.println(str);
vNames.add(str);
i++;
}
} catch (SQLException sqle) {
System.out.println(sqle.toString());
}
catch(Exception e) {
System.out.println("getColumnNames: "+e.toString());
e.printStackTrace();
}
names = new String[vNames.size()];
for (int i=0 ; i<vNames.size(); i++) {
names[i] = new String(vNames.elementAt(i));
}
try {
con.close();
} catch (SQLException sqle) {
System.out.println("close: "+sqle.toString());
sqle.printStackTrace();
}
return names;
}

<!-- END CODE -->

What I don't know is if there is any better option for making it.

Bye!

--
Slackware 11.0.0 (kernel 2.6.22 i686) Gnome 2.16.3
Intel(R) Core(TM)2 Quad CPU (2260.386 MHz) up 6 days, 4:42
Hattrick: Zanzabornín (1457021) X.1762 # Jabber: laffdez@xxxxxxxxx
Sokker: C.D. Arrancatapinos (18088) IV.57 # Linux User #99754
.