Hello,
I have a problem with my postgresql database.
I can't add un new user.
What's the problem.
Thank for the help.
This is my conf:
torque.database.default=default
torque.database.default.adapter=postgresql
torque.dsfactory.default.connection.driver = org.postgresql.Driver
torque.dsfactory.default.connection.url = jdbc:postgresql://127.0.0.1:5432/jetspeedDB
torque.dsfactory.default.connection.user = sa
torque.dsfactory.default.connection.password =
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
This is the error:
<!--StartFragment-->Horrible Exception: java.lang.reflect.InvocationTargetException:
java.sql.SQLException: ERROR: ExecAppend: Fail to add null value in not null
attribute user_id
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
at com.workingdogs.village.Record.saveWithInsert(Unknown Source)
at com.workingdogs.village.Record.save(Unknown Source)
at com.workingdogs.village.Record.save(Unknown Source)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:891)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:242)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:215)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:309)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:134)
at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:238)
at
org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doInsert(UserUpdateAction.java:251)
