db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: using timestamp with time zone
Date Wed, 02 Jan 2008 21:34:53 GMT
Some quick research on this indicated that this seems
to be a problem with the JDBC Timestamp API which does
not allow for the TimeZone part of the SQL data.  My
guess is that JDBC drivers for SQL servers that support
this column type convert this into the correct GMT 
time representation or supply a JDBC specific object
to support this.

Of course, this problem is compounded by the fact that
there is a LOT of variations of how different DB engines
(and version of them) support this column.

That said, there may be a couple of ways to deal with 
your problem in a local manner.

First, do you REALLY need that type of column?  Timezone
is really a display issue and not a storage one.  A date 
inserted into a DB Timestamp column using a Java Date object 
that has been created using Timezone parsing will be the
correct time if it is displayed with any associated TimeZone

If you really need this, then you might look at using a 
VARCHAR setting in the XML with the underlying DB manually
set to TIMESTAMP WITH TIMEZONE.  This should return your
JDBC's <ColumnObject>.toString() representation.  You can 
then locally override/add your own methods for converting 
too and from a Java date object via the String representation.

> -----Original Message-----
> From: Raul Acevedo [mailto:raul@cantara.com] 
> Sent: Thursday, December 27, 2007 9:23 PM
> To: torque-user@db.apache.org
> Subject: using timestamp with time zone
> Can Torque work with timestamp with time zone columns?  I have two
> problems:
> 1.  Torque's XML mapping DTD doesn't allow "timestamp with 
> time zone", only "timestamp".
> 2.  If I change the column type in the database, Torque 
> always reads null from that column.
> Is it possible for this to work?  Many thanks,
> Raul Acevedo
> http://www.cantara.com
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message