public int getConnectionType(Connection cn) throws SQLException {
String DatabaseProductName = cn.getMetaData().getDatabaseProductName().trim();
if (DatabaseProductName.equals("Oracle"))
return 1;
if (DatabaseProductName.equals("Microsoft SQL Server")) {
return 2;
}
return 3;
}