public void testBug575() throws Exception {
  Statement sta=con.createStatement();
  sta.executeUpdate("create table #Bug575( A varchar(11), B int, C bit )");
  PreparedStatement ps=con.prepareStatement("update #Bug575 set A=?, C=? where B=?");
  ParameterMetaData paramMetaData=ps.getParameterMetaData();
  Assert.assertEquals("varchar",paramMetaData.getParameterType(1));
  Assert.assertEquals("int",paramMetaData.getParameterType(2));
  Assert.assertEquals("bit",paramMetaData.getParameterType(3));
}

public void testBug575 ( ) throws Exception { Statement sta = con . createStatement ( ) ; sta . executeUpdate ( "create table #Bug575( A varchar(11), B int, C bit )" ) ; PreparedStatement ps = con . prepareStatement ( "update #Bug575 set A=?, C=? where B=?" ) ; ParameterMetaData paramMetaData = ps . getParameterMetaData ( ) ; Assert . assertEquals ( "varchar" , paramMetaData . getParameterType ( 1 ) ) ; Assert . assertEquals ( "int" , paramMetaData . getParameterType ( 2 ) ) ; Assert . assertEquals ( "bit" , paramMetaData . getParameterType ( 3 ) ) ; }
test for bug # 575 , parameter types aren ' t available via parametermetadata .
