Re: [xmlblaster] possible problem about JDBC Driver

[Marcel Ruff <mr at marcelruff.info>]

zhang zhi wei wrote:
> Hi.
Hi,

thanks for reporting this bug with a solution.

> After examining the DBAdapterUtils.java,  I find the problem is the 
> following codes:
> 
> case Types.TIMESTAMP:
> columnValue = rs.getTimestamp(i).toString();
> 
> 
> When changed to the following code, it works fine.
> 
> case Types.TIMESTAMP:
> Timestamp ts=rs.getTimestamp(i);
> if (ts==null) columnValue="null" ; else columnValue=ts.toString();
> 
> 
> althrough this bug is fixed, other possible NULL values may exist.
> So If it's necessary to change all the case codes to the above style?
> please verify this!!!

I have fixed all locations now and commited
it to cvs.

> by the way, the datetime in SQLServer  is mapped to TIMESTAMP, so if 
> 2002-11-11 in SQLServer, the output is  "2004-11-24 00:00:00.0"
> how to fix this problem? just trim the 00.00.00.0? thanks a lot!

If you can't use our 'Date' which has no
time added probably trimming is the simplest way
to go,

thanks and best regards

Marcel

-- 
http://www.xmlBlaster.org