hi all, I've got a weird problem. Using Postgres and JBoss 2.2, I have an entity bean with BMP. In my ejbCreate method I query the database to get the primary key for the bean from a sequence. My SQL is "SELECT NEXTVAL('storyid_seq')" which works fine from psql _and_ from a standard JDBC connection. I get a SQLException with the message "token NEXTVAL not allowed here" (or something like that).. I've checked all the obvious things, typos etc, and have no idea. Be greatful for any advice. cheers dim _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user