import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;


public class test770 {
    public static void main(String[] args) throws SQLException {
        try (Connection con = DriverManager
                .getConnection("jdbc:sqlserver://localhost;user=sa;password=***")) {
            testIssue770(con, "incoming_correspondence", new Long("736463"));
        }
    }

    public static void testIssue770(Connection con, String tableName,
            final Long versionId) {
        try (Statement stmt = con.createStatement()) {
            stmt.execute("CREATE TABLE \"dbo\".\"incoming_correspondence\" (" +
                    "\"version_Id\" bigint NOT NULL," +
                    "\"IncomingNo\" varchar(100) NULL," +
                    "\"Date\" decimal(18,5) NULL," +
                    "\"ExtEntityOutgoingNo\" varchar(50) NULL," +
                    "\"ExtDate\" decimal(18,5) NULL," +
                    "\"IncomingType\" varchar(50) NULL," +
                    "\"ExternalEntity\" varchar(50) NULL," +
                    "\"barcode\" varchar(100) NULL," +
                    "\"ExternalEntityCode\" varchar(50) NULL," +
                    "\"RoutingSource\" varchar(50) NULL," +
                    "\"ElectronicDesc\" varchar(4000) NULL," +
                    "\"OriginalSourceUnit\" varchar(50) NULL," +
                    "\"Routing\" varchar(1024) NULL," +
                    "\"OtherRouting\" varchar(50) NULL," +
                    "\"correspondent\" varchar(100) NULL," +
                    "\"attachmentsDesc\" varchar(4000) NULL," +
                    "\"incomingDeliveryMethod\" varchar(50) NULL," +
                    "\"concernedState\" varchar(50) NULL," +
                    "\"concernedStateOptions\" varchar(50) NULL," +
                    "\"original_paper_code\" varchar(50) NULL," +
                    "\"test_field\" varchar(50) NULL," +
                    "\"corr_status\" varchar(1024) NULL," +
                    "\"signature\" varbinary(max) NULL," +
                    "\"attachments\" varchar(50) NULL," +
                    "CONSTRAINT \"PK__name_inco__07A684B1737A6C8B\" PRIMARY KEY CLUSTERED(\"version_Id\")" +
                    "ON [PRIMARY]);");
            for(int i=1;i<100;i++) {
                stmt.execute(
                        "INSERT INTO incoming_correspondence "
                        + "(version_Id,IncomingNo,Date,ExtEntityOutgoingNo,ExtDate,IncomingType,"
                        + "ExternalEntity,barcode,ExternalEntityCode,RoutingSource,ElectronicDesc,"
                        + "OriginalSourceUnit,Routing,OtherRouting,correspondent,attachmentsDesc,"
                        + "incomingDeliveryMethod,concernedState,concernedStateOptions,original_paper_code,"
                        + "test_field,corr_status,signature,attachments) "
                        + "VALUES(" + (versionId+i) + ",null,2458331.50000,null,null,'190','102',null,'102','100',null,null,"
                        + "'أخرى',null,null,null,null,'جمهورية كوريا الجنوبية','180',null,null,null,"
                        + "CONVERT(varbinary,'696d6167652f6a7369676e61747572653b6261736533302c32495a3232303059333536366561383833343566696863335a32353535376663636662383739626864383359326b5f314a5a333661393535303059646563383231305a36613838353632313030593638383935333130305a343432323330'),"
                        + "'ff')");
            }

            for(int i=1;i<100;i++) {
                String queryStr = "select * from " + tableName + " where version_id = " + (versionId+i);
                try(ResultSet rs = stmt.executeQuery(queryStr)) {
                    ResultSetMetaData meta = rs.getMetaData();
                    while (rs.next()) {
                        for (int c = 1; c <= meta.getColumnCount(); c++) {
                            System.out.print(rs.getObject(meta.getColumnName(c))+ " | ");
                        }
                        System.out.println();
                    }
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}