Concurrency Issue With Rollback

2009-10-12 Thread quinya
Hi, I am using a timestamp to manage concurrency. But I'm having a problem when a transaction is rolled back. I update the timestamp when the object is saved. It works great. But if the save is just one part of the transaction and the transaction fails and rolls back, then the object is left wi

Re: like issue plz help me

2009-09-23 Thread quinya
Not sure if I understand right but can't you just do... select * from Someone where UPPER(name) like UPPER(#name# ) Then put the '%' in the actual name proerty value. As in String s = "%nameParamValue%"; That's how I do my LIKE statements. HelpMePlz wrote: > > Hi to all, > > select * from

Re: Outer Join - Mapping More Than One

2009-09-23 Thread quinya
Ok, I suspect the problem is to do with my query. It's returning results like this: username | authority | description | authority Maarten | ROLE_CUSTOMER | SPECIAL | ROLE_MANAGEMENT Maarten | ROLE_CUSTOMER | SPECIAL | ROLE_XYZ Maarten | ROLE_VISITOR | SPECIAL | ROLE_MANAGEMENT Maarten | ROLE_VIS

Outer Join - Mapping More Than One

2009-09-22 Thread quinya
Hi, I am having problems mapping more than one outer join to a result set. I saw another posting for a similar issue, but I still can't get it to work. I basically have three objects - User, Role and UserGroup. The respective tables have many-to-many relationships implemented with join tables.