1 Reply Latest reply on Oct 1, 2003 8:00 PM by eric g

    entity bean in postgreSQL

    eranhovav Newbie

      Hi

      I'm working with a postgreSQL. I can establish a connection between the DB and the server (jboss). I can create tables in the DB by using a standalone java class. BUT when i'm trying to run an EJB client and create an entity bean i get this strange message:

      11:44:30,244 ERROR [CabinEJB] Error checking if entity exists
      java.sql.SQLException: ERROR: Index pk_cabinejb is not a btree

      In the jboss log file was written:

      2003-09-29 17:08:22,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Create: pk=1
      2003-09-29 17:08:22,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Executing SQL: SELECT COUNT(*) FROM cabinejb WHERE id=?
      2003-09-29 17:08:22,448 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Error checking if entity exists
      java.sql.SQLException: ERROR: Index pk_cabinejb is not a btree

      What is the root of the problem? the postgreSQL driver or jboss driver? (Which one makes the query : SELECT COUNT(*) FROM cabinejb WHERE id=?)

      I am a little confused, so I will happy for every help.

      thank you.
      eran.

        • 1. Re: entity bean in postgreSQL
          eric g Newbie

          Hi,

          to help you to debug the cause , why don't you run the postgresql under debug environment using the command postmaster -d 5 -D your datadir to locate the cause , it could be the corrupted primary key issue, just browse through the debug info provided my postmaster to confirm the fact.

          Thanks