Example - Using Weblogic’s Oracle Driver -III

//display the metadata information like max size. column type name etc.

for (int i = 1; i <= rsmd.getColumnCount(); i++) {

System.out.println(“Column Name :” + rsmd.getColumnName(i));

System.out.println(“Nullable :” + rsmd.isNullable(i));

System.out.println(“Precision :” + rsmd.getPrecision(i));

System.out.println(“Scale :” + rsmd.getScale(i));

System.out.println(“Size :” + rsmd.getColumnDisplaySize(i));

System.out.println(“Column Type :” + rsmd.getColumnType(i));

System.out.println(“ColType Name :” + rsmd.getColumnTypeName(i));

System.out.println(“ “);

}

//close the query connection states and then close the database connection

stmt.close();

conn.close();

} // end main

} // end myTest class

Previous slide

Next slide

Back to first slide

View graphic version