HXTT DBF
hxxt return date
dms2000
2010-05-21 09:41:03.0
Hi

The driver always saves the date as GMT. How can I return or save the local date.

Code:

TimeZone newZone = TimeZone.getTimeZone("GMT+2");
TimeZone.setDefault(newZone);
Calendar calendar = Calendar.getInstance();

java.sql.Timestamp date1 = new java.sql.Timestamp(calendar.getTime().getTime());
System.out.println("Date1: "+date1);
System.out.println(calendar.getTimeZone());

Class.forName("com.hxtt.sql.dbf.DBFDriver");
String jdbcConnection = "jdbc:dbf:/d:/dms2000/data/dms";
String sql = "select * from hxtt" ;

Properties props = new Properties();
props.setProperty("timezone","local");

Connection conn = DriverManager.getConnection("jdbc:dbf:/d:/dms2000/data/dms?lockType=DBASE4BDE",props);
PreparedStatement ps = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ps.executeQuery();
ResultSet rs = ps.getResultSet();
if(rs.next()){
rs.updateTimestamp("TIMESTAMP1", date1);
rs.updateRow();
rs.first();
System.out.println("Return: "+rs.getObject("TIMESTAMP1"));
}

rs.close();

Results;

Date1: 2010-05-21 18:31:25.56
sun.util.calendar.ZoneInfo[id="GMT+02:00",offset=7200000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]

Return: 2010-05-21 16:31:25.56
Re:hxxt return date
HXTT Support
2010-05-24 03:57:44.0
>The driver always saves the date as GMT.
Changed again:( Please download the latest package.


Google