Re: Classloading issue in Derby function

2013-11-07 Thread Knut Anders Hatlen
Pugazhal Srinivasan writes: > In a application server we configure and use the Embedded derby server > to register a derby function table (in EJB in our case) and are able > to call the function from other places in the application, including > servlet. > > But we are unabl

Classloading issue in Derby function

2013-11-06 Thread Pugazhal Srinivasan
In a application server we configure and use the Embedded derby server to register a derby function table (in EJB in our case) and are able to call the function from other places in the application, including servlet. But we are unable to call the same function using ij. The error is "

RE: Derby Function

2006-03-07 Thread Michael Segel
Subject: Re: Derby Function   Sorry,   I mean GROUP BY YEAR(), MONTH(), DAY() in Derby.

Re: Derby Function

2006-03-06 Thread Max Ten
Sorry,   I mean GROUP BY YEAR(), MONTH(), DAY() in Derby.

Re: Derby Function

2006-03-06 Thread Daniel John Debrunner
Max Ten wrote: > Unfortunately there are no such functions in Derby... so i need to > store the number of year, month and day in different columns. Which functions exactly are you looking for? YEAR, MONTH and DAY all exist in Derby 10.2 E.g. http://db.apache.org/derby/docs/10.1/ref/rre

Re: Derby Function

2006-03-06 Thread Max Ten
Unfortunately there are no such functions in Derby... so i need to store the number of year, month and day in different columns.

RE: Derby Function

2006-03-06 Thread derby
51 PM > To: Max Ten; Stanley Bradbury; Derby Discussion > Subject: RE: Derby Function > > Hi Max, > > Another option would be to use the MetaMatrix Query product on top of > Derby. MetaMatrix Query is a federated SQL engine with a JDBC driver > that supports Oracle, SQL Server, S

RE: Derby Function

2006-03-05 Thread Alex Miller
://devcentral.metamatrix.com/blog/alex/2006/02/28/Enhancing-Apache-D erby-with-MetaMatrix. Alex Miller Chief Architect MetaMatrix -Original Message- From: Stanley Bradbury [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 1:13 PM To: Derby Discussion Subject: Re: Derby Function Max Ten wrote

Re: Derby Function

2006-03-01 Thread Stanley Bradbury
Max Ten wrote: if i'm not misunderstood your explanation, tats mean i have to store ex: 2006-10-31 to 3 different columns, (Yr) for 2006, (Mth) for 10 and (Dy) for 31. By this way i can use the function "GROUP BY" for those columns. Anyway, will it be any enhancement for function "GROUP BY" i

Re: Derby Function

2006-02-28 Thread Max Ten
if i'm not misunderstood your explanation, tats mean i have to store ex: 2006-10-31 to 3 different columns, (Yr) for 2006, (Mth) for 10 and (Dy) for 31.By this way i can use the function "GROUP BY" for those columns. Anyway, will it be any enhancement for function "GROUP BY" in future?Thanks Stanl

Re: Derby Function

2006-02-27 Thread Stanley Bradbury
Max Ten wrote: Is there any function for - GROUP BY YEAR(), GROUP BY MONTH(), GROUP BY QUARTER() in derby? Hi - There are functions but they are not supported in a GROUP BY clause in Derby. The workaround (a bit kludgy) is to translate the values returned by the function to table data valu

Derby Function

2006-02-26 Thread Max Ten
Is there any function for - GROUP BY YEAR(), GROUP BY MONTH(), GROUP BY QUARTER() in derby?