0 Replies Latest reply on Mar 6, 2003 7:48 AM by phi15

    findAll does not work

    phi15

      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