cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Terry Jeske" <terry.je...@gmail.com>
Subject Lookup tables
Date Thu, 21 Dec 2006 00:34:17 GMT
Hello,

I have been working some with Hibernate, and while I like a lot of what it
has to offer, but I am constantly frustrated with things that would be a no
brainier sql query, that takes hours if not days to try in shoehorn into
their paradigm. Here is a scenario that you cannot do in Hibernate and I am
wonder if it is possible in Cayenne:

Here is a table structure:

projects_table
--------------------------------
id int
projectname varchar
status int


status_table
------------------------------
projectId int (fkey back to projects_table id)
status_name varchar


I have a project object as with the following variables:

Project.java
---------------------------------
int id
String projectName
String statusName

Hibernate does not support this, and to get around it I have had to create a
view that hibernate pulls from. We like having the status_table look-up
because it makes it easy to return sorted lists of projects, while giving us
the freedom to change status text.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message