For bulk insert from SQL Server to Access we are using
String sql = "insert into [" + access_table + "] ?;";
pstmt = accessConnection.prepareStatement(sql);
pstmt.setObject(1, eimRs);//insert a resultSet into destination table
Specification-Version: 1.1.039 on May 16, 2006 for access driver uses GMT timezone for datetime fields, but after upgrading to last version (Specification-Version: 3.2.121 on January 31, 2010) we noticed that JVM's timezone is used.
Is there any workaround for this so we could preserve driver's support of passing a resultset from a different driver and still use GMT timezone?
You can use timezone=GMT connection property.
I tried setting Connection property in two ways:
Properties props = new Properties();
accessConnection = DriverManager.getConnection("jdbc:access:/\\\\is-host\\Inputs\\a.mdb",props);
But neither of these works..Am I doing smth wrong?
Please download the latest package, then use timezone=local connection property.