Hi Vincent,
I've tried to reproduce your issue, but it works fine for me.
I think you should check your JDBC driver.
I use the following:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
2015-10-01 12:16 GMT+03:00 Andrus Adamchik <[email protected]>:
> Never used datetimeoffset. Will need to experiment with it... If the
> driver doesn't read it properly, perhaps we'll can address that in the
> adapter code for SQLServer. I'll put it on my TODO.
>
> Andrus
>
> > On Sep 30, 2015, at 9:48 PM, Vincent Smith <[email protected]> wrote:
> >
> > I am using Cayenne 3.0 and Sql Server 2014. I have a column in my sql
> Server schema with a type of datetimeoffset. My problem is this. Cayenne
> can convert that column into a java.util.Date without error, but I lose the
> hours, minutes, and seconds precision. When I try to use
> java.sql.Timestamp, I get the following error:
> >
> >
> > java.sql.SQLException: Value 2015-09-28 11:15:18.4170238 -05:00 cannot
> be converted to TIMESTAMP.
> >
> >
> > Is there any Cayenne type I can use to convert a datetimeoffset into a
> java Timestamp or Calendar object and maintain the hours, mins, and seconds?
> >
>
>
