JBossESB4.9 - switching to postgres

[rabee]

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

[tcunning]

Hi Rabee,

Those instructions are for users installing onto jboss 4.2.3.GA I believe.      There's a comment at the bottom of that page which outlines some additional steps, or you can check out the instructions in the Administration Guide which also outline this.

[rabee]

I added some additional steps on that forum. Now the serrver is running correctly.

please refer to this link to follow up the new steps.

Thanks

Rabee