TORQUE 3 is genetarting for SQL Server the date in the format: '20070130
00:00:00' but SQL Server 2005 is not working with this format. Is posible
change the output date format in TORQUE?
2008/1/4, Raul Acevedo <[EMAIL PROTECTED]>:
>
> If I didn't need to do this I wouldn't be asking. :)
>
> I was hoping to avoid overriding/adding methods to do a conversion, the
> whole point is to have Torque handle this automatically.
>
> Raul
>
> On Wed, 2008-01-02 at 16:34 -0500, Greg Monroe wrote:
> > 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
> > setting.
> >
> > 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 .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:[EMAIL PROTECTED]
> > > 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
