2 Replies Latest reply on Sep 13, 2011 8:52 AM by Rabee Rahimzadeh

    JBossESB4.9 - switching to postgres

    Rabee Rahimzadeh Newbie

      Hi,

       

      I am using esb 4.9 with jbosseap 5.1.0 . I configured esb to work with postgres acoording the following link:

       

      http://community.jboss.org/wiki/JBossESBSwitchDatabase

       

      But When I fire up the server, I get the following exception:

       

       

      org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint

              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)

              at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)

              at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)

              at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)

       

       

      Any help would be appreciated.

       

      Thanks,

      Rabee