Hi,
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
pstmt.executeUpdate();
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?
Thanks,
Laura
|
|
You can use timezone=GMT connection property.
|
I tried setting Connection property in two ways:
DriverManager.getConnection("jdbc:access:/\\\\is-host\\Inputs\\a.mdb?timezone=GMT");
or
Properties props = new Properties();
props.setProperty("timezone","GMT");
accessConnection = DriverManager.getConnection("jdbc:access:/\\\\is-host\\Inputs\\a.mdb",props);
But neither of these works..Am I doing smth wrong?
Laura
|
|
Please download the latest package, then use timezone=local connection property.
|
Main
webmaster@hxtt.com