//define the data source for chiver
// String sourceURL="jdbc:odbc:test";
//create connection through the DriverManager
// Connection databaseConnection=DriverManager.getConnection(sourceURL);
Connection databaseConnection=DriverManager.getConnection(sourceURL,prop);
Statement statement=databaseConnection.createStatement();
ResultSet authorNames=statement.executeQuery(
"SELECT au_lname,au_fname FROM pubs.dbo.authors ORDER BY au_lname DESC,au_fname DESC");
ResultSetMetaData metaData=authorNames.getMetaData();
int columns=metaData.getColumnCount();
System.out.println("columns="+columns);
int row=0;
while (authorNames.next())
{
System.out.print("\nRow"+(++row)+":");
for (int i=1;i<=columns;i++)
if (metaData.getColumnType(i)==Types.VARCHAR) //if it is char
System.out.print(" "+authorNames.getString(i));
}
}