Hi everybody,
I'm using middlegen to generate the CMP Layer for JBoss 3.0.4 and PostgreSQL 7.2.1.
I have the following table:
CREATE TABLE country (
id INTEGER NOT NULL,
date DATE DEFAULT CURRENT_DATE,
effective BOOL,
code VARCHAR(4) NOT NULL,
name VARCHAR(255) NOT NULL,
PRIMARY KEY(id, date)
);
GRANT ALL ON country TO GROUP jboss;
When I call the findAll method against an empty table everything works fine. But if there is any data I get this exception
>>>
13:34:47,023 ERROR [LogInterceptor] NoSuchEntityException:
javax.ejb.NoSuchEntityException: Entity not found: primaryKey=[.1.2003-03-06 00:00:00.0.]
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:170)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:62)
....
<<<
When I search in psql manually with the given keys data is found?
Any hints?
Thanks,
Philipp