Hi,

I had the same bug with IC 1.6 (it is a bug) and it should be fixed in IC
2 - apparently, not. Where did you get your build of IC 2?

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."



"Marcello Mannino" <interbase@...> wrote in message
news:422953054.20010904010329@......

> Hi all!
> I have a problem with a query used by Jive forum.
> Could you confirm that is an Interclient bug ?
>
> Windows 2000
> WI-T0.9.4.41 Firebird Test1
> InterClient, version 2.1.5 for JRE 1.3 and InterBase v5 and v6
>
> TIA,
> Marcello
>
> ===8<==============Original message text===============
> Marcello,
>
> > I had a look at the sources and saw what is the other problem.
> > The following query:
> >
> > private static final String POPULAR_THREADS =
> > "SELECT /*+ INDEX (jiveMessage jiveMessage_mDate_idx) */
> > threadID, " +
> > "count(1) AS msgCount FROM jiveMessage WHERE modifiedDate > ? "

+

> > "AND forumID=? GROUP BY threadID ORDER BY msgCount DESC";
> >
> > is not good for Interbase. I had to change the ORDER BY clause with
> > the following: ORDER BY 2 DESC
> >
> > What about moving all these queries out of the sources, like a
> > SQL.xml configuration file ?
> > I think it will be easier to mantain and to support different SQL
> > syntaxes.
>
> This is a bug in the Interbase JDBC driver, right? -- i.e., it doesn't
> support the "AS" syntax correctly? In general, our goal is to make the SQL
> queries work across all databases. This makes maintenance much, much

easier

> for us compared to external SQL. Is there a version of Interbase that has
> this bug fixed? I remember it from 6 months ago or longer.
>
> Thanks,
> Matt
>
> _______________________________________________
> Jive-dev mailing list
> Jive-dev@...
> http://www.jivesoftware.com/mailman/listinfo/jive-dev
>
> ===8<===========End of original message text===========
>
>
>
> --
> Best regards,
> Marcello mailto:java@...
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>