Hello Antoine, Tuesday, January 21, 2003, 11:00:28 AM, you wrote:
AS> Please, AS> somebody can help me AS> Thanks AS> ----- Original Message ----- AS> From: "Antoine Santos" <[EMAIL PROTECTED]> AS> To: "Jetspeed Users List" <[EMAIL PROTECTED]> AS> Sent: Monday, January 20, 2003 4:10 PM AS> Subject: postgresql AS> Hello, AS> I have a problem with my postgresql database. AS> I can't add un new user. AS> What's the problem. AS> Thank for the help. AS> This is my conf: AS> torque.database.default=default AS> torque.database.default.adapter=postgresql AS> torque.dsfactory.default.connection.driver = org.postgresql.Driver AS> torque.dsfactory.default.connection.url = AS> jdbc:postgresql://127.0.0.1:5432/jetspeedDB AS> torque.dsfactory.default.connection.user = sa AS> torque.dsfactory.default.connection.password = AS> torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc AS> eFactory AS> torque.dsfactory.default.pool.defaultMaxConnections=10 AS> torque.dsfactory.default.pool.maxExpiryTime=3600 AS> torque.dsfactory.default.pool.connectionWaitTimeout=10 AS> This is the error: AS> <!--StartFragment-->Horrible Exception: AS> java.lang.reflect.InvocationTargetException: java.sql.SQLException: ERROR: AS> ExecAppend: Fail to add null value in not null attribute user_id AS> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) AS> at AS> org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection AS> .java:505) AS> at AS> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j AS> ava:320) AS> at AS> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j AS> ava:48) AS> at AS> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State AS> ment.java:197) AS> at com.workingdogs.village.Record.saveWithInsert(Unknown Source) AS> at com.workingdogs.village.Record.save(Unknown Source) AS> at com.workingdogs.village.Record.save(Unknown Source) AS> at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:891) AS> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725) AS> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615) AS> at AS> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur AS> bineUserPeer.java:242) AS> at AS> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur AS> bineUserPeer.java:215) AS> at AS> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser( AS> TurbineUserManagement.java:309) AS> at AS> org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana AS> gement.java:134) AS> at AS> org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java: AS> 238) AS> at AS> org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doIns AS> ert(UserUpdateAction.java:251) AS> -- AS> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> AS> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> Seems to me that you need to compare the tables that come with Jetspeed hypersonic and postgres, is there identity columns, have you created some columns with a not null attr. Another test would be to get the sql that is being executed, try to execute it in the psql tool, does it suceed or do you get the same error. HTH -- Best regards, Don mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
