metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Sørensen <i.am.kasper.soren...@gmail.com>
Subject Re: Metamodel timestamp issue for MSSQL
Date Wed, 28 May 2014 08:53:50 GMT
Hi Balendra,

OK thanks for clearing that up.

I suggest we register a bug in JIRA [1] about this and fix it on high
priority.
Would you be interested in submitting a patch?

[1] https://issues.apache.org/jira/browse/METAMODEL

Best regards,
Kasper


2014-05-28 5:57 GMT+02:00 Balendra Singh <balendrasingh@gmail.com>:

> Hi Kasper,
>
> We are using *datetime *datatype to store dates in the table.
>
>
>
> Thanks,
> Balendra
>
>
> On 27 May 2014 19:24, Kasper Sørensen <i.am.kasper.sorensen@gmail.com
> >wrote:
>
> > Hi Balendra,
> >
> > I think you may have catched a bug that we should look into. Looking
> > at SQLServerQueryRewriter I don't see any special handling of date/time
> > literals in MS SQL, but I do see in the docs for MS SQL server [1] that a
> > number of literals are possible, but none of them complies with the
> > standard format of MetaModel.
> >
> > In addition I looked to one of my favourite SQL dialect comparison papers
> > [2] and it says that timestamp in MS SQL is deprecated and that DATETIME
> > type is preferred. I doubt it has any impact on the query literals, but
> > just wondering which type you use?
> >
> > Best regards,
> > Kasper
> >
> > [1] http://msdn.microsoft.com/en-us/library/ms710282(v=vs.85).aspx and
> > http://msdn.microsoft.com/en-us/library/ms187819.aspx
> >
> > [2] http://troels.arvin.dk/db/rdbms/#data_types-date_and_time-timestamp
> >
> >
> > 2014-05-27 12:21 GMT+02:00 Balendra Singh <balendrasingh@gmail.com>:
> >
> > > Hi,
> > >
> > > I am using the following query in my application. This application is
> > using
> > > DB2, Postgres, Oracle and MSSQL databases.
> > > But the following is not being executed in MSSQL saying* Incorrect
> syntax
> > > near '2014-05-26 16:02:45'.*
> > >
> > > *UPDATE <Table name> SET <column name>=? WHERE (<timestamp column>
<
> > > TIMESTAMP '2014-05-26 16:02:45')*
> > >
> > > I am creating this query using FilterItem.
> > > After modifying the query with addition of CAST in the query, I am able
> > to
> > > execute the following query in MSSQL client -
> > >
> > > *UPDATE <Table name> SET <column name>=? WHERE (<timestamp
> > > column> < CAST('2014-05-26 16:02:45' AS DATETIME))*
> > >
> > > *I debugged the code and found that
> > > in org.eobjects.metamodel.util.FormatHelper.formatSqlTime(ColumnType,
> > Date,
> > > boolean, String, String), *we are appending this extra TIMESTAMP
> > > as typePrefix in the query.
> > >
> > > Am I missing something or the Metamodel is not generating query
> correctly
> > > compatible for MSSQL.
> > > Please provide your input.
> > >
> > >
> > >
> > > Thanks,
> > > Balendra
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message