HI ,
I am using MS Access Database with jdbcOdbc Bridge driver (sun.jdbc.odbc.JdbcOdbcDriver) .
I am trying to use following code .. for all the Get of COLUMN_TYPE and TYPE_NAME is works fine but for NULLABLE Get it give some constant value even though the column is NOT NULL .. can u plz suggest .

DatabaseMetaData dbmd ;
ResultSet rs ;
Connection con;
Statement stmt;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch( java.lang.ClassNotFoundException excp )
{
String sData = " No Class Defination Found" ;
}
try
{
Connection connection= DriverManager.getConnection("jdbcdbc:TestAccess");
dbmd = connection.getMetaData();
rs = dbmd.getColumns(null,null,"Employee","%");
while (rs.next())
{
System.out.println(rs.getString("COLUMN_NAME")+" "+ rs.getInt(11)) ;
}
}
catch (Exception e)
{
System.out.println("Exception " + e) ;
}

can any one plz suggest and comments on this ...
I need this urgently ...