Classics Forum

Compile error

Posted By: Sharp, Kirk (USMS)
Date: Monday, 28 November 2005, at 5:25 p.m.

While attempting to compile the following code, I get the following error message for each 'System.out.println...Data...' line of code:

...<location>...java:<line#>: cannot resolve symbol
[javac] symbol : variable Data
[javac] System.out.println(" " + Data.format(colName, 19) + " "
+ Data.format(colType, 13) + " ");

Any ideas as to what I'm doing wrong (refer to lines in bold print)?

Thanks
Kirk

import java.lang.*;
import java.sql.*;

class DtInfo
{
public static void main(String argv[])
{
try
{
Db db = new Db(argv);

System.out.println();
System.out.println(
"THIS SAMPLE SHOWS HOW TO GET INFO ABOUT DATA TYPES.");

// connect to the 'sample' database
db.connect();

// Get information about the Data type
infoGet(db.con); db.con.commit(); // disconnect from the 'sample' database
db.disconnect();
}
catch (Exception e)
{
JdbcException jdbcExc = new JdbcException(e);
jdbcExc.handle();
}
} // main

static void infoGet(Connection con)
{
try
{
System.out.println();
System.out.println(
"----------------------------------------------------------\n" +
"USE THE JAVA APIs:\n" +
" Connection.getMetaData()\n" +
" ResultSet.getTypeInfo()\n" +
" ResultSetMetaData.getMetaData()\n" +
"TO GET INFO ABOUT DATA TYPES AND\n" +
"TO RETRIEVE THE AVAILABLE INFO IN THE RESULT SET.");

DatabaseMetaData dbMetaData = con.getMetaData();

// Get a description of all the standard SQL types supported by
// this database
ResultSet rs = dbMetaData.getTypeInfo();

// Retrieve the number, type and properties of the resultset's columns
ResultSetMetaData rsMetaData = rs.getMetaData();

// Get the number of columns in the ResultSet
int colCount = rsMetaData.getColumnCount();
System.out.println();
System.out.println(
" Number of columns in the ResultSet = " + colCount);

// Retrieve and display the column's name along with its type
// and precision in the ResultSet
System.out.println();
System.out.println(" A LIST OF ALL COLUMNS IN THE RESULT SET:\n" +
" Column Name Column Type\n" +
" ------------------- -----------");

String colName, colType;
for (int i = 1 ; i <= colCount ; i++)
{
colName = rsMetaData.getColumnName(i);
colType = rsMetaData.getColumnTypeName(i);
System.out.println(
" " + Data.format(colName, 19) +
" " + Data.format(colType, 13) + " ");
}

System.out.println();
System.out.println(
" HERE ARE SOME OF THE COLUMNS' INFO IN THE TABLE ABOVE:\n"+
" TYPE_NAME DATA_ COLUMN NULL- CASE_\n"+
" TYPE _SIZE ABLE SENSITIVE\n"+
" (int) \n"+
" ------------------------- ----- ---------- ----- ---------");

String typeName;
int dataType;
Integer columnSize;
boolean nullable;
boolean caseSensitive;

// Retrieve and display the columns' information in the table
while (rs.next())
{
typeName = rs.getString(1);
dataType = rs.getInt(2);
if (rs.getInt(7) == 1)
{
nullable = true;
}
else
{
nullable = false;
}
if (rs.getInt(8) == 1)
{
caseSensitive = true;
}
else
{
caseSensitive = false;
}
if (rs.getString(3) != null)
{
columnSize = Integer.valueOf(rs.getString(3));
System.out.println(
" " + Data.format(typeName, 25) +
" " + Data.format(dataType, 5) +
" " + Data.format(columnSize, 10) +
" " + Data.format(String.valueOf(nullable), 5) +
" " + Data.format(String.valueOf(caseSensitive), 10));
}
else
// for the distinct data type, column size does not apply
{
System.out.println(
" " + Data.format(typeName, 25) +
" " + Data.format(dataType, 5) +
" n/a" +
" " + Data.format(String.valueOf(nullable), 5) +
" " + Data.format(String.valueOf(caseSensitive), 10));
}
}
// close the result set
rs.close();
}
catch (Exception e)
{
JdbcException jdbcExc = new JdbcException(e);
jdbcExc.handle();
}
}
} // DtInfo


Thanks

Classics Forum is maintained by Administrator with WebBBS 5.12.