Re[2]: [JBoss-user] Single instance entity bean
I think, this is the case for unknown primary key. alex You can't add a another column to have a primary key? -- Scott Stark Chief Technology Officer JBoss Group, LLC 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
Re: [JBoss-user] Single instance entity bean
You can't add a another column to have a primary key? -- Scott Stark Chief Technology Officer JBoss Group, LLC 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
[JBoss-user] Single instance entity bean
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