I think, this is the case for unknown primary key. alex
You can't add a another column to have a primary key? -- xxxxxxxxxxxxxxxxxxxxxxxx Scott Stark Chief Technology Officer JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx Martin Vilcans wrote: > Hi! > > A simple question: How do I create a CMP entity bean with only one instance? > > I need an entity bean that holds the current date as a week and a day > number, stored as two columns in a table with only one row. Since there's > only one row in the table, I don't need a primary key. > > I have created a PK class without any fields, but this doesn't work as JBoss > generates invalid SQL: "SELECT FROM currentDate WHERE". This should have > been "SELECT week, day FROM currentDate". > > How do I do this without resorting to BMP or a dummy PK? > > Thanks. > > Martin > ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user