wood burning stoves*
The moose likes JDBC and the fly likes HSQL-related question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HSQL-related question" Watch "HSQL-related question" New topic

HSQL-related question

Cloey Tan
Ranch Hand

Joined: Feb 03, 2009
Posts: 60
Im working on some hsql dynamic generation. Since Im not that familiar with the hsql query, would like to seek some help here regarding this particular case. Assuming that
I have a User entity, and related to Role Entity.

public class User{
protected List<Role> roles;

is it relevant to put >> select user from User as user AND user.roles as userRole WHERE userRole.name='super'
in order to select all users with the role name 'super'??
Rob Spoor

Joined: Oct 27, 2005
Posts: 19649

Moving to JDBC

How To Ask Questions How To Answer Questions
I agree. Here's the link: http://aspose.com/file-tools
subject: HSQL-related question
Similar Threads
How to create a role in LifeRay
Unauthenticatedidentity previliges - JBoss security
jdbc hsqldb issue - table not found
Usage of Reserved words for Database Table fields
Need help for Many to Many association