I compare the structure tables of hypersonic database and postgres database
:
- the columns user_id is not an identity column (as in the
turbine-postgres.sql file)
I succeeded an insert sql in the turbine_user in the psql tool.
I don't understand why user_id has a null value
org.apache.jetspeed.services.security.UserException: Failed to create
account 'test': ERROR: ExecAppend: Fail to add null value in not null
attribute user_id
is there any users that use postgresql with jetspeed?
----- Original Message -----
From: "Don Hill" <[EMAIL PROTECTED]>
To: "Jetspeed Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 5:55 PM
Subject: Re[2]: postgresql
> 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]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
