db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Eric Miller" <jemil...@uchicago.edu>
Subject Re: Question about UPPER/UCASE
Date Thu, 27 Jan 2005 18:22:23 GMT
One thing that I noticed about the DerbyDialect is that if you use the EJB 
3.0 GeneratorType.AUTO, it uses a hi/lo table instead of an identity column? 
I wonder if that is on purpose?

@Id(generate=GeneratorType.AUTO)

Jon

----- Original Message ----- 
From: "Jim Murphy" <jmurphy@mindreef.com>
To: "'Derby Discussion'" <derby-user@db.apache.org>; "'Scott Rosenbaum '" 
<scottr@innoventsolutions.com>
Sent: Thursday, January 27, 2005 9:59 AM
Subject: RE: Question about UPPER/UCASE


> Thanks Scott,
>
> That's what I thought.  I know I can work around that way but was 
> surprised
> to encounter the syntax error in the first place.
>
> Actually its hibernate's DerbyDialect (the one mentioned in their JIRA) 
> that
> is largely based on DB2 that generated the sql.  I here getting
> hibernate/Derby support is something plenty of folks are chasing at the
> moment.  I wanted to get a gauge on how close that is.  And if this Upper
> issue has been addressed in a newer dialect?
>
> Kind regards,
>
> Jim Murphy
> Mindreef, Inc.
>
>
> -----Original Message-----
> From: Scott Rosenbaum [mailto:scottr@innoventsolutions.com]
> Sent: Thursday, January 27, 2005 11:12 AM
> To: jmurphy@mindreef.com
> Subject: FW: Question about UPPER/UCASE
>
> Just to make sure you get this, please let me know if it works.
>
>
> I would do this
>
> Select Upper(username) USERNM
>>>From users
> Order By USERNM
>
> If you want to maintain case you would have to do:
> Select Upper(username) USERNM,
>   username USERNAME
>>>From users
> Order By USERNM
>
> Use the one field to sort and the other field that maintains case
>
> Scott Rosenbaum
>
> -----Original Message-----
> From: Jim Murphy [mailto:jmurphy@mindreef.com]
> Sent: Thursday, January 27, 2005 8:03 AM
> To: 'Derby Discussion'
> Subject: Question about UPPER/UCASE
>
> Should this work, assuming a user table with the right shape?
>
> select username from users order by upper(username)
>
> I get syntax error @ "upper"
>
> Regards,
>
> Jim Murphy
> Mindreef, Inc.
>
>
> 


Mime
View raw message